06-15-2015 08:51 AM
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.
07-22-2015 03:50 AM
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.
07-22-2015 04:08 AM
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.
05-23-2016 09:10 AM
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 (18.104.22.16819) (64-bit) on Windows7
08-18-2016 04:57 PM
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?
12-31-2016 05:52 AM
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.