Date: Thu, 24 Feb 2000 20:07:29 GMT
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Organization: Deja.com - Before you buy.
Subject: Re: How do you check for duplicatess?
You probably already know this, but the NODUPLICATES option in the Sort
procedure is easy to use for deduping a data set.
In article <firstname.lastname@example.org>,
"Maurice Muoneke" <email@example.com> wrote:
> I am trying to use the code below to detect duplicate records. The
> '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
> 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;
> output INLD7.dups;
Sent via Deja.com http://www.deja.com/
Before you buy.