Showing average on a histogram

[mlogan]

Hi All,

Following code gives me histogram showing total count in Y axis. Can someone tell me how do I get average instead of total count? Thanks.

proc sgplot data=have;

vbar Start_Date / stat=freq

  groupdisplay=cluster group=event;

  keylegend / location=inside position=topright;

  where event in ('volley ball','soccer') and Start_date between "01Mar2014"d and "30Apr2014"d;

  format Start_Date weekdate10.;

run;

[Reeza]

A histogram by definition shows frequency.

Change the STAT= in the VBAR statement - to MEAN instead of FREQ to plot a bar chart with the mean value instead of counts.

[mlogan]

Hi Reeza,

Changed that to mean, still not working. can you please tell why.

proc sgplot data=have;

vbar Start_Date / stat=mean

  groupdisplay=cluster group=event;

  keylegend / location=inside position=topright;

  where event in ('volley ball','soccer') and Start_date between "01Mar2014"d and "30Apr2014"d;

  format Start_Date weekdate10.;

run;

[Reeza]

Can you post some sample data and explain what 'still not working' means?

[mlogan]

Hi Reeza,

I have Feb and Mar data of both 2014 and 2015.

Thanks,

Date	Outcome
01-Mar-2014	Loss
27-Feb-2015	Profit
27-Feb-2014	Loss
24-Feb-2014	Profit
01-Mar-2015	Loss
26-Feb-2015	Loss
01-Mar-2015	Loss
01-Mar-2015	Loss
01-Mar-2015	Loss
01-Mar-2015	Profit
01-Mar-2014	Profit
01-Mar-2014	Profit
01-Mar-2014	Profit
25-Feb-2014	Profit

[Reeza]

What are the numbers you're trying to take the average of?

[mlogan]

HI Reeza,

I created a frequency table from the above table call Table_freq. It has the no of outcome (both loss and profit in one column though) on each date. I tried to run that report from that table with the following code.

Thanks for your help.

proc sgplot data=Apple.Table_freq;

vbar Date / stat=freq

  groupdisplay=cluster group=Outcome;

  keylegend / location=inside position=topright;

  format Start_Date weekdate10.;

run;