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
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;
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;
...
Chandra
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Register now!
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for:
View all other training opportunities.