Date: Fri, 20 Jun 2003 19:53:39 +0100
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?
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
> > 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
> Anyway, as "SAS User" has pointed out, sorting the
> data set may be
> the wrong thing to do anyway...
> David Cassell, CSC
> Senior computing specialist
> mathematical statistician
Yahoo! Plus - For a better Internet experience