topic Re: Month counts in a specific date range in New SAS User

Month counts in a specific date range

angel302 — Sun, 06 Oct 2019 07:13:39 GMT

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!

Re: Month counts in a specific date range

PaigeMiller — Sun, 06 Oct 2019 11:20:03 GMT

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

Re: Month counts in a specific date range

angel302 — Sun, 06 Oct 2019 16:52:39 GMT

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.