SAS Support Communities

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

Hi guys,  suppose to have the following:  data have; input ID :$20. Start :ddmmyy. End :ddmmyy. Label :$20.; format start end yymmdd10.; cards; 0001 01JAN1998 18JAN1998 A 0001 20JAN1998 22JAN1998 A 0001 02FEB1998 02FEB1998 A 0002 06FEB1998 08FEB1998 B 0002 03MAR2000 15MAR2000 A 0002 16MAR2000 18MAR2000 A 0003 01MAY2000 18MAY2000 C 0003 19MAY2000 22MAY2000 C ..... .................... ; I need the following: data want; set have; ID Start End Label Days 0001 01JAN1998 22JAN1998 A 22 0001 02FEB1998 02FEB1998 A 1 0002 06FEB1998 08FEB1998 B 2 0002 03MAR2000 18MAR2000 A 16 0003 01MAY2000 22MAY2000 C 22 .................................. ; Meaning, for each ID and for each condition summarise periods (update the end date and calculate the sum of the days) only if the periods differ of 1 day or they are consecutive like 18-20JAN and 15-16MAR, otherwise do nothing and only count the days in the interval. Can anyone help me please? I tried to remove the cases where I have not to sum and then merge with the records where I have to sum but SAS stops running. I have 68000 records totally. Thank you in advance ... View more

Hi guys, is there a way to remove rows in a file that are not present in a second file by matching the column ID?    Thank you in advance   For example suppose to have:  data set1    ID            AGE               Role     001          35-50                A     002          55-60                B     003          35-50                C     004          35-50                D     005          35-50                E       and data set2  ID            Hours            Vacancies      002           900                    21     003           456                    54      005            45                      0      I would like the data set1 to become:    ID           AGE               Role     002        55-60                B     003        35-50                C     005        35-50                E         ... View more