Date:         Thu, 24 Feb 2000 20:07:29 GMT
Reply-To:     robin_rl@MY-DEJA.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         robin_rl@MY-DEJA.COM
Organization: Deja.com - Before you buy.
Subject:      Re: How do you check for duplicatess?

Maurice,

You probably already know this, but the NODUPLICATES option in the Sort
procedure is easy to use for deduping a data set.

-Robin

In article <893rq5$cso$1@goblin.tdh.state.tx.us>,
  "Maurice Muoneke" <maurice.muoneke@tpwd.state.tx.us> wrote:
> I am trying to use the code below to detect duplicate records.  The
field
> 'longdata' is a concatenation of all the variables.  I know there are
> duplicates, but when I run it, I get all the records in the duplicates
file
> and no records in the other file.  What is wrong?
>
> proc sort data = inld7.all; by longdata; run;
> data INLD7.dups INLD7.nodups ; SET INLD7.ALL;
>    if first.longdata then
>       output INLD7.nodups;
>    else
>     output INLD7.dups;
> run;
>
>


Sent via Deja.com http://www.deja.com/
Before you buy.