Date:         Fri, 20 Jun 2003 19:53:39 +0100
Reply-To:     brookemaury@mindspring.com
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Brooke Maury <brookemaury@YAHOO.CO.UK>
Subject:      Re: How to speed up a SAS process?
In-Reply-To:  <OFF8DBFCC3.9E1D3F0E-ON88256D4B.005E9FE4@rtp.epa.gov>
Content-Type: text/plain; charset=iso-8859-1

totally forgot about that -- on our UNIX box (E6500)
we tried installing 64 bit SyncSort as the 'HOST' sort
procedure for SAS --  we benchmarked before and after
and SyncSort actually looked sluggish.

with that said, it's still a great tool for stand
along sorting on flat file or something...




 --- "David L. Cassell"
<cassell.david@EPAMAIL.EPA.GOV> wrote: > Sheila J
Gross <sheilaandhercats@EROLS.COM> replied:
> > My local SUG just had a presentation by the people
> from Syncsort, an
> add-in
> > which is claimed to be anywhere up to 90% faster
> than the internal
> sort in
> > SAS.  I'm sure they have a web site, I just don't
> have the URL handy.
>
> Just as an aside, SyncSort *can* make a huge
> difference in sorting
> speed, on Big Iron.  Paul Dorfman has written about
> it in this forum,
> so anyone can go look up his posts on the subject in
> the SAS-L archives.
>
> BUT.. SyncSort is probably not the solution on unix
> boxes or win32
> boxes.  The fine-tuning of I/O that makes SyncSort
> so remarkably
> effective on IBM mainframes doesn't seem to be there
> yet for other
> systems.  On unix boxes (not all unices are
> supported), there is
> some improvement in sort speed, but not all that
> much.  And rumors
> have it that the speed-up from multi-processing in
> SAS 9 PROC SORT
> gives it an advantage over SyncSort on win32
> systems.
>
> Anyway, as "SAS User" has pointed out, sorting the
> data set may be
> the wrong thing to do anyway...
>
> HTH,
> David
> --
> David Cassell, CSC
> Cassell.David@epa.gov
> Senior computing specialist
> mathematical statistician

__________________________________________________
Yahoo! Plus - For a better Internet experience
http://uk.promotions.yahoo.com/yplus/yoffer.html