05-29-2018 08:26 PM
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:
datafile = 'myex\cars.xlsx'
dbms = xlsx replace;
sheet = "CarData";
getnames = yes;
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
05-30-2018 11:41 AM
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.