Question: how to import excel file into sas dataset?
Answer: If you are using a 32-bit version of SAS, use DBMS=EXCEL in the PROC IMPORT statement. If you are using a 64-bit version of SAS, use DBMS=xls or DBMS=xlsx (whichever is appropriate for the file you're importing).