08-17-2017 09:09 AM
We are trying to concantenate column Items based on another column, Shopper_ID. Any suggestions on how we can achieve this?
2 screen protector
1 keyboard, mouse, notebook
2 keyboard, screen protector
08-17-2017 09:28 AM - edited 08-17-2017 09:30 AM
08-17-2017 09:47 AM
data have; input Shopper_ID Items $40.; cards; 1 keyboard 1 mouse 1 notebook 2 keyboard 2 screen protector 3 case ; run; data want; length want $ 2000; do until(last.Shopper_ID); set have; by Shopper_ID ; want=catx(',',want,items); end; drop items; run;
08-17-2017 10:55 AM
If you're working with the GUI, then you would first Transpose the data using a TRANSPOSE task and then you can aggregate them using the function CATX in a query and using a calculated column.