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
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;
> proc print data=test.class;
> by age;