Hi Ksharp, I have a follow-up question on your code. When a person have a break in their enrollment, for example, I revised the original dataset to the following and please note that person a now was enrolled from July 2019 to June 2020, had a break in July 2020, but then was re-enrolled in August 2020 then all the way to December 2020. data enrollment;
input ID$ Year Jan Feb March April May June July August Sep Oct Nov Dec ;
cards;
a 2019 0 0 0 0 0 0 1 1 1 1 1 1
a 2020 1 1 1 1 1 1 0 1 1 1 1 1
b 2018 1 1 1 1 1 1 1 1 1 1 1 1
b 2019 1 1 1 1 1 1 1 1 1 1 1 1
b 2020 1 1 1 1 1 1 1 1 1 1 0 0
c 2017 0 1 1 1 1 1 1 1 1 1 1 1
c 2018 1 1 1 1 1 1 1 1 1 1 1 1
c 2019 1 1 1 1 1 1 1 1 1 1 1 1
c 2020 1 1 1 1 1 0 0 0 0 0 0 0
run; In this case, the desired output would be as follow. My question is how do you revise the code that you provided to accommodate such situation? Thank you for your help! data want;
id start end
a July2019 Jun2020 a Aug2020 Dec2020
b Jan2018 Oct2020
c Feb2017 May2020.
... View more