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

Reply
Frequent Contributor
Posts: 134

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

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

Super Contributor
Posts: 1,636

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

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;

Respected Advisor
Posts: 4,920

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

Or with a format :

proc sql;

select mean(count) format=8.2 into :mean_count

from have;

quit;

PG

PG
Ask a Question
Discussion stats
  • 2 replies
  • 207 views
  • 0 likes
  • 3 in conversation