Importing a worksheet from 2016 excel into sas

Reply
Contributor
Posts: 23

Importing a worksheet from 2016 excel into sas

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

PROC Star
Posts: 2,369

Re: Importing a worksheet from 2016 excel into sas

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

Super User
Posts: 13,571

Re: Importing a worksheet from 2016 excel into sas

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.

 

Ask a Question
Discussion stats
  • 2 replies
  • 99 views
  • 0 likes
  • 3 in conversation