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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.