topic How to import excel file with extention xlsx? in New SAS User

How to import excel file with extention xlsx?

rajeshalwayswel — Sun, 01 Dec 2019 04:27:29 GMT

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 — Sun, 01 Dec 2019 05:00:09 GMT

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

run;

r_behata — Sun, 01 Dec 2019 05:01:19 GMT

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 :

ed_sas_member — Sun, 01 Dec 2019 08:35:16 GMT

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;