Month counts in a specific date range

[angel302]

I am trying to evaluate member's plan eligibility as of the 15th of each month for this population in 2014. Below is my dataset, called Member:

MemberID       Elig_Start           Elig_End

            1               1/1/2014          9/25/2014
            2               1/1/2014         12/31/9999
            3               1/1/2012          2/31/2013

The output should be something like this:

MemberID       Elig_Start           Elig_End                Elig_Month

            1               1/1/2014          9/25/2014                     9

            2               1/1/2014         12/31/9999                   12 
            3               1/1/2012          2/31/2013                      0 (or missing)

Anybody has idea? Thank you!

[PaigeMiller]

It is generally not a good idea to post the same question more than once.

All replies should go to the other thread at https://communities.sas.com/t5/SAS-Programming/Month-counts-in-certain-date-period/td-p/594310

[angel302]

Sorry for repeating my question. I posted the question in this new user community first, but then thought the other community is a better place too go.