Hello New SAS User, I am currently working on project using claims information.  Currently I have two tables.   Table 1. ENROLID INDEX DATE 123              11/02/2018 234              6/05/2017   Table 2.  ENROLID YEAR ENROL1 ENROL2 ENROL3... ENROL12 123             2017      1             1             0                 1 123             2018      1             1             1                 1 ENROL1 = Janurary ENROL2 = February etc.. up to ENROL12   I need to know whether ENROLID 123 is continous enrolled 1 year before the index date (11/02/2018).   Thank you inadvance for any help you are able to provide! ... View more