by group

[ursula]

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]

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