Log:
6 proc import datafile = 'D:\Bangaloreusers\BSRZR05315\TrainingMaterial\Data\Session 6 ! 1\Data\sample_data.xls' 7 out = ds_imprt 8 DBMS = excel replace; ERROR: DBMS type EXCEL not valid for import.
Please help me out in debugging this error.. occurring while reading excel sheet with Proc Import to create SAS dataset.
Then try other Engine. Like XLS XLSX .
Moderator Note: I updated the topic title to make this message more readable.
Then try other Engine. Like XLS XLSX .
Maybe the engine "ExcelCS" would also work.
Which SAS Version are you using?
Hi, Geetha
In case you are using a unix based SAS it will not work . you wont be able to import and excel file
Excel is not supported on Unix..
Your best thing is to export the Excel file to a .CSV file and read it in that way.
If you want a quick fix, save the spreadsheet as a CSV then use DBMS = CSV.
I agree with SASKiwi, but not just for a quick fix. Whenever "Excel" is used in a post, I would always recommend getting the data out of Excel into a proper data transfer format (CSV, XML etc.), then write a proper datastep import to import that transfer file format.
I have the same error, still looking for a solution.
I can't export to CSV manually because I have lots of sheets.
(Or is there a way to export xls sheets to csv from SAS with another method? like x maybe ?)
ERROR: DBMS type EXCEL not valid for import.
I'm working with SAS 9.3 in SAS EG 5.1 (5.100.0.12019) (64-bit) on Windows7
I also have the same error. I have xlsx files and I'm trying to import in a SAS Linux Server (SAS 9.4) and get message DBMS type Excel is not valid
Have you ever found any solution?
Anyone has any solution for .xls, .xlsx files? Please share..
DBMS=XLSX works
Hi,
If you're using eguide 64 bit then you need to check if your office installation is also in 64 bit.
oter solution is to use the access to pc file server.
kind regards
I have the same ERROR while using PROC IMPORT with excel files. I have checked and my Guide version is 64-bits but my office is 32-bits... which is the solution to this ?
Thanks!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.