Date: Sat, 8 Jan 2011 13:46:12 -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: Frustration With SAS - My Vote for most poorly implemented
Programming Language "Feature"
In-Reply-To: <CAC2BD03-9094-4660-BE8C-21462BEFEF05@gmail.com>
Content-Type: text/plain; charset=us-ascii
Yes, I corrected that in email sent about 2 hours before your message.
On Jan 8, 2011, at 12:24 PM, Tom Robinson wrote:
> 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
| 
