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 ?
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: