Dear SAS-L-ers,

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 > > 51 > 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 difference?

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" E-mail: MichaelRaithel@westat.com

Author: Tuning SAS Applications in the MVS Environment

Author: Tuning SAS Applications in the OS/390 and z/OS Environments, Second Edition http://www.sas.com/apps/pubscat/bookdetails.jsp?catid=1&pc=58172

Author: The Complete Guide to SAS Indexes

http://www.sas.com/apps/pubscat/bookdetails.jsp?catid=1&pc=60409

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Experience is not what happens to a man; it is what a man does with what happens to him. - Aldous Huxley +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++