topic Re: SAS query in SAS Programming

SAS query

scb — Tue, 06 Mar 2018 09:51:21 GMT

When I run the below code, I got the error message, anyone can help? Thanks.

proc datasets lib=TEST;
audit WANT;
initiate;
USER_VAR _REASON_CHANGE_ $30;
quit;

DATA TEST.WANT;
MODIFY TEST.WANT;
WHERE NO IN (SELECT DISTINCT OLD_NO FROM REFERRAL);
REFERRAL="N";
_REASON_CHANGE_ = "Refer Case";
RUN;

ERROR: Syntax error while parsing WHERE clause.
ERROR 22-322: Syntax error, expecting one of the following: a quoted string,
a numeric constant, a datetime constant, a missing value, -.

ERROR 76-322: Syntax error, statement will be ignored.

Re: SAS query

Kurt_Bremser — Tue, 06 Mar 2018 09:56:00 GMT

select is only valid in proc sql, not in a data step.

You might want to use a data step merge to find the observations that need to be changed.

Please supply example data (in data steps with datalines) to work with.

Re: SAS query

ChrisBrooks — Tue, 06 Mar 2018 09:57:51 GMT

You're trying to mix data step code with SQL i.e. SELECT DISTINCT OLD_NO FROM REFERRAL is SQL and the rest is data step. They're two completely different (albeit SAS supported) languages.