Date: Tue, 20 Nov 2007 19:08:21 +1300
Reply-To: Robin Templer <templerr@CLEAR.NET.NZ>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Robin Templer <templerr@CLEAR.NET.NZ>
Subject: Re: any way to sort large table faster than proc sort?
In-Reply-To: <112020070512.23911.47426CB500038A4E00005D6722193122529B0A02D2089B9A019C04040A0DBF0A0401089C0E9C@att.net>
Content-type: text/plain; charset=us-ascii
Not quite correct -
I have used SyncSort on Windows and it is definitely more efficient when you
get to larger datasets - but the performance gain or sweet spot is affected
by your hardware, dataset structure etc. From memory we found that Syncsort
was better when we hit 2M rows or more - bit it was quite a time ago - SAS
has improved as well - so it does come down to horses for courses. If you
are using SAS 8.2 - I remember there was a hot fix to support SYncSort under
Windows, Syncsort is supported out of the box for 9.1.3
I cannot remember how much syncsort for windows cost - I think it was in the
region of $3,000 - but do not hold me to that.
Check out http://www.syncsort.com/products/ss/ss/home.htm
Cheers
Robin
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Paul
Dorfman
Sent: Tuesday, 20 November 2007 6:12 p.m.
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: any way to sort large table faster than proc sort?
Yes, but for mainframe only, and if the special product called Proc Syncsort
for MVS (OS/390, z/OS) is licensed.
-------------- Original message ----------------------
From: "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
>
> On Mon, 19 Nov 2007 11:00:25 -0500, Wensui Liu <liuwensui@GMAIL.COM>
wrote:
>
> >the way i am doing is
> >proc sort data = xxx sortsize = max;.....
> >
> >but i am not very happy with the performance with large data. is there
> >a way to do a faster sort than proc sort?
> >
> >appreciate your insight!
>
> People here have often recommended Syncsort.
