I have two data set that I'd like to merge and keep only one recorded time that is the same or closest to the diagnosis date. (The date different should not exceed 365 days) Dataset1: DMRN dx_date age 284 07SEP2017 65 285 27APR2021 78 286 03MAY2019 72 Dataset2: DMRN recorded_time dressing grooming 284 07SEP2017 1 2 284 14JUN2018 1 1 284 26SEP2018 1 1 285 02APR2021 2 2 285 22OCT2021 2 2 286 03MAY2019 1 1 286 27NOV2019 1 1 I would like the new dataset to be: DMRN dx_date age recorded_time dressing grooming 284 07SEP2017 65 07SEP2017 1 2 285 27APR2021 78 02APR2021 2 2 286 03MAY2019 72 03MAY2019 1 1 I tried to merge both dataset by DMRN and calculate date difference between diag date and recorded time, but I don't know which code to use to keep only one recorded time that is the same or closest to diag date(not exceed 365 days). Any help or suggestion would be very appreciated. Thank you.
... View more