Warning and ERROR 22-322:

Jonison — Fri, 24 Jul 2020 09:00:27 GMT

Hello, expert,

I have code:

ROC SQL;
CREATE TABLE WORK.Number AS
SELECT int(MAX('Primary ID'n / 7)) FORMAT=BEST12. into:RowN
FROM WORK.modeltraining_blocked;
QUIT;

%macro leaveoneout;
%local i;
%do i=1 %to 7;

data model_sample;
set WORK.modeltraining_blocked;
if ('Primary ID'n < (&i-1)*&RowN) or ('Primary ID'n > (&i+1)*&RowN);
run;

%end;
%mend;

when this code is running, it shows.

1. WARNING: INTO clause is ignored in the CREATE TABLE statement.

2. if ('Primary ID'n < (&i-1)*&RowN) or ('Primary ID'n >
78 ! (&i+1)*&RowN); (two red underlie below the ")")
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant,
a missing value, INPUT, PUT.

would you please suggest the reason?

Many thanks

Re: Warning and ERROR 22-322:

gamotte — Fri, 24 Jul 2020 09:23:48 GMT

Hello,

You cannot create a new table and export columns to macrovariables using

the same SELECT instruction. Hence the INTO clause is ignored and the macrovariable

RowN not created.

topic Warning and ERROR 22-322: in SAS Programming

Warning and ERROR 22-322:

Re: Warning and ERROR 22-322: