Date:         Tue, 23 Jul 2002 14:59:48 -0400
Reply-To:     Sigurd Hermansen <HERMANS1@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Sigurd Hermansen <HERMANS1@WESTAT.COM>
Subject:      Re: Means vs summary (was: aggregate 8100+ variables)
Comments: To: "Deshon, Joe A" <jdesho01@SPRINTSPECTRUM.COM>
Content-Type: text/plain; charset="iso-8859-1"

My copy of the V6 Procedures Guide, 3rd Edition (1/1990), does not show a
noprint option for Summary and mentions specifically the difference in the
way Means responds to an omitted VAR statement. For all other details, it
refers the reader to Means. From that I would infer that Summary and Means
have, with these exceptions, virtually the same syntax in V6.

Sig
-----Original Message-----
From: Deshon, Joe A [mailto:jdesho01@SPRINTSPECTRUM.COM]
Sent: Tuesday, July 23, 2002 11:03 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Means vs summary (was: aggregate 8100+ variables)


All --

Wow, I didn't realize that proc means and proc summary treated the absence
of a var statement differently.  Now I wonder what other differences there
are between the two.  This is significant because we have some "means" fans
around here and some "summary" fans.  (I'm a summary fan.)

So far, I have found two significant differences:

  1.  Means prints a report by default that can be suppressed with
"noprint".  Summary does not.
  2.  In the absence of a var statement, means processes all the numeric
variables whereas summary processes none of them.

So, who can come up with any other differences?

  -- Joe

Joe DeShon
Manager, Systems and Infrastructure Group
CRM / Database Marketing Department
Sprint PCS
6130 Sprint Parkway
Mailstop: KSOPHJ0212-2A350
Overland Park  KS  66251
Work: (913) 762-6172
PCS: (816) 210-0950
Fax: (913) 762-0804
email: jdesho01@sprintspectrum.com



-----Original Message-----
From: Peter Crawford [mailto:peter.crawford@DB.COM]
Sent: Tuesday, July 23, 2002 7:07 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: aggregate 8100+ variables


this is one situation where proc means and
proc summary are *not* the same !
Like proc univariate, proc means assumes all
numeric vars should be processed when no
var statement is present.
Summary assumes none,

So the minimal tech solution can become

 proc means noprint/*not wanting results window filled by 8K vars */ ;
    output sum=;
 run;



Datum:         22.07.2002 21:10
An:            SAS-L@LISTSERV.UGA.EDU




Antwort an:    Doug Dame <dameda@SHANDS.UFL.EDU>

Betreff:       Re: aggregate 8100+ variables
Nachrichtentext:

The low tech approach would be to simply use

 proc summary ....
    var _NUMERIC_ ;
    output out=SUMMARY
   out= ;

Seems to work for me.

(Also, in the distant past I did some testing on several different platforms
(MVS w/o SyncSort, AIX, Winders), and have never found a proc sort before a
proc summary to enhance performance. So dump the proc sort, and change the
proc summary to an nway with a class statement. )

HTH

Douglas Dame
Shands HealthCare
Gainesville FL USA





--

Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte
Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail
irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und
vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte
Weitergabe dieser Mail ist nicht gestattet.

This e-mail may contain confidential and/or privileged information. If you
are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail. Any
unauthorized copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.