topic Re: Joining text within group of rows in SAS Programming

Joining text within group of rows

hhchenfx — Sat, 13 Feb 2021 18:18:22 GMT

Hi Everyone,

My data is as below, each group_id has multiple row.

I want to join the text within each group_id.

For group_id=1, it has 3 rows with var =x, yy, zzz.

The output should have 2 columns

group_id | join_text

1 | x, yy, zzz

2 | aaa, b

3 | c

Can you please help me to get it?

Thank you so much.

HHCFX

data have; 
input group_id var1 $;
datalines;
1 x
1 yy
1 zzz
2 aaa
2 b
3 c
;run;

Re: Joining text within group of rows

Shmuel — Sat, 13 Feb 2021 19:05:35 GMT

data want;
 set have;
   by group_id;  /* assuming dataset is sorted by group_ID */
       length join_text $100;  /* adapt length to max expected */
       retain join_text;
       if first.group_ID then join_text = var1;
       else join_text = catx(',',join_text,var1);
       if last.group_id then output;
       drop var1;
run;

Re: Joining text within group of rows

hhchenfx — Sat, 13 Feb 2021 19:50:07 GMT

Thank you, Shmuel!

HHCFX