Date:         Thu, 12 Jun 1997 02:19:45 -0400
Reply-To:     Joseph Laub <Bownz@WORLDNET.ATT.NET>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Joseph Laub <Bownz@WORLDNET.ATT.NET>
Organization: AT&T WorldNet Services
Subject:      another newbish question--will this work??????
Content-Type: text/plain; charset=us-ascii

O.K. -->and thanx to all who answered my last question :)
 
I need to run means of different characteristics for schools in a data
set ie the average grade in english in school for #'s
1 2 3 4 5 6 7 ............39000
 I need to get a  mean for all the cases in each seperate school
and put it in a variable for each case in that school:
 
schid  N  score    meanscore
11     1   50       66.6
24     1   75       86
11     1   85       66.6
24     1   95       86
11     1   65       66.6
 
will the by function do this or is there some other way to aggregate
stuff?
 
libname gumby '/path';
data orig;
set gumby.whatever;
 
proc means mean; out=grade mean=mgrade
(drop  _type_ _freq_;
by school id;
run;
 
 data gumby.new;
set orig;
set grade;
 
--
If you think you have unlocked a great "truth", keep in mind that the
universe is a big expanding ballon and our galaxy is a dust particle
along for the ride   >: o