Help using Base SAS procedures

importing excel 2003 spreadsheets into SAS

Reply
Occasional Contributor
Posts: 16

importing excel 2003 spreadsheets into SAS

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.
Trusted Advisor
Posts: 2,113

Re: importing excel 2003 spreadsheets into SAS

The presence of the "/" says you are working in Unix. I don't think that Unix supports PC file imports.
Super User
Posts: 3,115

Re: importing excel 2003 spreadsheets into SAS

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.
Ask a Question
Discussion stats
  • 2 replies
  • 137 views
  • 0 likes
  • 3 in conversation