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.
... View more