Date:         Mon, 3 Mar 2008 09:29:35 -0500
Reply-To:     "Diskin, Dennis" <Dennis.Diskin@PHARMA.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Diskin, Dennis" <Dennis.Diskin@PHARMA.COM>
Subject:      Re: Sequence group in SAS
Comments: To: "sukumarbaluswamy@gmail.com" <sukumarbaluswamy@GMAIL.COM>
In-Reply-To:  A<f1e30e53-d28d-424d-a1ae-02093f12fc47@e23g2000prf.googlegroups.com>
Content-Type: text/plain; charset="us-ascii"

data a2;
Set a;
Retain oldseq;
If oldseq + 1 ne seq then seqgr+1;
Oldseq = seq;
Drop oldseq;
Run;



-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
sukumarbaluswamy@gmail.com
Sent: Monday, March 03, 2008 9:14 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Sequence group in SAS

Hi,
I need to group the 'seq' as in the column 3. Can you please suggest
which SAS code to use? (Where ever it is not consecutive it is next
group).
Thanks in advance.
With Thanks & Regards,
Sukumar
Sno     Seq     SeqGr
1       110151  1
2       110152  1
3       110153  1
4       110154  1
5       110155  1
6       110156  1
7       110201  2
8       110202  2
9       110203  2
10      110204  2
11      110205  2
12      110206  2
13      110207  2
14      110208  2
15      110209  2
16      110222  3
17      110223  3
18      110271  4
19      110272  4
20      110273  4
21      110274  4
22      110275  4
23      110276  4
24      110277  4
25      110278  4
26      110279  4
27      110280  4
28      110281  4
29      110282  4
30      110297  5
31      110298  5
32      110299  5
33      110300  5
34      100310  6