/************************************************************ * concatenate all strings in a column into a macro variable * * Peng Zeng (Auburn University) * 10-17-2018 ************************************************************/ data example; length names $20; input names $; datalines; AUDI FORD CHEVROLET ; proc print data = example; run; proc sql; select names into: list_names separated by "/" from example; quit; %put &list_names;