I have a SAS dataset with 3 columns that could have one or more values separated by comma. I would have to add a new column with distinct values in 3 columns separated by comma in a new field "Final.   Have: ID Y2017 Y2018 Y2019 a a2, a3 a2,a3 a4 b a2   a4 c a1, a2 a2,a3 a4,a3   Want: ID Y2017 Y2018 Y2019 Final a a2, a3 a2,a3 a4 a2, a3, a4 b a2   a4 a2, a4 c a1, a2 a2,a3 a4,a3 a1, a2, a3, a4   Thanks! ... View more

Hi- I have a table with ID, start year month, end year month and sales per month like below: ID st_yrmo end_yrmo salespermo a 201701 201703 12.9 b 201801 201804 12.5 c 201705 201706 13.8 c 201710 201712 12.2   For each ID for the range, I would like to have a table like below which has ID, month and sales per month for each month as per table above. ID yrmo salespermo a 201701 12.9 a 201702 12.9 a 201703 12.9 b 201801 12.5 b 201802 12.5 b 201803 12.5 b 201804 12.5 c 201705 13.8 c 201706 13.8 c 201710 12.2 c 201711 12.2 c 201712 12.2 ... View more

I have a dataset like below. There are 3 patients that visited the hospital multiple times, whether planned or unplanned. I would like to flag all the cases as planned = 1 once we find the first planned case.   data tr1; input ptid$ day planned; cards; a 0 0 a 5 0 a 10 0 a 12 1 a 15 1 a 20 0 a 25 0 a 29 1 b 0 0 b 6 0 b 14 1 c 0 1 c 11 0 c 15 0 c 19 0 ; run;   I would like to have an output as below adding one extra flag. For ear patient (ptid) once it finds the first planed visit, I would like to have all the records after first planned visit as planned visit even if they are unplanned.   Thanks ptid day planned plflag a 0 0 0 a 5 0 0 a 10 0 0 a 12 1 1 a 15 1 1 a 20 0 1 a 25 0 1 a 29 1 1 b 0 0 1 b 6 0 1 b 14 1 1 c 0 1 1 c 11 0 1 c 15 0 1 ... View more