how to import an excel file to sas?
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).