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
|