Just the first sheet ?

[tianerhu]

libname results 'C:\practice everyday';
proc import datafile = 'C:\practice everyday\input\ABC.xlsx'
out = results.ABC
dbms = xlsx
replace;
getnames = yes;
run;
proc print data = results.ABC;
run; With code above, just get a sas data set named results.ABC which is from sheetA ,isn't it ?(ABC.xlsx has three sheets, the first is sheetA, the second is sheetB, the third is sheetC)

[SASKiwi]

So have you run it and got the expected results which would be the first sheet in the workbook?

[tianerhu]

yes

[SASKiwi]

Then why are you asking the question?

[tianerhu]

I just want to make sure what I thought is correct .

Thank you for your reply.

[SASKiwi · Accepted solution]

You ensure you get the sheet you want it is better to use the SHEET = option as documented here

Relying on the order of sheets to pick (the first will be selected by default) the one you want isn't reliable.

[tianerhu]

Thank you for your help.