|
Jack's yanking our chain :-) Either deliberately or not...
Looks like his 'test' libname is assigned to the SPD engine:
<http://support.sas.com/documentation/cdl/en/engspde/61887/HTML/default/viewer.htm#a002612026.htm>
It certainly doesn't work using 'work' under 9.2
And keeping with the thread: how about SAS offering to close a View Table window when I try to overwrite the data set by running more code, instead of just complaining it's already in use?
Cheers
On 2011-01-09, at 06:47, Kirby, Ted wrote:
> Is that a SAS 9.2 enhancement? When I try that code on 9.1.3, I get the
> usual error SAS stopped processing because the dataset was not sorted by
> the BY variable.
>
> (I tried to navigate through the 9.2 "What's New" online documentation
> to see if it was a new feature, but, as pointed out in other posts in
> this thread, found the 9.2 documentation a pain to navigate and could
> not find anything.)
>
> Ted Kirby,
> Consultant,
> The Lewin Group, Inc.
> 3130 Fairview Park, Suite 800
> Falls Church, VA 22042
> Phone: (703)269-5507
> Fax: (703)269-5501
> e-mail: ted.kirby@lewin.com
>
> -----Original Message-----
> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
> Jack Hamilton
> Sent: Saturday, January 08, 2011 1:27 AM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: Re: Frustration With SAS - My Vote for most poorly implemented
> Programming Language "Feature"
>
> On Jan 6, 2011, at 1:06 PM, Morley Herbert wrote:
>
>> I find it very annoying when many PROC's will not run because the data
> is not sorted. The log message even tells you the problem and which by
> variables need to be sorted. Why can it not sort the data set and then
> run the PROC?
>>
>> Morley Herbert
>
>
> You mean like this?
>
> =====
> 29 proc sort data=sashelp.class out=test.class;
> 30 by sex;
> 31 run;
>
> NOTE: There were 19 observations read from the data set SASHELP.CLASS.
> NOTE: SAS sort was used.
> NOTE: The data set TEST.CLASS has 19 observations and 5 variables.
> NOTE: PROCEDURE SORT used (Total process time):
> real time 0.04 seconds
> cpu time 0.01 seconds
>
>
> 32
> 33 proc print data=test.class;
> 34 by age;
> 35 run;
>
> NOTE: BY ordering was produced by performing an automatic sort on table
> TEST.class
> NOTE: There were 19 observations read from the data set TEST.CLASS.
> NOTE: PROCEDURE PRINT used (Total process time):
> real time 0.06 seconds
> cpu time 0.04 seconds
|
