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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.