topic Re: proc means - vbar - display freq=0 in SAS Procedures

proc means - vbar - display freq=0

xxformat_com — Sun, 01 Sep 2019 18:07:33 GMT

Hi,

As fas as I could read in the SAS online doc, it is currently not possible to display zero frequencies in a bar char.

I could manage to add it using the values options of xaxis statement but the value 0 is not displayed with datalabel and the bar at value zero is also not displayed.

Are you aware of any other solution I could consider (format?, other option? vbarbasic?, vbarparm?)

data cnt;
gender='M'; freq=9; output;
gender='F'; freq=8; output;
gender='X'; freq=0; output;
run;

proc print data=cnt;
run;

ods graphics / width=15cm height=10cm noborder;

proc sgplot data=cnt noborder;
vbar gender / freq=freq missing displaybaseline=off datalabel;
xaxis values=('M' 'F' 'X')
display = (noline);
run;

ods graphics off;

Re: proc means - vbar - display freq=0

PeterClemmensen — Mon, 02 Sep 2019 07:05:44 GMT

Here is how I would do it. Example using SASHELP.CLASS data set

proc format;
	value $ sexfmt "F"="Female" 
				   "M"="Male" 
				   "X"="X";
run;

proc summary data=sashelp.class nway completetypes;
   class sex / preloadfmt order=formated missing;
   format sex $sexfmt.;
   output out=counts;
run;

proc sgplot data=counts;
	vbarparm category=sex response=_FREQ_ / nozerobars;
run;

Re: proc means - vbar - display freq=0

xxformat_com — Sun, 01 Sep 2019 21:05:30 GMT

Thank you 🙂

Re: proc means - vbar - display freq=0

PeterClemmensen — Mon, 02 Sep 2019 06:25:11 GMT

Anytime 🙂