I have a data set contains DMRN, last visit date, the presence of UI, and recorded date of UI.
DMRN
last_visit
UI
recorded_time
31
26AUG2021
0
06APR2018
31
26AUG2021
0
16JAN2020
31
26AUG2021
1
4MAY2021
33
24MAY2022
0
02MAR2020
33
24MAY2022
0
24MAY2022
35
01DEC2014
0
25MAR2013
I would like to create new_date for each DMRN based on these conditions: if UI = 1 then new_date = recorded_time else if UI = 0 then new_date = last_visit The outcome would be like as follow:
DMRN
last_visit
UI
recorded_time
new_date
31
26AUG2021
0
06APR2018
4MAY2021
31
26AUG2021
0
16JAN2020
4MAY2021
31
26AUG2021
1
4MAY2021
4MAY2021
33
24MAY2022
0
02MAR2020
24MAY2022
33
24MAY2022
0
24MAY2022
24MAY2022
35
01DEC2014
0
25MAR2013
01DEC2014
Could you please help me with the code? Thank you very much
... View more