Date:         Tue, 3 Feb 2004 13:24:33 -0800
Reply-To:     Jeff Voeller <c-jeff.voeller@MCI.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jeff Voeller <c-jeff.voeller@MCI.COM>
Subject:      Re: SQL speed
Comments: To: Don Stanley <don_stanley@PARADISE.NET.NZ>
In-Reply-To:  <200402032105.i13L5hB10997@listserv.cc.uga.edu>
Content-type: text/plain; charset=us-ascii

SORTPGM= didn't show up for me under z/OS until I actually set the value.  I
wonder how many other options work that way?

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Don
Stanley
Sent: Tuesday, February 03, 2004 1:06 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: SQL speed


I thought it was controlled by a SAS option, but I don't see it when I do a

proc options group=sort; run ;

Neither do I see it under the Tools-->Options-->Sort pulldown.

Found under OS/390 help only -- SORTCUTP is the option I was thinking of and
most the one your mainframe admins were meaning. Perhaps only applicable to
OS/390 platform?

Don

On Tue, 3 Feb 2004 14:42:18 -0600, Toby Dunn <tdunn@OAKHILLTECH.COM> wrote:

>I remember my mainframe admins saying that on our system it takes
>sorting a certain number of obs before our system would use syncsort,
>otherwise it would just use sas's sort.  Wonder if the same is true
>weather or not im using a datastep or a sql statement.  Hmmmmmm....yet
>another thind on a
long
>list to ponder..
>
>Toby Dunn
...