topic Re: Just the first sheet ? in SAS Programming

Just the first sheet ?

tianerhu — Sun, 16 May 2021 00:49:04 GMT

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)

Re: Just the first sheet ?

SASKiwi — Sun, 16 May 2021 01:20:07 GMT

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

Re: Just the first sheet ?

tianerhu — Sun, 16 May 2021 01:49:03 GMT

yes

Re: Just the first sheet ?

SASKiwi — Sun, 16 May 2021 19:53:41 GMT

Then why are you asking the question?

Re: Just the first sheet ?

tianerhu — Sun, 16 May 2021 20:24:53 GMT

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

Thank you for your reply.

Re: Just the first sheet ?

SASKiwi — Mon, 17 May 2021 00:24:48 GMT

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.

Re: Just the first sheet ?

tianerhu — Mon, 17 May 2021 20:34:10 GMT

Thank you for your help.