topic Re: mean across variables in SAS Procedures

mean across variables

podarum — Thu, 19 Apr 2012 20:24:52 GMT

Hi, Is there a way SAS allows to do a mean across varaibles (and use a BY statement).

Here's what I mean:

HAVE:

Prod Price1 Price2 Price3 Price4

A 2 4 7 6
B 3 . 5 3

C . 5 . .

D . . . .

WANT: If I want the MEAN of the last 3 Prices & last 4 Prices

Prod Month3_Prices Month4_Prices

A 5.6 4.7
B 4 3.6

C 5 5

D . .

I tried different variations of Proc MEAN, couldn't get it, but I'm sure there is a simple way.

Thanks

Re: mean across variables

podarum — Thu, 19 Apr 2012 20:29:50 GMT

I think I got it.. using:

avg=Mean(of x y z);

Re: mean across variables

Reeza — Thu, 19 Apr 2012 20:39:29 GMT

Yes, except you can do mean(of price1--price3) and mean (of price1--price4) as well as mean(price1, price2, price3) and mean(price1, price2, price3, price4)

Re: mean across variables

Astounding — Thu, 19 Apr 2012 20:52:46 GMT

Well, it may not be everyone's idea of fun, but here's a program you can play around with ... "just for fun".

data _null_;

p1=1;

p3=3;

p2=4;

of=20;

m1 = mean(of p1--p3);

m2 = mean(of p1-p3);

m3 = mean(of p1 p2 p3);

m4 = mean(of p1,p2,p3);

m5 = mean(of,p1,p2,p3);

put m1= m2= m3= m4= m5=;

run;