Date:         Wed, 29 May 1996 14:39:11 -0400
Reply-To:     Bob Naughton <bnaughtn@IX.NETCOM.COM>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Bob Naughton <bnaughtn@IX.NETCOM.COM>
Organization: Netcom
Subject:      Re: Strange Error, please help
Comments: cc: carscadd@pps.duke.edu

Rob Carscadden wrote:
>
> The following error is very confusing to me, any hints. I've checked and
> checked, but I don't see a spelling error. Am I just blind or what? I
> sort the data by this makeuni variable and the I want to output the first
> observation of each. Am I just clueless, dumb, or is my SAS acting up.
> If there is bonehead mistake, please feel free to mock me.
>
> Thanks in Advance,
>
> Rob
>
> ***************************************************
>
> 1806  proc sort data = sims.admerge1; by makeuni;
> 1807  run;
>
> NOTE: Input data set is already sorted, no sorting done.
> NOTE: PROCEDURE SORT used:
>       real time           0.476 seconds
>       cpu time            0.037 seconds
>
> 1808
> 1809  data temp;
> 1810  set sims.admerge1;
> 1811  by makeuni;
> 1812  if first.makeuni then output;
>
> ERROR: BY variables are not properly sorted on data set SIMS.ADMERGE1.
 
For some reason the sorted by flag is set in sims.admerge1 and the
dataset really isn't sorted.  You can force SAS to sort this dataset by
using the FORCE option in the sort.
 
Ex.  Proc sort data=sims.admerge1  force ; by makeuni; run ;
 
 
-------------------------------------------------------------------
Bob Naughton                                 bnaughtn@ix.netcom.com
-------------------------------------------------------------------