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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.