Hi, I have a dataset that contains patients, visit and values. My confusion lies in the fact the data is ordered. I would like to be able to remove all the patients if one of the visits is "unscheduled" or is missing "second". This may have been asked before so feel free to direct me to a posted solution.   Have:  ID   visit                    value  1    first                      0 1    second                0 2    first                      0 2    unscheduled       0 3    first                      0   Want: ID   visit                    value  1    first                      0 1    second                0   My pseudo attempt would be: if missing("second") or contains("unscheduled") delete ID.  ... View more

I have a data set of patients who have been taking medication for certain amounts of time. I am trying to flag the days 'Y' where they take any drug for >=15 consecutive days but also flag the days as 'N' that don't contribute to those >=15 consecutive days irrespective of medication   data have; input ID $ medication start_date :date. end_date :date.; datalines; A005 1 01SEP2016 01SEP2016 A005 2 02SEP2016 02SEP2016 A005 1 16SEP2016 19SEP2016 A005 3 19SEP2016 30SEP2016 A006 1 01OCT2016 03OCT2016 A006 1 05OCT2016 15OCT2016 A006 1 11OCT2016 19OCT2016 A006 3 31OCT2016 31OCT2016 ; Because the dates are on various lines, I dont know how to flag them when they overlap. Is there anyway I can do this? Perhaps I have to create an intermediate variable?    data want; input ID $ medication start_date :date. enddate :date. flag; datalines; A005 1 01SEP2016 01SEP2016 N A005 2 02SEP2016 02SEP2016 N A005 1 16SEP2016 19SEP2016 Y A005 3 19SEP2016 30SEP2016 Y A006 1 01OCT2016 03OCT2016 N A006 1 05OCT2016 15OCT2016 Y A006 1 11OCT2016 19OCT2016 Y A006 3 31OCT2016 31OCT2016 N ; ... View more

Hi, I am calculating BMI from a patient's Height and Weight per patient per date. For each BMI calculation I would like to keep Patient, VisitDate, Visit, and bflag information. There is a typo for patient B on Jan12019 where weight is not marked with the same Visit and bflag info that Height is. I would like for the BMI to have that info. Is there a way I can keep the visit and bflag?    data in; input Patient $ VisitDate $ Value Unit $ Type $ Visit $ bflag $; cards; A Jan12019 1 m Height baseline Y A Jan12019 50 kg Weight baseline Y A Jan52019 2 m Height visit1 . A Jan52019 55 kg Weight visit1 . B Jan12019 1 m Height baseline Y B Jan12019 50 kg Weight . . B Jan52019 55 kg Weight baseline Y ; proc sort data=in; by patient VisitDate; run; data have; set in; by patient VisitDate; retain height_; if first.VisitDate then height_=.; if type='Height' then height_=Value; if last.VisitDate then bmi=value/height_**2; output; if bmi ne . then do; type='BMI'; value=bmi; unit='kg/m2'; output; end; drop height_ bmi; run; data want; input Patient $ VisitDate $ Value Unit $ Type $ Visit $ bflag $; cards; A Jan12019 1 m Height baseline Y A Jan12019 50 kg Weight baseline Y A Jan12019 50 kg/m2 BMI baseline Y A Jan52019 2 m Height visit1 . A Jan52019 55 kg Weight visit1 . A Jan52019 13.75 kg/m2 BMI visit1 . B Jan12019 1 m Height baseline Y B Jan12019 50 kg Weight . . B Jan12019 50 kg/m2 BMI baseline Y B Jan52019 55 kg Weight baseline Y ;   ... View more