topic Re: importing excel 2003 spreadsheets into SAS in SAS Procedures

importing excel 2003 spreadsheets into SAS

4john — Fri, 21 May 2010 19:11:45 GMT

Hi,
i was trying to import a spreadsheet(excel 2003).but i am getting an error saying DBMS type EXCEL not valid.

libname meds '/dat/sak/MDII/Reects/int/inient';

PROC IMPORT OUT= mes.rejan
DATAFILE= "/dat/sak/MDII/Reects/int/inient/P.309.inp_01JAN09_31JAN09_0.1.xls"
DBMS=excel REPLACE;
GETNAMES=YES;
RUN;

Suggest me a way to import multiple spreadsheets into SAS datasets.

Thanks.

Re: importing excel 2003 spreadsheets into SAS

Doc_Duke — Fri, 21 May 2010 19:49:15 GMT

The presence of the "/" says you are working in Unix. I don't think that Unix supports PC file imports.

Re: importing excel 2003 spreadsheets into SAS

SASKiwi — Mon, 24 May 2010 03:06:34 GMT

SAS/ACCESS to PC FILE FORMATS is available under Unix but you may not have it licenced and/or configured correctly. Run the SETINIT procedure to confirm if it is licensed or not.

If not a quick fix may be to save the spreadsheet as a comma or tab delimited file and change your PROC IMPORT code accordingly.