I want to import many sheets in excel file as sas datas
And I want the data name=sheet name
My favoured approach is to use the EXCEL LIBNAME (you need SAS/ACCESS to PC Files for this):
libname inxls excel "MyWorkbook.xls";
proc datasets library = out;
copy in = inxls out = out;
run;
quit;
When I use
proc setinit; run;
I see : SAS/ACCESS to PC Files
But it does not work, why ?
when I write
libname inxls excel "MyWorkbook.xls";
I have an error
When asking why an error has occurred please also supply your error message otherwise I would be guessing what the problem is.
I will send you the error message later
But , if i remember well, it will write
ERROR .....EXCEL.....
Question: we do not need a window server with SAS/ACCESS to PC Files ?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.