Date:         Fri, 21 Mar 2008 21:13:41 -0500
Reply-To:     sas 9 bi user <sas9bi@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         sas 9 bi user <sas9bi@GMAIL.COM>
Subject:      Re: proc sql different order on successive runs
In-Reply-To:  <OFAFD3E651.3B9B35BA-ON88257413.005984D1-88257413.0059A60C@KP.ORG>
Content-Type: text/plain; charset=ISO-8859-1

Nathan, does running your query take much longer when you use order by?
Thanks, Andy

On Fri, Mar 21, 2008 at 11:20 AM, Nathan Temple <Nathan.Temple@kp.org>
wrote:

> When I run proc sql twice in a row, I sometimes see the results ordered
> differently on the second run than on the first run.  The input files are
> the same (permanent SAS datasets on IBM mainframe) in each run.  The
> output files from each run are the same as well (as determined by proc
> compare), except for the order of the observations.  Can anyone confirm
> that this happens ?
>
> (I run proc sql without the "order by" clause.)
>
> NOTICE TO RECIPIENT:  If you are not the intended recipient of this
> e-mail, you are prohibited from sharing, copying, or otherwise using or
> disclosing its contents.  If you have received this e-mail in error,
> please notify the sender immediately by reply e-mail and permanently
> delete this e-mail and any attachments without reading, forwarding or
> saving them.  Thank you.
>