How To import .xlsx file in to sas using infile statment

[slchen]

Check this link: Reading XLSX Excel files with SAS/BASE macro - the easy way - sasCommunity

[gboor]

Maybe it is due to the typo?

I see a .xlxs extension, which should be a .xlsx extension...

[msteelman]

I use this for code for xls and xlsx files

&prjdir is a macro for the file path.

&file1 and &sheet1 are macros for the file name and sheet name you want to read

filename case DDE "Excel|&prjdir.[&file1.]&sheet2.!R<first row>C<first column>:R<last row>C<last column>" notab;
data want;
infile case dsd dlm='09'x missover pad lrecl=1500;
length <vars with lengths>;
input <vars>;
run;
filename case clear;

So a filled in example.

%LET prjdir=C:\Desktop\WR213548\;

%LET file1=test;

%LET sheet1=sheet1;

filename case DDE "Excel|&prjdir.[&file1.]&sheet2.!R1C1:R1000C25" notab; *1000 rows 25 columns;
data want;
infile case dsd dlm='09'x missover pad lrecl=1500; *change lrecl to fit your full row length;
length var1-var25 $20.;
input var1-var25;
run;
filename case clear;

Edit as needed.  Make sure that you have your excel file open and enabled editing before running this or you'll get an error.