topic Re: ERROR: DBMS type XLSX not valid for import. in SAS Programming

ERROR: DBMS type XLSX not valid for import.

nab102 — Sat, 21 May 2022 16:16:08 GMT

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;

Re: ERROR: DBMS type XLSX not valid for import.

Tom — Sat, 21 May 2022 16:45:26 GMT

Install a new version of SAS?

https://blogs.sas.com/content/iml/2013/08/02/how-old-is-your-version-of-sas-release-dates-for-sas-software.html

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
...

Re: ERROR: DBMS type XLSX not valid for import.

nab102 — Sat, 21 May 2022 19:33:25 GMT

This is my version
149 %put &=sysvlong;
SYSVLONG=9.04.01M7P080520

For Base SAS Software ...
Custom version information: 9.4_M7
Image version information: 9.04.01M7P080520
For SAS/STAT ...
Custom version information: 15.2
For SAS/GRAPH ...
Custom version information: 9.4_M7
For SAS/IML ...
Custom version information: 15.2
For High Performance Suite ...
Custom version information: 2.2_M8
For SAS/ACCESS Interface to ODBC ...
Custom version information: 9.4_M7

Re: ERROR: DBMS type XLSX not valid for import.

Kurt_Bremser — Sat, 21 May 2022 19:57:27 GMT

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.

Re: ERROR: DBMS type XLSX not valid for import.

nab102 — Mon, 23 May 2022 01:38:05 GMT

I already converted the files from xlsx to csv but I had multiple files in the xlsx files in one excel worksheet so I thought there was going to be an easier way to do that. Thanks

Re: ERROR: DBMS type XLSX not valid for import.

nab102 — Mon, 23 May 2022 01:38:38 GMT

Thank you