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
Content-Type: text/plain; charset=ISO-8859-1
Nathan, does running your query take much longer when you use order by?
On Fri, Mar 21, 2008 at 11:20 AM, Nathan Temple <Nathan.Temple@kp.org>
> 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.