Date:         Thu, 10 Apr 2008 22:22:23 -0400
Reply-To:     Joe Whitehurst <joewhitehurst@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Joe Whitehurst <joewhitehurst@GMAIL.COM>
Subject:      Re: proc sort performance
Comments: To: Kelvin Yuen <cyuen3@hotmail.com>
In-Reply-To:  <200804101404.m3AAlFa3018959@malibu.cc.uga.edu>
Content-Type: text/plain; charset=ISO-8859-1

I think you should ask yourself why SAS created a tagsort option.  I think
the answer you seek will be found in discovering why SAS created the tagsort
option.  Also, I would read all the documentation available for the tagsort
option.

On Thu, Apr 10, 2008 at 10:04 AM, Kelvin Yuen <cyuen3@hotmail.com> wrote:

> Does anyone have a idea of whether tagsort option in proc sort can
> practically improve the performance by reducing the number of IO and the
> amount of data written to the disks?  According to sas online doc, proc
> sort with tagsort option will load and sort the key fields only and then
> get the corresponding row into the final table.  The doc only mentions
> that proc sort with this option can be effective to require less space for
> sort, but does not suggest that the performance can be enhanced because of
> fewer IO operations.
>