Hello:
I have a proc sql to create a macro variable list. However, some names I don't want them in that macro list. For example, the '&varlist' includes 'apple1', 'pear2', 'grape3' and 'cherry4'. However, 'apple1' and 'pear2' should not be in the list. Please advice how to remove them. Also, is there a way create a masterlist for removing list?
Thanks.
%let removelist1=apple1;
%let removelist2=pear2;
proc sql noprint;
select name into :varlist separated by ' '
from test
where anydigit(name) ge 1;
quit;
%put &varlist;
proc sql noprint;
select name into :varlist separated by ' '
from test where name not in ('apple', 'pear') ;
quit;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.