Hi guys,  suppose to have the following dataset:    data DB; input ID :$20. Admission :date09. Discharge :date09. Range1 :date09. Range2 :date09.; format Admission date9. Discharge date9. Range1 date9. Range2 date9.; cards; 0001 13JAN2017 25JAN2017 30DEC2016 24FEB2017 0001 22FEB2017 07MAR2017 08FEB2017 06APR2017 0001 27APR2017 16MAY2017 13APR2017 15JUN2017 0001 30JAN2019 04MAR2019 16JAN2019 03APR2019 0002 28DEC2014 03JAN2015 14DEC2014 02FEB2015 0002 03MAR2015 12MAR2015 20FEB2015 02APR2015 ; and a second dataset:    data DB1; input ID :$20. Visit_date :date09. Visit; format Visit_date date9. ; cards; 0001 26JAN2017 1 0001 10FEB2017 1 0002 22FEB2015 4 ; Is there a way to obtain the following?    data DB2; input ID :$20. Admission :date09. Discharge :date09. Range1 :date09. Range2 :date09. Visit; format Admission date9. Discharge date9. Range1 date9. Range2 date9.; cards; 0001 13JAN2017 25JAN2017 30DEC2016 24FEB2017 1 0001 22FEB2017 07MAR2017 08FEB2017 06APR2017 1 0001 27APR2017 16MAY2017 13APR2017 15JUN2017 0 0001 30JAN2019 04MAR2019 16JAN2019 03APR2019 0 0002 28DEC2014 03JAN2015 14DEC2014 02FEB2015 0 0002 03MAR2015 12MAR2015 20FEB2015 02APR2015 4 ; In other words, if the visit_date (DB1) occurs in the range Range1-Range2 of DB for each patient (ID) then it will be reported in DB to obtain DB2.    Logic: 1) check if the visit_date in DB1 occurs between Range1 and Range2 of DB for each ID             2) if the visit_date in DB1 occurs between  Range1 and Range2 in DB for each ID, then create DB2. DB2 is as DB + the visit value ("visit" variable of DB1) where it occurs (i.e., at the corresponding range)     Thank you in advance ... View more

Hi guys,  suppose to have this highly sparse dataset:    data DB; input ID :$20. Index Variable1 Variable2 Variable3 Variable4; cards; 0001 1 . 1 . . 0001 0 1 . . 1 0002 1 1 . . 1 0002 0 . 1 . . 0003 1 . . . . 0003 0 2 . 4 . 0003 0 . 3 . . 0003 0 . . . . 0003 0 . . . 8 run; Is there a way to move all values of Variable: where Index = 1 to have the following?  data DB1; input ID :$20. Index Variable1 Variable2 Variable3 Variable4; cards; 0001 1 1 1 . 1 0001 0 . . . . 0002 1 1 1 . 1 0002 0 . . . . 0003 1 2 3 4 8 0003 0 . . . . 0003 0 . . . . 0003 0 . . . . 0003 0 . . . . run; Note: no replicates are present by ID for each Variable: Thank you in advance ... View more

Hi guys,  suppose to have the following dataset:    data DB; input ID :$20. Comorbidity Total Class1 Class2 Class3 Class4 Class5 Class7; cards; 0001 1 1.34 0.2 . . . . . . 0001 1 . . 0.5 . . . . . 0002 0 15 . . 1.2 . . . . 0003 1 2 . . . 0.5 . . . ; run; Is there a way to get the following?  data DB1; input ID :$20. Comorbidity Total Class1 Class2 Class3 Class4 Class5 Class7; cards; 0001 1 1.34 0.2 . . . . . . 0001 1 . . 0.5 0.64 . . . . 0002 0 15 . . 1.2 5 5 3.8 . 0003 1 2 . . . 0.5 1.5 . . ; run; In other words, the Total should be reached by adding values from the last filled class on -->.  Classes are age classes and values are persons-years. Total is the total a patient is in the study. So if a patient stay in the (age)class x a time y that does not cover the Total, additional person-years must be added from the age class x-->on because age can increase only. The reason why I need to fill with values is because the patient has not an event and this justify why Class* are empty but it is still at risk. Moreover each Class* cannot have values >5 because age classes are in a range of 5 years.  Thank you in advance. ... View more

Dear all,  suppose to have two dates:  Date of Birth: 01JUL1936 Date of Admission: 03MAR2016 The age at admission calculated as: (Date of Admission-Date of Birth)/365.25 = 79.67.      Since I need an integer, should this age be rounded to 80 or not? If yes, how?    Thank you in advance   ... View more

Hi guys,  suppose to have the following:    data DB; input ID :$20. Admission :date09. Discharge :date09. Class Value; format Admission date9. Discharge date9.; cards; 0001 13JAN2015 20JAN2015 2 0.32 0001 21FEB2015 31DEC2015 2 0.32 0001 01MAR2018 30SEP2018 3 0.43 0001 01JAN2019 31DEC2019 3 0.43 0002 01JAN2015 31DEC2015 2 1.92 0002 01JAN2019 31OCT2019 2 1.92 0003 08FEB2014 10MAR2014 1 4.32 0003 16JUN2015 13JUL2015 1 4.32 0004 04MAY2016 10MAY2016 3 3.22 0004 13SEP2017 15NOV2017 3 3.22 0004 09DEC2018 31DEC2018 3 3.22 ; Is there a way to get the following?    data DB1; input ID :$20. Admission :date09. Discharge :date09. Class Class1 Class2 Class3 Class4; format Admission date9. Discharge date9.; cards; 0001 13JAN2015 20JAN2015 2 . 0.32 . . 0001 21FEB2015 31DEC2015 2 . 0.32 . . 0001 01MAR2018 30SEP2018 3 . . 0.43 . 0001 01JAN2019 31DEC2019 3 . . 0.43 . 0002 01JAN2015 31DEC2015 2 . 1.92 . . 0002 01JAN2019 31OCT2019 2 . 1.92 . . 0003 08FEB2014 10MAR2014 1 4.32 . . . 0003 16JUN2015 13JUL2015 1 4.32 . . . 0004 04MAY2016 10MAY2016 3 . . 3.22 . 0004 13SEP2017 15NOV2017 3 . . 3.22 . 0004 09DEC2018 31DEC2018 3 . . 3.22 . ; In other words I would like to "distribute" the values of variable "Value" across all classes in Class variable.    Thank you in advance ... View more