topic by group in SAS Programming

by group

ursula — Thu, 28 Mar 2013 21:08:44 GMT

HI there,

I tried to do grouping observations as follow:

The table I have is:

customer_id product_ID

101 1a

101 2b

101 3a

102 2a

102 4b

103 1a

the out put I want is:

customer_id product_id

101 1a, 2b, 3a

102 2a, 4b

103 1a

Any help will be very appreciate.

thank you in advance

ChandraReddy — Thu, 28 Mar 2013 21:38:36 GMT

Hi,

Try the below code:

data table;

set table;

by customer_id product_id;

run;

data table2;

set table;

by customer_id product_id;

if first.customer_id then final_product = product_id;

else do;

retain final_product;

final_product = catx(',',final_product,product_id);

end;

if last.customer_id;

run;

...

Chandra