topic Re: How to take an average from a table and asign it to a variable in SAS Programming

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

tparvaiz — Sat, 07 Jul 2012 06:34:03 GMT

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

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

Linlin — Sat, 07 Jul 2012 10:39:09 GMT

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;

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

PGStats — Sat, 07 Jul 2012 12:27:35 GMT

Or with a format :

proc sql;

select mean(count) format=8.2 into :mean_count

from have;

quit;