I have a dataset that looks similar to this MemberID StartDate1 EndDate1 Startdate2 Enddate2 StartDate3 EndDate3...StartDate20 Enddate20 XXXXXX 01Jun2013 30Jul2015 XXXXXX 01Aug2015 31Dec2016 01Feb2017 01Sep2017 XXXXXX 15Jan2012 15Dec2017 XXXXXX 01Jan2014 01May2014 15June2014 15Aug2016 I have to determine 6 months of continuous enrollment with an allowable gap of 45 days during a two year measure period, lets say Jan 01 2015-Dec 31, 2017. There is no anchor date. So essentially, I want to check all enrollment dates between Jan 01 2015 and December 31st 2017 and see if they have at least 6 months of continuous enrollment. I'm not sure how to approach this when there are multiple start and end dates. Does anyone have any suggestions?
... View more