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.
... View more