Date: Mon, 27 Oct 2008 18:31:34 -0700
Reply-To: Phil <phillip.anderra@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Phil <phillip.anderra@GMAIL.COM>
Organization: http://groups.google.com
Subject: Coding help required.
Content-Type: text/plain; charset=ISO-8859-1
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
|