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

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

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
  • 1227 views
  • 0 likes
  • 3 in conversation