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 (June 2003, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Thu, 26 Jun 2003 09:52:30 -0700
Reply-To:     Jeff Morison <jmt_mtf@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jeff Morison <jmt_mtf@YAHOO.COM>
Subject:      Large dataset
Content-Type: text/plain; charset=us-ascii

I have a dataset containing 16 million observations of account numbers plus 10 other variables, I need to sort it by acct# and remove the duplicate account# records.

What is fastest way to do this?.

PROC SORT with NODUPKEY is draining all my resources.

Any other efficient ways to do this.

TIA, Jeff

__________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com


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