Date:         Wed, 11 Jul 2001 09:56:19 -0400
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: Question on Duplicates...
Comments: To: "TIEDENS GARY (smg1get)" <smg1get@UPS.COM>
Content-Type: text/plain

Gary,

Yes, assuming you have your dataset sorted on the ID variable then:

data dupes;
set inputds             ;
by id;
if not (first.id and last.id);

hth,
Dennis Diskin

> -----Original Message-----
> From: TIEDENS GARY (smg1get) [SMTP:smg1get@UPS.COM]
> Sent: Wednesday, July 11, 2001 9:41 AM
> To:   SAS-L@LISTSERV.UGA.EDU
> Subject:      Question on Duplicates...
>
> Hello all,
>
>  I am producing a report and I have duplicates within the report. Is there
> a
> way that I can have just the duplicate observations spun out to one output
> dataset.
> Dataset Name                                                 Alloc TRK
> USED TRK
> ===========                                                =======
> ========
> N318.IP06.CAIPLD01.CADSN01                      5,400 TRK        5,400 TRK
> N318.IP06.CAIPLD01.CADSN01                      5,400 TRK        5,400 TRK
> N318.IP06.CAIPLD01.CADSN01                      5,400 TRK        5,400 TRK
> N318.IP06.CAIPLD01.CADSN02                      5,400 TRK              0
> TRK
> =======================                       =======         ========
> Total                                                              21,600
> Trks     16,200 Trks
>
> Thanks,
>
>   Gary
>  <<TIEDENS GARY (smg1get).vcf>> << File: TIEDENS GARY (smg1get).vcf >>