LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (May 1998, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Fri, 15 May 1998 12:09:28 -0600
Reply-To:   Jack Hamilton <jack_hamilton@HCCOMPARE.COM>
Sender:   "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:   Jack Hamilton <jack_hamilton@HCCOMPARE.COM>
Subject:   Re[2]: removing duplicates with NODUPKEY????
Content-Type:   text/plain; charset=US-ASCII


> Alan Rimm-Kaufman <rimmkaufman@CRUTCHFIELD.COM> asked about the > NODUPKEY option of PROC SORT and suggested that it might not work. The > The NODUPKEY works as advertised. It makes the the BY-GROUP values > unique by removing all records after the first with the same key > values. Since the keys are unique, the records are also unique.

I haven't encountered problems with it myself, but one of the Usage Notes I posted earlier says that NODUPKEY has problems under some circumstances. I think it's a good idea to avoid both options, and do the duplicate deletion in a data step or with PROC SQL (which may force you to rethink what you want to do, sometimes a good thing).

> On the other hand, the NODUP option is a long time snare! I first > remember it in version 5.03. And there is no relief in sight, since > it remains in the version 7 beta.

That's not good. SAS specifically said that some of the SORT problems would be fixed in V7. Perhaps they were referring to other sort problems.

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