Refer to table listed all the way below. Am reading values of column name : data and it has all kinds of special characters in it and am storing it in macro variable name: chklist. I was able to see the values getting stored in chklist successfully in logs. Am getting error while trying to call macro variable in data step when am trying to use it in if condition. Any suggestions on how to resolve it.. proc sql noprint; select data into :chklist separated by ',' from outdata.dnt_update_b08; quit; %let chklist1=%superq(chklist); %put &chklist1; data ibs_test2; set ibs_test; if cmf_name in (&chklist1.) then do; FLAG ='Y'; end; output; run; Error: ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant, a datetime constant, a missing value, iterator, (, ), ',', :. Table key data A (10/19 A ****FRAUD A ***CLOSED A **ATTN A *_______________________ A % STUDENT NAME A % LOFT A % FRANK A %PUBLIX A %UNIVERSAL A ? DISNEY A '___________________ A "__________________
... View more