Calculating the average based on different columns for different rows

Kpatel306 — Mon, 25 Nov 2013 17:48:05 GMT

Hi,

Anyone one can help me how can I calculated the average based on different columns for different rows:

e.g:

I want to calculate the field "Average" based on defined column name in "SAvg" to "EAvg":

in first row I want to calculate the average for row M5 to M10 (i.e. 85,589), in second row M5 to M9 (i.e.154,669), and so forth.

Thanks,

Re: Calculating the average based on different columns for different rows

PaigeMiller — Mon, 25 Nov 2013 17:52:36 GMT

I think you could do this via data step ARRAY statements.

UNtested code

data want;

set have;

array m m1-m10;

start=substr(savg,2)+0;

endd=substr(eavg,2)+0;

sum=0;

do i=start to endd;

sum=sum+m(i);

end;

avg=sum/(endd-start+1);

drop i sum start endd;

run;

Kpatel306 — Tue, 26 Nov 2013 14:31:11 GMT

Thanks Paige

its working

Thanks a lot