Hello,
I'm having trouble importing xlsx file and I keep getting this error "ERROR: DBMS type XLSX not valid for import." . Can someone help?
proc import datafile="path\Data.xlsx"
dbms=xlsx out=dm replace;
run;
So you do not have SAS/ACCESS to PC Files installed. Run PROC SETINIT to check if it is also not licensed (most probably).
Save your spreadsheet as a CSV file, and read it with a data step.
Install a new version of SAS?
To check the version of SAS you are running check the macro variable SYSVLONG. To check what is installed use PROC PRODUCT_STATUS.
I know XLSX engine works with this 4.5 year old version of SAS (which does have SAS/Access to PC Files installed).
79 %put &=sysvlong;
SYSVLONG=9.04.01M5P091317
80
81
82 proc product_status;
83 run;
For Base SAS Software ...
Custom version information: 9.4_M5
Image version information: 9.04.01M5P090617
...
For SAS/ACCESS Interface to PC Files ...
Custom version information: 9.4_M5
...
So you do not have SAS/ACCESS to PC Files installed. Run PROC SETINIT to check if it is also not licensed (most probably).
Save your spreadsheet as a CSV file, and read it with a data step.
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.