07-06-2017 03:54 PM - edited 07-06-2017 04:35 PM
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?
proc sql noprint;
select name into :varlist separated by ' '
where anydigit(name) ge 1;
07-06-2017 04:07 PM