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 ?
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.