Date:         Sat, 8 Jan 2011 09:52:16 -0800
Reply-To:     Jack Hamilton <jfh@STANFORDALUMNI.ORG>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jack Hamilton <jfh@STANFORDALUMNI.ORG>
Subject:      Re: Automatic Sorting
In-Reply-To:  <B61269F6-B6F0-468E-AA17-410EF0711244@howles.com>
Content-Type: text/plain; charset=us-ascii

The last paragraph of my message doesn't seem to have gone out.  I remember writing it.  The mysteries of computers...

Anyway, you get the autosort behavior if you use the SPDE engine in base SAS.  It's available in 9.1; I don't remember if it was in v8.

I haven't read anything that comprehensively compares the advantages of the base engine vs the SPDE engine under various circumstances.  I have seen various articles and papers on individual comparisons, but nothing with it all in one place.  Perhaps I need to look harder, or perhaps we have a new paper topic for Michael Raithel.

In the example, you would use

  libname test spde 'c:\temp';



On Jan 8, 2011, at 5:41 AM, someone wrote in private email:

> I get (using 9.2 1M0)
> 
> ERROR: Data set TEST.CLASS is not sorted in ascending sequence. The current BY group has Age =
>        14 and the next BY group has Age = 12.
> 
> 
> Is there some system option responsible for the behavior difference?
> 
> libname test 'c:\temp' ;
> 
> proc sort data=sashelp.class out=test.class;
>    by sex;
> run;
> 
> proc print data=test.class;
>    by age;
> run;
> 
>