Date: Thu, 24 Feb 2000 19:03:12 GMT
Reply-To: Jens <jms%email.de%email.de%email.de@BROMO.EMAIL.CH>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Jens <jms%email.de%email.de%email.de@BROMO.EMAIL.CH>
Organization: JMS Consulting
Subject: Re: How do you check for duplicatess?
Content-Type: text/plain; charset="iso-8859-1"
You didn't had a look at the log, eh ? Else you would have seen that
SAS does not know about first.longdata. You have to use a BY statement
!
SET INLD7.ALL;
BY longdata;
if (first.longdata and last.longdata) then output nodups;
else output dups;
> 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;
>
>
|