Hi. Thank you for getting back to me. :-D
I need to pull a count of clients enrolled in a program by month. CLT_NBR is a unique ID for each client.
•I want the total count of clients that were enrolled at the end of the month.
•So include all clients enrolled prior to the period end date. I am using there Max(EFFECT_DT
) during the month to determine the count at the end of the month. The EFFECT_DT
gives the status change dates. SO the Max(Effect_DT) is the last status change the client had during the month.
•I need exclude all clients disenrolled
or transferred out
prior to the start date and Exclude all clients who transferred in after the prior end date
variable holds the codes for the actually different types of status changes.
o 7= Disenrolled
o 8= Transfer In
o 9= Transfer Out
If the Period date range selected is 1/01/2013 to 3/01/2013
Total_Clients_Enrolled_Count Month Year
252 Jan 2013
247 Feb 2013
303 March 2013