Summary table of group and categories belong to the group with comma between values

Ronein — Sun, 05 Apr 2020 06:11:52 GMT

Hello

I have a table that show for each category the group name.

I want to create another table that will contain for each group one row (so in this case 3 rows).

and for each group there will be information for categories that belong to this group with comma between the value

So the expected table is

USA 200,100,300,400

EU 500,600,150

Asia 250,700

Another challenge is to order the value from low to high so the expected table will be

USA 100,200,300,400

EU 150,500,600

Asia 250,700

Data tbl1;
Input category group $;
cards;
200 USA
100 USA
300 USA
400 USA
500 EU
600 EU
150 EU
250 Asia
700 Asia
;
run;

Re: Summary table of group and categories belong to the group with comma between values

Kurt_Bremser — Sun, 05 Apr 2020 06:54:18 GMT

Sort

by descending group category;

Then, in a data step with

by descending group;

create your new variable with sufficient length, set it to blank at first.group, then do

new_var = catx(',',new_var,category);

and then use a subsetting if for last.group.