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 (July 2008, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Sat, 5 Jul 2008 08:32:32 -0700
Reply-To:     KL <Kev.L.Scott@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         KL <Kev.L.Scott@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: PROC SORT
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

On Jul 5, 10:36 am, r...@CDC.GOV ("Fehd, Ronald J. (CDC/CCHIS/NCPHI)") wrote: > > From: SAM > > I wanna know if there is a way to sort data more fast than the "PROC > > SORT" do. > > what are your priorities? > > * accurate > * cheap > * fast > > as always, your two top priorities determine which algorithm you > pursue/peruse > > for your Reading and Research > > 1. use this code to examine other options related to sorting > > http://tinyurl.com/5zwfax > > http://www.sascommunity.org/wiki/Searching_for_word_in_dictionary.option > s > > 2. RTFM on and the sorting options found above > > 3. consider > > * buying SyncSort > > http://www.syncsort.com/ > > * indexing, see Raithel's book as mentioned in earlier post > > http://www.sas.com/apps/pubscat/bookdetails.jsp?catid=1&pc=60409 > > http://support.sas.com/publishing/bbu/podcasts/sgf/raithel.mp3 > > Ron Fehd the macro maven CDC Atlanta GA USA RJF2 at cdc dot gov

We also need to know what the programmatic context in which the SORT is being performed, please refer to my questions regarding why the data needs to be sorted.

For example If it is for merging/joining purposes then the sort can be avoided either by using a hash based join in data step or SQL or a SET KEY= index join if the amount of records being joined in the master table is small relative to its overall size.


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