topic Re: by group processing in New SAS User

by group processing

timmy555 — Fri, 06 Dec 2019 04:20:56 GMT

I am using by group processing and trying to find the average of a variable I am doing the processing on. So if it was points earned for 5 games with the points being 5,6,7,8,9 How can I find average of these using by group processing?

Re: by group processing

PeterClemmensen — Fri, 06 Dec 2019 06:50:45 GMT

@timmy555 please be more specific than this. Can you show us some sample data? Do you have some code that you have tried already?

Re: by group processing

ballardw — Fri, 06 Dec 2019 15:57:31 GMT

BY group processing means that you have one or more variables used to define the group. When you say "points in a game" then the likely BY variable would be a TEAM identification. So here is a possible example:

data example;
   input team $  score;
datalines;
A 15
B 26
A 3
B 18
C 3
C 6
C 27
;
proc sort data=example;
  by team;
run;

proc means data=example mean;
   by team;
   var score;
run;

Please note the data step as way of documenting the data and providing something that you can run to create a data set that be used.

BY groups also usually require sorting by the group variables before any analysis.