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
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;
Or with a format :
proc sql;
select mean(count) format=8.2 into :mean_count
from have;
quit;
PG
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.