Hello, I have a dataset with multiple rows per id and I am trying to create episode start and end dates. My data looks as follows: ID trgt_dt A1600 A1700 A1800 R4 A2100 1 9-Jun-00 . . . . . 1 14-Jun-00 2-Jun-00 1 3 . . 1 22-Jun-00 . . . 22-Jun-00 1 1 13-Nov-03 . . . . . 1 19-Nov-03 6-Nov-03 1 3 . . 1 22-Nov-03 . . . 22-Nov-03 1 1 23-Jan-07 16-Jan-07 1 3 . . 1 29-Jan-07 . . . . . 1 31-Jan-07 . . . 31-Jan-07 1 1 1-Feb-07 . . . . . 1 11-Feb-07 31-Jan-07 1 3 11-Feb-07 3 1 12-Feb-07 12-Feb-07 2 3 . . 1 19-Feb-07 6-Feb-07 1 3 . . 1 22-Feb-07 . . . . . 1 5-Mar-07 . . . . . 1 26-Mar-07 . . . 26-Mar-07 1 A1600 is the entry/reentry date, A1700 = 1 when its an entry and 2 when its a reentry. R4 is the discharge date. I want to use the dates per ID to create a chronological sequence of events for the patient in terms of start and end of episodes. Sometimes discharge dates can be missing. The desired output would look as follows: ID trgt_dt A1600 R4 stay_entry stay_end 1 9-Jun-00 . . 2-Jun-00 . 1 14-Jun-00 2-Jun-00 . 2-Jun-00 . 1 22-Jun-00 . 22-Jun-00 2-Jun-00 22-Jun-00 1 13-Nov-03 . . 6-Nov-03 . 1 19-Nov-03 6-Nov-03 . 6-Nov-03 . 1 22-Nov-03 . 22-Nov-03 6-Nov-03 22-Nov-03 1 23-Jan-07 16-Jan-07 . 16-Jan-07 . 1 29-Jan-07 . . 16-Jan-07 . 1 31-Jan-07 . 31-Jan-07 16-Jan-07 31-Jan-07 1 1-Feb-07 . 1-Feb-07 31-Jan-07 1-Feb-07 1 11-Feb-07 31-Jan-07 11-Feb-07 6-Feb-07 11-Feb-07 1 12-Feb-07 12-Feb-07 . 12-Feb-07 . 1 19-Feb-07 6-Feb-07 . 12-Feb-07 . 1 22-Feb-07 . . 12-Feb-07 . 1 5-Mar-07 . . 12-Feb-07 . 1 26-Mar-07 . 26-Mar-07 12-Feb-07 26-Mar-07 How can I achieve this with sas coding? Thank you in advance.
... View more
