[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sas-l
Subject:    Re: Need help in determining a gap
From:       Dave Brewer <david.brewer () UC ! EDU>
Date:       2012-06-30 16:47:51
Message-ID: 201206301647.q5U4X8C9024950 () waikiki ! cc ! uga ! edu
[Download RAW message or body]

Good catch...It doesn't matter what the day of the month, just as long as
they were enrolled in that month. Joe's solution solved  my problem.

Thanks again for your help.
Dave

On Sat, 30 Jun 2012 08:57:15 -0700, retired mainframer <retired-
mainframer@Q.COM> wrote:

>The second observation for id 789 demonstrates that enrollment need not be
>the first of the month.  If the second observation for id 090 was
>05/02/2011, would that still be continuous enrollment?  What about 05/15
or
>05/31?
>
>:>: -----Original Message-----
>:>: From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
>:>: Dave
>:>: Sent: Saturday, June 30, 2012 7:15 AM
>:>: To: SAS-L@LISTSERV.UGA.EDU
>:>: Subject: Need help in determining a gap
>:>:
>:>: I am working with state Medicaid claims using PC SAS 9.3.
>:>:
>:>: I need to determine when a recipient first loses enrollment. Study
>:>: period
>:>: ends June 1, 2011. If a recipient has continuous enrollment thru June
1,
>:>: 2011 then that recipient did not lose enrollment.
>:>:
>:>: data need;
>:>:  input id $ enroll_dt :mmddyy10.;
>:>:  format enroll_dt mmddyy10.;
>:>: cards;
>:>: 123 01/01/2011
>:>: 123 02/01/2011
>:>: 123 03/01/2011
>:>: 123 06/01/2011
>:>: 456 04/01/2009
>:>: 456 05/01/2009
>:>: 456 05/01/2011
>:>: 456 06/01/2011
>:>: 789 01/01/2008
>:>: 789 02/02/2008
>:>: 090 04/01/2011
>:>: 090 05/01/2011
>:>: 090 06/01/2011
>:>: ;
>:>: run;
>:>:
>:>: Only recipient 090 would not be disenrolled and the value
of 'disenroll'
>:>: variable would be 0 (zero) and date_disenroll would be missing.
>:>:
>:>: Recipient 123 'disenroll' would be 1 (one) with date_disenroll =
>:>: 03/01/2011.
>:>:
>:>: Recipient 456 'disenroll' would be 1 (one) with date_disenroll =
>:>: 05/01/2009.
>:>:
>:>: Recipient 789 'disenroll' would be 1 (one) with date_disenroll =
>:>: 02/02/2008.
>:>:
>:>: Any suggestions?
>:>:
>:>: Thanks much.
>:>: Dave
[prev in list] [next in list] [prev in thread] [next in thread]