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 ?
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.