Hello,
I'm trying to count six continuous eligible months or more in one calender year for a particular recepient in health insurance industry. For example, please find the sample data below:
Member_ID Begin_Month Begin_Year End_Month End_Year
1 3 2008 4 2008
1 5 2008 8 2008
1 9 2008 11 2008
2 1 2008 2 2008
2 5 2008 12 2009
I'm trying to see if a member is eligible for a continuous period of six months during that particular year. The original data set has over 80,000 Member ID's. Could you please help me out with any suggestions.
Thank you.