Date:         Mon, 27 Oct 2008 22:58:31 -0400
Reply-To:     Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:      Re: Coding help required.
Comments: To: phillip.anderra@GMAIL.COM

Phil,

Define what you consider to be a consecutive month.  You say that only 6
rows should be included from your example.  Why only 6 and which ones?

Art
---------
On Mon, 27 Oct 2008 18:31:34 -0700, Phil <phillip.anderra@GMAIL.COM> wrote:

>Hullo nice group,
>
>I need to extract *only* the rows below where the row is part of a
>sequence of >= six Consecutive Months. eg. From the dataset below
>there'd be a total of six rows output. It's proving too hard for me so
>if anyone could help it'd be appreciated.
>
>
>PIN               SrvDte       DaysGap    ConsecMths
>2999128       10AUG2007      0                 1
>                    26SEP2007     47                1
>                    04OCT2007      8                 2
>                    05OCT2007      1                 3
>                    06NOV2007     32                1
>                    29NOV2007     23                2
>                   11DEC2007      12                3
>                   27DEC2007      16                4
>                   24JAN2008       28                5
>                   04FEB2008      11                 6
>                   18MAR2008      43                1
>                   02MAY2008      45                1
>                    03JUL2008      62                 1
>
>
>
>cheers
>Phil