I need count monthly disenrollment for 2022.
Data table :
MEMBER_ID | ENROLLMENT | DISENROLLEMNT |
A0001 | 2/1/2021 | 3/1/2021 |
A0001 | 5/29/2021 | 6/24/2021 |
A0001 | 7/1/2021 | 8/1/2021 |
B0001 | 6/3/2021 | 8/2/2021 |
B0001 | 10/1/2021 | 11/1/2021 |
How do I have the monthly disenroll , and count by member_ID: as following
1. Member_ID, Disenroll_Month_Flg
A0001 202104
A0001 202107
A0001 202209
B0001 202109
B0001 202112
2. Summary: disenroll by month
month count:
202104 1
202107 1
202109 2
202112 1
3. Summery disenroll by member:
Member Count
A0001 3
B0001 2
thank you. But if I want count 2021 disenrollment, the rest of the month dose not enrolled should be counted as disenroll, hwo could I do that
similar to this ..but it is disenroll. How to ?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.