Date:         Fri, 14 May 2004 16:55:53 +0100
Reply-To:     "Ravikumar. J" <ravi_pune@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Comments:     To: helen <chenghelen2000@YAHOO.COM>
From:         "Ravikumar. J" <ravi_pune@YAHOO.COM>
Subject:      Re: proc sort
Comments: To: SAS-L@LISTSERV.VT.EDU
In-Reply-To:  <fadc20d0.0405140700.11930b3f@posting.google.com>
Content-Type: text/plain; charset=iso-8859-1

Hello,

You can probably use PROC SORT with NODUPRECS option and specify "BY
_ALL_" instead of specifying all the variables.

PROC SORT DATA=TEST NODUPRECS;
BY _ALL_;
RUN;

Cheers
Ravi



 --- helen <chenghelen2000@YAHOO.COM> 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.

________________________________________________________________________
Yahoo! India Matrimony: Find your partner online. http://yahoo.shaadi.com/india-matrimony/