Date:         Thu, 8 Sep 2005 21:45:43 -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: how to keep the duplicate records only?
Comments: To: Wei Yi <wy78712@YAHOO.COM>

Wei,

Assuming you have sorted your data by the key (e.g., id), then try
something like the following:

data dupkeys;
  set x;
  by id;
 if not first.id;
run;

Art
---------
On Thu, 8 Sep 2005 17:58:11 -0700, wei yi <wy78712@YAHOO.COM> wrote:

>Hello, All
>I have a dataset with some duplicate records, I know
>to use nodupkey to exclude the duplicate records.
>But how I could keep all these duplicate records in a
>file?
>
>Thanks,
>Wei
>
>__________________________________________________
>Do You Yahoo!?
>Tired of spam?  Yahoo! Mail has the best spam protection around
>http://mail.yahoo.com