Hello friend,   I'm trying to find median (range) of SIM per year, month, week and day from the data below. Any help is much appreciated.   data have; input ID SIM Date : mmddyy12.; format date mmddyy10.; cards; 5648 0 1/20/2014 4489 0 2/20/2016 4564 2 6/20/2014 4587 1 8/20/2014 4578 2 1/20/2014 5645 9 12/21/2013 4564 12 11/21/2011 2587 15 10/21/2017 4254 7 3/21/2012 4545 0 3/21/2013 4587 0 1/22/2015 6968 0 7/22/2015 3254 1 5/22/2011 1215 2 11/22/2011 5456 5 10/23/2010 8999 12 1/23/2010 4555 9 2/23/2012 7894 8 7/23/2018 6968 0 2/23/2012 4455 0 5/23/2016 8789 2 1/23/2019 ; run;   Thanks, Rube ... View more

I have patients with multiple rows and variables diabetes (1=yes and 2=no) and hypertension (1=yes and 2=no). For each patient, if it is 1 in any row, it should be considered as 1. Please see the initial data set: data have; input pt_id diabetes hypertension; datalines; 1 0 0 1 1 0 1 1 0 1 0 0 2 0 0 2 0 0 2 0 0 2 0 0 3 1 1 3 0 1 3 0 1 run; Final data set should look like this:   data have; input pt_id diabetes hypertension; datalines; 1 1 0 2 0 0 3 1 1 run; Thank you for your help!   ... View more

I have the attached data set and I'm trying to convert it to wide format with conditions.There are patients who took drug1 and drug2. I want to see how many days each drug was taken and whether if was completed or discontinued. Whether it is completed or discontinued depend on the status on the last day. If it is completed on last day, it is completed. If it is discontinued on last day, it is discontinued. The final data would look like this:   data new; infile cards missover; input Pt_id drug1 drugs1_days drug1_status $ drug2 drug2_days drug2_status $ ; cards; 1 1 5 completed 1 1 completed 2 1 2 discontinued 1 2 completed 3 1 1 completed 0 . . 4 1 3 completed 1 2 discontinued 5 1 4 completed 0 . . ; run; Thank you for your help!     ... View more

I'm looking how I can keep only those with var1=1 and var2=1. If one participants has var1=1 and var2=1, I was to keep all rows of the participants. This is the initial dataset data new; infile cards missover; input id var1 var2; cards; 11 1 0 11 1 0 12 1 1 12 1 1 12 0 1 13 1 1 14 0 1 15 1 1 16 1 1 17 0 1 17 0 1 17 1 1 17 0 0 run; The final dataset should be like this: data new1; infile cards missover; input id var1 var2; cards; 12 1 1 12 1 1 12 0 1 13 1 1 15 1 1 16 1 1 17 0 1 17 0 1 17 1 1 17 0 0 run; Thank you! ... View more