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)
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.
So have you run it and got the expected results which would be the first sheet in the workbook?
yes
Then why are you asking the question?
I just want to make sure what I thought is correct .
Thank you for your reply.
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.
Thank you for your help.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.