Very many businesses and organizations are common users of MS Excel files for a wide range of purposes as in data storage, analysis, reporting, etc. Therefore, MS Excel file formats are widely applied in the real world.
DBMS=XLSX informs SAS that the file being imported is a MS Excel file (with .xlsx extension).
More Options in PROC IMPORT to Import Excel File
SHEET: The name of a sheet in the Excel file from which you want to import data. When you execute PROC IMPORT without an explicit mention of the SHEET option, SAS automatically imports the first sheet from your Excel file, as a default. If you want to import a specific sheet, then you will have to type the name of the sheet.
DATAROW: It specifies the number of a row from which you want to have SAS import data. If GETNAMES=YES, the value for DATAROW must be at least 2. If GETNAMES=NO, then the value for DATAROW must be at least 1.
RANGE: The option allows you to specify the range of your Excel file. For example: RANGE="Sheet1$A1: D50"
DBMS=XLSX informs SAS that the file being imported is a MS Excel file (with .xlsx extension).
More Options in PROC IMPORT to Import Excel File
SHEET: The name of a sheet in the Excel file from which you want to import data. When you execute PROC IMPORT without an explicit mention of the SHEET option, SAS automatically imports the first sheet from your Excel file, as a default. If you want to import a specific sheet, then you will have to type the name of the sheet.
DATAROW: It specifies the number of a row from which you want to have SAS import data. If GETNAMES=YES, the value for DATAROW must be at least 2. If GETNAMES=NO, then the value for DATAROW must be at least 1.
RANGE: The option allows you to specify the range of your Excel file. For example: RANGE="Sheet1$A1: D50"