PROC IMPORT XLSX vs EXCEL

Ranjeeta — Thu, 13 Aug 2020 06:27:09 GMT

Hello,

I would appreciate if you can advide why I get the following error message when I replace EXCEL with XLSX in the code :

1 PROC IMPORT OUT=CW_LHIN_Q4FY1819
2 DATAFILE= "Y:\KNOWLEDGE
2 ! MANAGEMENT\STAFF\Ranjeeta\AdHoc\COVID\Stroke\Stroke Dashboard\IDS Regional Stroke
2 ! Dashboard Row Level Extract FY1819 Q4 CWLHIN.xlsx"
3 DBMS=XLSX REPLACE;
NOTE: The previous statement has been deleted.
NOTE: The previous statement has been deleted.
NOTE: The previous statement has been deleted.
4 RANGE="DAD$";
5 SCANTEXT=YES;
--------
180
6 USEDATE=YES;
-------
180
7 SCANTIME=YES;
--------
180
ERROR 180-322: Statement is not valid or it is used out of proper order.

8 RUN;

PROC IMPORT OUT=CW_LHIN_Q4FY1819
            DATAFILE= "Y:\KNOWLEDGE MANAGEMENT\STAFF\Ranjeeta\AdHoc\COVID\Stroke\Stroke Dashboard\IDS Regional Stroke Dashboard Row Level Extract FY1819 Q4 CWLHIN.xlsx" 
            DBMS=EXCEL REPLACE;
     RANGE="DAD$"; 
     SCANTEXT=YES;
     USEDATE=YES;
     SCANTIME=YES;
RUN;/*251*/

Re: PROC IMPORT XLSX vs EXCEL

andreas_lds — Thu, 13 Aug 2020 07:10:01 GMT

Afaik because the opitons scantext, usedate and scantime are not defined when using dbms=xlsx

Re: PROC IMPORT XLSX vs EXCEL

SASKiwi — Thu, 13 Aug 2020 23:20:27 GMT

Compare the options available for EXCEL and XLSX in this documentation link .

topic Re: PROC IMPORT XLSX vs EXCEL in SAS Programming

PROC IMPORT XLSX vs EXCEL

Re: PROC IMPORT XLSX vs EXCEL

Re: PROC IMPORT XLSX vs EXCEL