topic Re: Number and Percentage by group in PROC REPORT hbar? in SAS Procedures

Number and Percentage by group in PROC REPORT hbar?

braam — Sat, 22 Feb 2020 22:18:53 GMT

I have two related questions.

1. Can I report the number of observations by "MAKE" and "TYPE" in the outcome that the below code generates? There are 7 observations for Acura. It seems that a majority of 7 Acuras are Sedan, but I cannot see the exact number.

2. Can there be percentages, instead of numbers, presented? It seems to me that there are 1 SUV, 5 Sedan, and 1 Sports in the first car maker group (i.e., Acura). I would like to report the percentages, if possible (i.e., 14%, 72% and 14%).

Thanks!


ods graphics/ height= 8in;
proc sgplot data= sashelp.cars;
	hbar make / group= type datalabel ;
	yaxis fitpolicy= none; run;

Re: Number and Percentage by group in PROC REPORT hbar?

Ksharp — Sun, 23 Feb 2020 04:10:32 GMT

proc sgplot data= sashelp.cars;
where make in ('Audi' 'BMW');
	hbar make / group= type datalabel stat=freq  groupdisplay=cluster;
	yaxis fitpolicy= none; run;
	
	proc sgplot data= sashelp.cars;
where make in ('Audi' 'BMW');
	hbar make / group= type datalabel stat=pct  groupdisplay=cluster;
	yaxis fitpolicy= none; run;

Re: Number and Percentage by group in PROC REPORT hbar?

ed_sas_member — Sun, 23 Feb 2020 08:43:34 GMT

Hi @braam

You can also display both frequency and percentage using PROC GCHART:

axis1 label=none;
proc gchart data= sashelp.cars;
	where make in ('Audi' 'BMW');
	hbar type /group=make subgroup=type freq percent space=0 raxis=axis1;
run;

Re: Number and Percentage by group in PROC REPORT hbar?

braam — Sun, 23 Feb 2020 11:13:32 GMT

@ed_sas_member

@Ksharp

Thanks for your answers! But isn't there a way to solve this with the style of graph being unchanged?

I mean, one single bar for one car maker where there are multiple types of cars.

Re: Number and Percentage by group in PROC REPORT hbar?

ed_sas_member — Sun, 23 Feb 2020 11:26:10 GMT

Hi @braam

using SGPLOT, you can just change the option 'data label' to 'seglabel' as follows:

proc sgplot data= sashelp.cars;
	where make in ('Audi' 'BMW');
	hbar make / group= type seglabel stat=percent;
	yaxis fitpolicy= none;
run;

Best,

Re: Number and Percentage by group in PROC REPORT hbar?

ed_sas_member — Sun, 23 Feb 2020 14:38:26 GMT

Hi @braam

Here is another approach, using a file for annotation:

proc freq data=sashelp.cars noprint order=freq;
	table type / out=cars_freq;
	by make;
run;

/* file for annotation */
data bar_anno;
	set cars_freq;
	function='label';
	retain xsys '2' ysys '2' color 'black' when 'a';
	midpoint=make;
	subgroup=type;
	position='+';
	text=strip(put(percent/100, percent8.0));
run;

/* Graph */
axis1 label=(angle=90 "Make");
axis2 label=none;

proc gchart data=sashelp.cars;
	hbar make / subgroup=type nostats space=0 annotate=bar_anno maxis=axis1 raxis=axis2;
run;