- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.