Hi I would like to know how to count continuously enrolled patients form the claims data.
My data looks like this my enrollment duration is 3 years in the data and follow up time 6 months before index date and 1 2months after index date
Patient ID | INDEX DATE | START DATE | END DATE | TYPE | ENROLLEMNT DATE |
1 | 3/3/2015 | 9/4/2014 | 3/2/2016 | B | 2014/01 |
1 | 3/3/2015 | 9/4/2014 | 3/2/2016 | B | 2014/02 |
1 | 3/3/2015 | 9/4/2014 | 3/2/2016 | B | 2014/03 |
2 | 8/16/2014 | 2/17/2014 | 8/16/2015 | B | 2014/01 |
2 | 8/16/2014 | 2/17/2014 | 8/16/2015 | B | 2014/02 |
2 | 8/16/2014 | 2/17/2014 | 8/16/2015 | B | 2014/03 |
2 | 8/16/2014 | 2/17/2014 | 8/16/2015 | B | 2014/04 |
2 | 8/16/2014 | 2/17/2014 | 8/16/2015 | B | 2014/05 |