Date:         Thu, 23 Feb 2006 01:56:32 -0800
Reply-To:     Joep <jsteeman@BUSINESSDECISION.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Joep <jsteeman@BUSINESSDECISION.COM>
Organization: http://groups.google.com
Subject:      Re: studying repeats
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset="iso-8859-1"

Lori,

If you want to be able to examine the repeated records, you could use
something like the following:

data temp;
  input var1 $ var2;
  datalines;
A 1
A 1
B 1
C 1
B 1
B 2
D 2
A 2
D 3
D 3
E 1
E 1
E 3
;
RUN;


proc sort data=temp;
  by var1 var2;
run;

data doubles;
  set temp;
  by var1 var2;
  if not (first.var2 and last.var2);
run;

Hope this is helpfull,

Joep