Hi all, May I ask for your help? Here's the data I have & want. I have difficulty in summarizing both character & numeric variables, as I need to combine the character variable "product_ID" which cannot use proc sql (I thought). Also, I have many numeric variables actually; is there any way that I don't need to list the variable names one by one? Many thanks for your help in advance! data Have; input ID $ visit_date :mmddyy8. product_ID $ Plan_A Plan_B Plan_C Cost; format visit_date mmddyy8.; datalines; AB 10/01/98 ABCD 50 10 20 30 AB 10/01/98 EFGH 50 10 20 30 AB 10/02/98 ABCD 50 10 20 30 AC 10/01/98 ABCD 50 10 20 30 AC 10/01/98 EFGH 50 10 20 30 AD 10/01/98 ABCD 50 10 20 30 AD 10/02/98 EFGH 50 10 20 30 AD 10/03/98 HIJK 50 10 20 30 ; run; data Want; input ID $ visit_date :mmddyy8. product_ID $ Plan_A Plan_B Plan_C Cost; format visit_date mmddyy8.; datalines; AB 10/01/98 ABCD&EFGH 100 20 40 60 AB 10/02/98 ABCD 50 10 20 30 AC 10/01/98 ABCD&EFGH 100 20 40 60 AD 10/01/98 ABCD 50 10 20 30 AD 10/02/98 EFGH 50 10 20 30 AD 10/03/98 HIJK 50 10 20 30 ; run;
... View more