180-322: Statement is not valid or it is used out of proper order. - Proc IMPORT

shasank — Thu, 08 Apr 2021 16:48:38 GMT

Hi Community,

I am having issues debugging my Proc Import code. I tried multiple ways but still issue persisted.

proc import datafile="C:\FilePath\Test_report.xlsx"  DBMS=Excel REPLACE out=test;
    SHEET="Rep01_mat";
	getnames=YES;
	namerow = 4;
	datarow=5; 	
run;

Here is the error I get

706      getnames=YES;
2707      namerow = 4;
          -------
          180
2708      datarow=5;
          -------
          180
ERROR 180-322: Statement is not valid or it is used out of proper order.

2709  run;

The variable names are in Row 4 and data in row 5.

Any thoughts and suggestions are appreciated.

Thank you for your time.

Re: 180-322: Statement is not valid or it is used out of proper order. - Proc IMPORT

shasank — Thu, 08 Apr 2021 17:42:56 GMT

I have found the answer through some testing.

proc import datafile="C:\filepath\report.xlsx" DBMS=Excel REPLACE out=test;
SHEET="REP01_mat";
Range = "REP01_mat$A4:K0";
getnames=Yes;
run;

topic 180-322: Statement is not valid or it is used out of proper order. - Proc IMPORT in SAS Programming

180-322: Statement is not valid or it is used out of proper order. - Proc IMPORT

Re: 180-322: Statement is not valid or it is used out of proper order. - Proc IMPORT