Date:         Mon, 9 Jun 2008 09:37:50 -0700
Reply-To:     MichelleZ <michelle_zunnurain@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         MichelleZ <michelle_zunnurain@HOTMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: Bizarre sort problem
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

On Jun 9, 9:48 am, Sekhar <ckalise...@gmail.com> wrote:
> 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,

Try looking at the first 10 or 100 records of WORK.PROF.  You might
have invalid values in the BY variable.  Try doing a PROC FREQ of the
BY variable and see what you have.

Michelle Z.