topic Re: Importing a worksheet from 2016 excel into sas in SAS Programming

Importing a worksheet from 2016 excel into sas

BenBrady — Wed, 30 May 2018 00:26:53 GMT

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

Re: Importing a worksheet from 2016 excel into sas

ChrisNZ — Wed, 30 May 2018 06:00:05 GMT

Please check that xlsx is supported for your SAS version under linux/unix.

Re: Importing a worksheet from 2016 excel into sas

ballardw — Wed, 30 May 2018 15:41:33 GMT

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.