LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous (more recent) messageNext (less recent) messagePrevious (more recent) in topicNext (less recent) in topicPrevious (more recent) by same authorNext (less recent) by same authorPrevious page (October 2006, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Fri, 27 Oct 2006 11:55:03 -0400
Reply-To:   "data _null_;" <datanull@GMAIL.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   "data _null_;" <datanull@GMAIL.COM>
Subject:   Re: Difference between nodup and nodupkey in sort procedure
Comments:   To: Jim Groeneveld <jim2stat@yahoo.co.uk>
In-Reply-To:   <200610260835.k9PNYMq0026639@malibu.cc.uga.edu>
Content-Type:   text/plain; charset=ISO-8859-1; format=flowed

I was just quoting the documentation. I don't care about the difference real or perceived.

On 10/26/06, Jim Groeneveld <jim2stat@yahoo.co.uk> wrote: > Hi Data Null, > > In that case, sorting on all variables, you could as well use NODUPKEY. > So for what instances is NODUPRECS then intended specifically? > > Regards - Jim. > -- > Jim Groeneveld, Netherlands > Statistician, SAS consultant > home.hccnet.nl/jim.groeneveld > > On Wed, 25 Oct 2006 15:41:30 -0400, data _null_; <datanull@GMAIL.COM> wrote: > > >Check the documentation in particular this passage. > > > >Because NODUPRECS checks only consecutive observations, some > >nonconsecutive duplicate observations might remain in the output data > >set. You can remove all duplicates with this option by sorting on all > >variables > > > >On 10/25/06, Xu Libin <Libin.Xu@irs.gov> wrote: > >> I thought that nodup option in proc sort get rid of duplicate records > >> and nodupkey get rid of duplicates of the by variable. When I ran the > >> below syntax, > >> > >> Proc sort data=old out=new nodup; > >> By id; > >> Run; > >> > >> About 760 cases were deleted. But I was told that they are not duplicate > >> records. At least one variable has different values. Can anyone on the > >> list provide an explanation for this? Thanks. > >> > >> Libin > >> >


Back to: Top of message | Previous page | Main SAS-L page