BookmarkSubscribeRSS Feed
4john
Calcite | Level 5
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.
2 REPLIES 2
Doc_Duke
Rhodochrosite | Level 12
The presence of the "/" says you are working in Unix. I don't think that Unix supports PC file imports.
SASKiwi
PROC Star
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.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1244 views
  • 0 likes
  • 3 in conversation