importing excel 2003 spreadsheets into SAS

[4john]

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.

[Doc_Duke]

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

[SASKiwi]

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.