topic Re: removing trailing commas from concatenation in SAS Procedures

removing trailing commas from concatenation

lnb001 — Fri, 06 May 2011 17:28:51 GMT

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.

Re: removing trailing commas from concatenation

data_null__ — Fri, 06 May 2011 17:42:39 GMT

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]

Re: removing trailing commas from concatenation

chang_y_chung_hotmail_com — Fri, 06 May 2011 17:45:38 GMT

Use CATX function.

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

Re: removing trailing commas from concatenation

lnb001 — Fri, 06 May 2011 18:38:06 GMT

This worked. Thanks!