topic Re: Import an excel file with a sheets in SAS Programming

Import an excel file with a sheets

LineMoon — Wed, 22 Jul 2015 23:28:23 GMT

I want to import many sheets in excel file as sas datas

And I want the data name=sheet name

SASKiwi — Thu, 23 Jul 2015 00:41:10 GMT

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;

LineMoon — Thu, 23 Jul 2015 22:29:24 GMT

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

SASKiwi — Thu, 23 Jul 2015 23:02:28 GMT

When asking why an error has occurred please also supply your error message otherwise I would be guessing what the problem is.

LineMoon — Sat, 25 Jul 2015 08:14:22 GMT

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 ?