Date: Sat, 8 Jan 2011 12:47:23 -0500
Reply-To: "Kirby, Ted" <ted.kirby@LEWIN.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Kirby, Ted" <ted.kirby@LEWIN.COM>
Subject: Re: Frustration With SAS - My Vote for most poorly implemented
Programming Language "Feature"
In-Reply-To: A<6EC349DC-2074-4D5D-9DE0-8511AF21CA16@alumni.stanford.org>
Content-Type: text/plain; charset="us-ascii"
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
=====
************* IMPORTANT - PLEASE READ ********************
This e-mail, including attachments, may include confidential and/or proprietary information,
and may be used only by the person or entity to which it is addressed. If the reader of this
e-mail is not the intended recipient or his or her authorized agent, the reader is hereby
notified that any dissemination, distribution or copying of this e-mail is prohibited. If you
have received this e-mail in error, please notify the sender by replying to this message
and delete this e-mail immediately.
