Importing a worksheet from 2016 excel into sas

[BenBrady]

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

[ChrisNZ]

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

[ballardw]

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.