How to take an average from a table and asign it to a variable

[tparvaiz]

Hi,

I need a macro (or some sort of a code) that will take an average from a table and asign it to a variable... I want to use this variable to drive a dial chart...

my table looks like this

day     count

Day_1    20

Day_2    30

Day_3   50

so the average(count) will be 33.34

Thanks in advance

[Linlin]

data have;

input day $    count;

cards;

Day_1    20

Day_2    30

Day_3   50

;

proc sql;

select round(mean(count),.01) into :mean_count

   from have;

quit;

%put &mean_count;

[PGStats]

Or with a format :

proc sql;

select mean(count) format=8.2 into :mean_count

from have;

quit;

PG