|Date: ||Mon, 9 Jun 2008 11:17:14 -0400|
|Reply-To: ||Michael Raithel <michaelraithel@WESTAT.COM>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||Michael Raithel <michaelraithel@WESTAT.COM>|
|Subject: ||Re: Bizarre sort problem|
|Content-Type: ||text/plain; charset="us-ascii"|
Sekhar posted the following:
> I am constantly getting the same error message in SAS when
> this piece of code ran successfully last week. Is this
> something to do with system?
> Here is the log.
> 50 proc sort data=prof;by var1;run;
> NOTE: Input data set is already sorted, no sorting done.
> NOTE: PROCEDURE SORT used (Total process time):
> real time 0.01 seconds
> cpu time 0.00 seconds
> 52 data calls;
> 53 merge calls(in=in1) prof(in=in2);
> 54 by var1;
> 55 if in1;
> 56 run;
> ERROR: BY variables are not properly sorted on data set
> WORK.PROF. On further analysis I found som eunexplained "0"
> in the prof dataset. I have no idea where they are coming from?
Sekhar, I hate it when SAS data sets decay over a weekend:-) Hey, how
about adding the FORCE option to your PROC SORT and seeing if it makes a
proc sort data=prof FORCE;by var1;run;
Check it out and let the List know if it was necessary to use force!
Michael A. Raithel
"The man who wrote the book on performance"
Author: Tuning SAS Applications in the MVS Environment
Author: Tuning SAS Applications in the OS/390 and z/OS Environments,
Author: The Complete Guide to SAS Indexes
Experience is not what happens to a man; it is what a man does
with what happens to him. - Aldous Huxley