BookmarkSubscribeRSS Feed
SASTad
Fluorite | Level 6

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.

1 REPLY 1
Ksharp
Super User

What do you mean by " is eligible for a continuous period of six months during that particular year."  ?

How do you define continuous period of six months? it is for an individual row or Member_ID  ?

And you did not post the output you want to see yet , it is important . 

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1250 views
  • 0 likes
  • 2 in conversation