@mambrose wrote: Upon further testing, I found that PROC IMPORT with DBMS=XLSX will also work importing from a multi-sheet EXCEL workbook file IF the sheet I want to import is the first sheet in the file. So, I would still need to get PC Files Server running correctly to import more than one sheet from the same EXCEL file.
PROC IMPORT will import the first sheet if you don't tell it which one you want.
You can use the SHEET= statement to tell it the name of the sheet you want. Or add the sheetname to the value in the RANGE= statement.
proc import dbms=xlsx out=test1 replace
datafile='c:\downloads\three.xlsx'
;
run;
proc import dbms=xlsx out=test2 replace
datafile='c:\downloads\three.xlsx'
;
sheet='Sheet2';
run;
proc import dbms=xlsx out=test3 replace
datafile='c:\downloads\three.xlsx'
;
range='$A1:0';
run;
proc import dbms=xlsx out=test4 replace
datafile='c:\downloads\three.xlsx'
;
range='Sheet2$A1:B2';
run;
... View more
