I am trying to write a macro to concatenate all values of a row. But its not working. can some one point out? Without the macro its working fine.    %macro dummy(var=); proc sql; create table values as select distinct(&var.) as vals from td; run; data values1; length new_val $100.; %do %until(eof); set values end=eof; new_val=catx("",new_val,vals); %end; run; proc print data=values1; run; %mend; %dummy(var=job); ... View more