Date:         Fri, 14 May 2004 16:19:27 +0100
Reply-To:     Robert Walls <robert.walls@EUROPE.PPDI.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Robert Walls <robert.walls@EUROPE.PPDI.COM>
Organization: PPD
Subject:      Re: proc sort
Comments: To: helen <chenghelen2000@YAHOO.COM>
Content-Type: text/plain; charset=iso-8859-1

Helen,

Have you tried the nodupkey option on your proc sort.  E.g.:

    proc sort data = work.X1 out = work.X2 nodupkey;
        by listing vars;
    run;
This will remove all of your duplicate obs for the by variables of the
proc sort from the data set, and I think that the option nodup will just
remove all repeat obs for all of the variables in a data set (but don't
quote me on that one!).

HTH,

Rob.




helen wrote:

> Hello All,
>
> I have a dataset contained some duplicate data. I'd like to delete
> those observations. Normally I use ‘proc sort ; by listing vars'
> statement to do it. In my case, there are around 60 variables for one
> observation, I'd like to compare 59 variables to see if it is
> duplicate,  instead of list all variables, is there any easy way to do
> it?
>
> Thanks in advance.

_______________________________________________________
This e-mail transmission and any documents, files or previous email messages attached to it may contain information that is confidential or legally privileged. If you are not the intended recipient or a person responsible for delivering this transmission to the intended recipient, you are hereby notified that you must not read this transmission and that any disclosure, copying, printing, distribution or use of this transmission is strictly prohibited. If you have received this transmission in error, please immediately notify the sender by telephone or return email and delete the original transmission and its attachments without reading or saving in any manner.