SAS Support Communities

Dear all,  suppose to have the following:  data DB; input ID :$20. Admission :date09. Discharge :date09.; format Admission date9. Discharge date9.; cards; 0001 13JAN2015 13JAN2015 0001 13JAN2015 31MAR2015 0001 01MAR2018 30SEP2018 0001 01JAN2019 31DEC2019 0002 01JAN2015 31DEC2015 0002 01JAN2019 01JAN2019 0002 01JAN2019 15APR2019 ; Is there a way to get the following?    data DB1; input ID :$20. Admission :date09. Discharge :date09.; format Admission date9. Discharge date9.; cards; 0001 13JAN2015 31MAR2015 0001 01MAR2018 30SEP2018 0001 01JAN2019 31DEC2019 0002 01JAN2015 31DEC2015 0002 01JAN2019 15APR2019 ; In other words for equal admission dates I would like to remove the rows where admission == discharge and retain all the cases where admission =! discharge. The first case occurs because there is an emergency department access while the second is a real admission.    Can anyone help me please?    Best ... View more

Hi guys,  suppose to have the following dataset:    data DB; input Admission :date09. week :$20. Count_path1 Count_path2; format Admission date9.; cards; 06JUL2014 28w2014 0 21 13JUL2014 29w2014 1 56 20JUL2014 30w2014 0 0 27JUL2014 31w2014 3 1 03AUG2014 32w2014 4 4 10AUG2014 33w2014 0 0 ; and another one:    data DB1; input week :$20. Pathogen :$20. Value; ; cards; 28w2014 path1 23 29w2014 path1 1 30w2014 path2 56 31w2014 path1 67 32w2014 path2 6 33w2014 path2 2 ; Is there a way to get the following?   data DB3; input Admission :date09. week :$20. Count_path1 Count_path2 path1 path2; format Admission date9.; cards; 06JUL2014 28w2014 0 21 23 0 13JUL2014 29w2014 1 56 1 0 20JUL2014 30w2014 0 0 0 56 27JUL2014 31w2014 3 1 67 0 03AUG2014 32w2014 4 4 0 6 10AUG2014 33w2014 0 0 0 2 ; In other words I would like to join the two tables at week and pathogen variables.    Thank you in advance ... View more

Hi guys,  suppose to have the following table:      data DB; input ID :$20. Admission :date09. Discharge :date09. Age_class Age_end Index Value Total; format Admission date9. Discharge date9.; cards; 0001 01JUL2014 16AUG2014 1 4 1 2.3 11.9 0001 13MAY2018 22JUN2018 3 4 0 1.4 . 0001 23JAN2019 25JAN2019 4 4 0 3.2 . 0002 13MAY2016 22SEP2016 1 5 1 2 7.9 0002 09JUL2023 10JUL2023 2 5 0 0.3 . 0002 12SEP2024 15SEP2024 3 5 0 0.2 . 0003 01JUL2014 18AUG2014 1 3 1 12 17.3 0003 07DEC2023 16DEC2023 2 3 0 0.3 . 0004 12JAN2014 15JAN2014 1 2 1 2 2.1 0004 30MAY2019 13JUL2019 2 2 0 0.1 . 0005 30JUN2019 13OCT2019 5 5 0 4.1 . ; run;     Is there a way to get the following?   data DB1; input ID :$20. Admission :date09. Discharge :date09. Age_class Age_end Index Value Total Age_class1 Age_class2 Age_class3 Age_class4 Age_class5; format Admission date9. Discharge date9.; cards; 0001 01JUL2014 16AUG2014 1 4 1 2.3 11.9 2.3 5 1.4 3.2 . 0001 13MAY2018 22JUN2018 3 4 0 1.4 . . . . . . 0001 23JAN2019 25JAN2019 4 4 0 3.2 . . . . . . 0002 13MAY2016 22SEP2016 1 5 1 2 7.9 2 0.3 0.2 5 0.4 0002 09JUL2023 10JUL2023 2 5 0 0.3 . . . . . . 0002 12SEP2024 15SEP2024 3 5 0 0.2 . . . . . . 0003 01JUL2014 18AUG2014 1 3 1 12 17.3 12 0.3 5 . . 0003 07DEC2023 16DEC2023 2 3 0 0.3 . . . . . . 0004 12JAN2014 15JAN2014 1 2 1 2 2.1 2 0.1 . . . 0004 30MAY2019 13JUL2019 2 2 0 0.1 . . . . . . 0005 30JUN2019 13OCT2019 5 5 1 4.1 4.1 . . . . 4.1 ; run; In other words, for each ID in DB there is the Age_class at each admission and an Age_class at exit (Age_end) from the study. Then, there is the "Value" variable that is the time the patient stay in the corresponding Age_class (before exit). There is also a "Total" time in the study. What I need is to transform the dataset DB into a wide format where there are columns corresponding to the age classes filled by the corresponding Value. Note that in this new dataset the row-wise total must be reached and must be equal to "Total" and so: if there is a jump in the age classes (Age_class variable) a value = 5 years must be added because the age-class interval is of max 5 years.  Finally, in the new wide dataset (DB1) rows must be filled only where Index = 1     Can anyone help me please?     Thank you very much in advance   ... View more

Hi guys,  suppose to have the following:    data DB; input ID :$20. Var1: $20. Value1; cards; 0001 Mydate1 2 0001 Mydate2 . 0002 Mydate1 . 0002 Mydate2 4 0003 Mydate1 2 0003 Mydate2 . 0003 Mydate3 6 0003 Mydate4 . 0003 Mydate5 0 run; Is there a way to add a number = 5 every time, for each ID Mydate1 is not missing as Mydate3 while Mydate 2 is missing?   Desired output:   data DB1; input ID :$20. Var1: $20. Value1; cards; 0001 Mydate1 2 0001 Mydate2 . 0002 Mydate1 . 0002 Mydate2 4 0003 Mydate1 2 0003 Mydate2 5 0003 Mydate3 6 0003 Mydate4 . 0003 Mydate5 0 run;   Rule: for each ID if not missing (Mydate1) and not missing(Mydate3) and missing(Mydate2) then Mydate2 = 5. Thank you in advance ... View more

Hi guys, suppose to have the following:    data DB; input ID :$20. Var1: $20. Value1 Value2; cards; 0001 Mydate1 . . 0001 Mydate2 3.4 3.4 0002 Mydate1 . . 0002 Mydate2 3 3 0003 Mydate1 . . 0003 Mydate2 . . 0003 Mydate3 . . 0003 Mydate4 . . 0003 Mydate5 0 3.4 run; I would say the following:  if for each ID value 1 is always missing (for every Mydate*) or 0 (i.e., never a number different from 0 or not missing) then where Value1 = 0 then Value1 = Value2.    Desired output:    data DB1; input ID :$20. Var1: $20. Value1 Value2; cards; 0001 Mydate1 . . 0001 Mydate2 3.4 3.4 0002 Mydate1 . . 0002 Mydate2 3 3 0003 Mydate1 . . 0003 Mydate2 . . 0003 Mydate3 . . 0003 Mydate4 . . 0003 Mydate5 3.4 3.4 run;   Can you help me please?   ... View more

Hi guys, I have a date like this: 01JUL2021. How can I get 01JUL2020? I need to subtract exactly one year.   I tried the following but without success. The date is no more "01JUL" my_new_date = INTNX('YEAR',mydate,-1);   Thank you in advance     Best ... View more