removing trailing commas from concatenation

[lnb001]

I am working on a report that requires concatenating multiple records into one field. I first transposed my table and tried to concatenate everything into one column. The problem I encountered is that some observations have only one record of interest while others have as many as eight so when trying to separate each record in the concatenated column I get trailing commas for any cases that have less than eight records. How can I get rid of the trailing commas? Thanks.

[data_null__]

CATX should help.

[pre]
proc sort data=sashelp.class out=_data_;
by age;
run;
proc transpose;
by age;
var weight;
run;
proc print;
run;
options missing=' ';
data;
set;
length w $64;
w = catX(', ',of col:);
drop col:;
run;
proc print;
run;
[/pre]

[chang_y_chung_hotmail_com]

Use CATX function.

data _null_;
   a = ""; b = "b";
   ab = catx(",",a,b);
   put (_all_) (=);
run;
/* on log
   a=  b=b ab=b
*/

[lnb001]

This worked. Thanks!