How to import excel file with extention xlsx?

[rajeshalwayswel]

I'm unable to import excel file with extension xlsx. I'm using the below code.

proc import datafile='.xlsx' dms=xlsx replace;

run;

Could you please help out how to resolve this... 

[SASKiwi]

proc import datafile='MyExcelWorkbook.xlsx' dbms=xlsx replace;

run;

[r_behata]

Try :

proc import datafile="<your-path>.xlsx" dbms=xlsx replace;

run;

If you are using SAS 9.4 M2 or above you can also use Libname XLSX :

https://blogs.sas.com/content/sasdummy/2015/05/20/using-libname-xlsx-to-read-and-write-excel-files/

[ed_sas_member]

In addition to @r_behata's and @SASKiwi's answers, it could be useful to also add:

• an OUT option in the PROC IMPORT statement to specify the name of the output SAS dataset.
• a SHEET statement to specify the name of the sheet you to be imported in case you have several ones.
• an GETNAMES statement to specify whether the first row of your Excel file contains the names of the variables (Yes | No).

proc import datafile="<your-path>.xlsx"
			dbms=xlsx
			out=<lib.dataset>
			replace;
			sheet=<sheet_name>;
			getnames=Yes;
run;