Hi. Thank you for getting back to me. 😀

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

•The B2H_Status variable holds the codes for the actually different types of status changes.

o 4=Enrolled

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