I think, It would work if its single word like a,b,c,d,e What if the column names are age sex race. Compress will remove a from age and e from sex and a,c,e from race. proc contents data=sashelp.class out=class; run; proc sql; select name into :include separated by " " from class; quit; %put &include; %let exclude=weight; %let want=%sysfunc(compress(&include,%sysfunc(compress(&exclude)))); %put &want; Can Anyone explain how to make a change to the below code to work for a string of words..I see a macro but don't understand it. Looking for some simple answer..Thanks.
... View more