Hello, I have the below dataset where some events happen. C- stands for Create and D- stands for Delete. At some point in time, I am creating some values (i.e. C-a) or delete them (D-a) within an array of N Events. My task would be to retain the previous created values along with the new created values, and if a detelete event occurs, then the output should stop retaining the value. data have; infile datalines delimiter=','; input ID date mmddyy10. Event1 $ Event2 $ Event3 $ Event4 $; format date date9.; datalines; 1,03-31-2013,C-a,C-b,.,. 1,05-31-2013,D-b,.,.,. 1,07-31-2013,C-d,C-e,C-f,. 1,08-31-2013,D-e,C-g,.,. 2,04-30-2018,C-h,C-i,D-h,C-j 2,07-31-2018,C-k,.,.,. 2,12-31-2018,D-i,C-o,D-j,D-k ; run; data want; infile datalines delimiter=','; input ID date mmddyy10. Event1 $ Event2 $ Event3 $ Event4 $; format date date9.; datalines; 1,03-31-2013,C-a,C-b,.,. 1,05-31-2013,C-a,.,.,. 1,07-31-2013,C-a,C-d,C-e,C-f 1,08-31-2013,C-a,C-d,C-f,C-g 2,04-30-2018,C-i,C-j,.,. 2,07-31-2018,C-i,C-j,C-k,. 2,12-31-2018,C-o,.,.,. ; run; I would very much appreciate your help. Thank you!
... View more