Guys, is there a way to flag consecutive years while considering gaps?  Suppose to have:    Person1       2015  Person1       2018  Person1       2019  Person1       2020  Person2       2015  Person2       2016  Person2       2018  Person2       2019 Person3       2015 Person3       2016 Person3       2017 Person3       2020         To have       Person1       2015         0 Person1       2018         1 Person1       2019         1 Person1       2020         1 Person2       2015         1 Person2       2016         1 Person2       2018         2 Person2       2019         2 Person3       2015         1      Person3       2016         1 Person3       2017         1 Person3       2020         0        Thank you in advance.   Just edited to simplify. I used 2 to distinguish 2015-2016 from 2018-2019 for Person2 because there is a gap otherwise they will be considered consecutives while using 1 but any other flag is ok. ... View more

Hi,  suppose to have the following:   Subj   Age a      30-40 a      30-40 a      50-60 a      50-60 b      30-40 b      30-40 b      30-40  .................     Is there a way, for each Subj to replace for the age variable the values with the greatest ones? In other words, 30-40 for "a" should be replaced with 50-60. Thank you in advance. ... View more

Hi guys,  suppose to have the following:   data DB1; input ID :$20. Start :$20. End :$20. Hospital :$20.; cards; 0001 01JAN2015 06FEB2016 C 0001 07FEB2016 25APR2016 C 0001 26APR2016 31DEC2019 D 0002 01JAN2017 12JUL2017 C 0002 13JUL2017 31DEC2019 D 0002 01JAN2020 31DEC2020 D ; data DB2; input ID :$20. Start :$20. End :$20.; cards; 0001 28JAN2016 08FEB2016 0001 24APR2016 28APR2016 0001 28NOV2019 13DEC2019 0002 11JUL2017 14JUL2017 0002 15JUL2017 01OCT2019 0002 14AUG2020 13SEP2020 ; expected: data DB3; input ID :$20. Start :$20. End :$20. Hospital :$20.; cards; 0001 28JAN2016 08FEB2016 C 0001 24APR2016 25APR2016 C 0001 26APR2016 28APR2019 D 0001 28NOV2019 13DEC2019 D 0002 11JUL2017 12JUL2017 C 0002 13JUL2017 14JUL2017 D 0002 15JUL2017 01OCT2019 D 0002 14AUG2020 13SEP2020 D ; In other words I would like to add the Hospital information to DB2 to obtain DB3 based on the range of its periods on DB1. When the period of DB2 is in between the hospital change of DB1 the period of DB2 would be splitted as shown in the output to take track of the hospital change. Can anyone help me please? thank you in advance.   ... View more

Hi guys,  suppose to have two data sets (files). File 1 is composed by time-periods with a label for each one and File2 that contains sub-periods without labels. I need to add labels to File2 based on the time interval from File1 so that if the period has Label "x" and the sub-period is contained in the period of File1, the sub-period will take the label from the period of File1.    Can anyone help me please?          data have1; input ID :$20. Start :date9. End :date9. Label :$20. Role :$20.; format start end yymmdd10.; cards; 0001 01JAN2015 30APR2015 HospitalA ex005 0001 01MAY2015 31MAY2015 HospitalA ex004 0001 01JUN2015 31DEC2015 HospitalC ex005 0002 06FEB2018 08FEB2018 HospitalA ex004 0002 09FEB2018 31AUG2018 HospitalC ex005 0002 01SEP2018 31DEC2019 HospitalC ex004 0003 01JAN2019 30SEP2019 HospitalD ex008 0003 01OCT2019 31DEC2020 HospitalD ex004 ; File2: data have2; input ID :$20. Start :date9. End :date9.; format start end yymmdd10.; cards; 0001 01JAN2015 30JAN2015 0001 31JAN2015 15FEB2015 0001 15FEB2015 30APR2015 0001 01MAY2015 15MAY2015 0001 16MAY2015 31MAY2015 0001 01JUN2015 15SEP2015 0001 16SEP2015 31DEC2015 ...... ; File3 desired output: data output; input ID :$20. Start :date9. End :date9. Label :$20. Role :$20.; format start end yymmdd10.; cards; 0001 01JAN2015 30JAN2015 HospitalA ex005 0001 31JAN2015 15FEB2015 HospitalA ex005 0001 15FEB2015 30APR2015 HospitalA ex005 0001 01MAY2015 15MAY2015 HospitalA ex004 0001 16MAY2015 31MAY2015 HospitalA ex004 0001 01JUN2015 15SEP2015 HospitalC ex005 0001 16SEP2015 31DEC2015 HospitalC ex005 ...... ;           ... View more

Hi guys,  I have two data sets and, for each ID, I have to split each row of the first including the intervals of the second. Furthermore, while doing this, I need to divide the values in the Count variable of the first data set by the days in the new interval but only when the period refers to the first data set and not to the second because in this last case I will have a Label. Can anyone help me please? Here the data set and desired output:   data work;   input ID :$20. Start :date9. End :date9. Counts :$20.;   format start end yymmdd10.; cards; 0001 01JAN2015 18JAN2015 32499 0001 19JAN2015 30APR2015 23458 0001 01MAY2015 13JAN2016 987 0002 06FEB2019 15FEB2019 3567 0002 16FEB2019 31DEC2019 1254 0003 01JAN2020 18MAR2020 652 0003 19MAR2020 02APR2020 765 0003 03APR2020 31DEC2020 200   data vacations;   input ID :$20. Start :date9. End :date9. Label :$20.;   format start end yymmdd10.; cards; 0001 03JAN2015 10JAN2015 A    0001 21JAN2015 21JAN2015 B 0001 03MAY2015 09JAN2016 C 0002 08FEB2019 08FEB2019 B 0002 09FEB2019 15FEB2019 A 0003 20FEB2020 25FEB2020 C 0003 21MAR2020 21MAR2020 B 0003 04JAN2020 10JAN2020 A ;   data want;   input ID :$20. Start :date9. End :date9. Label :$20. Counts_resized :$20.;   format start end yymmdd10.; cards; 0001 01JAN2015 02JAN2015 ? 0001 03JAN2015 10JAN2015 A 0001 11JAN2015 18JAN2015 ? 0001 19JAN2015 20JAN2015 ? 0001 21JAN2015 21JAN2015 B 0001 22JAN2015 30APR2015 ? 0001 01MAY2015 02MAY2015 ? 0001 03MAY2015 09JAN2016 C 0001 10MAY2016 13JAN2016 ? …………. ; Thank you in advance   ... View more