Hi all, I have a test data with missing values and I want to fill the table by taking previous month's value. Test data ID response date 1 CR 02Jan2020 2 PR . 3 NE 04Jan2020 4 SD . 5 PR 05Jan2020 6 CR . data I want to have ID response date 1 CR 02Jan2020 2 PR 02Jan2020 3 NE 04Jan2020 4 SD 02Jan2020 5 PR 05Jan2020 6 CR 05Jan2020 So, if the response NE, then I don't want to retain the NE date but the date before NE. But if the response is not NE, then I wanna retain the previous date. I tried multiple ways, but couldn't figure it out. Please help.
... View more