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
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.