I have saved a file called cars.xlsx that is saved in a file path called myexcel. The sheet I want to import is called CarData. I am using the following code to import it into sas:
proc import
datafile = 'myex\cars.xlsx'
out= Car_Data
dbms = xlsx replace;
sheet = "CarData";
getnames = yes;
run;
I am getting an error that says: ERROR: DBMS type XLSX not valid for import. When I chance XLSX to excel I still get the same error message
Please check that xlsx is supported for your SAS version under linux/unix.
Run this code:
proc setinit; run;
If you do not have something similar to the following appear in the log then your SAS is not licensing the module to use that approach to importing Excel files:
---SAS/ACCESS Interface to PC Files
Which would mean either getting license for that module or you could do a file save as from Excel to CSV and import that file as a delimited file. Add the option guessingrows=max to the proc import code to have a better chance at getting good results.
If you do see that then run this code:
proc product_status; run;
If you do not see something like the following then it means the module was not installed:
For SAS/ACCESS Interface to PC Files ...
Which means that a reinstall paying attention to select the module might help.
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.