Hello
I'm trying to keep a row that has a date closest to but after a test result date, Below is sample data. Is it possible to do this while the data is in long form?
Have:
Patient ComorbidityScore Test Result
Patient 1 Date 1 Date X
Date 2 Date X
Date 3 Date X
Patient 2 Date 1 Date Y
Date 2 Date Y
Want:
Patient ComorbidityScore Test Result
Patient 1 Date 3 Date X
Patient 2 Date 1 Date Y