BookmarkSubscribeRSS Feed
ursula
Pyrite | Level 9


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

1 REPLY 1
ChandraReddy
Calcite | Level 5

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

sas-innovate-2024.png

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.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 308 views
  • 0 likes
  • 2 in conversation