topic Re: Proc Gchart - format frequency midpoint values in Graphics Programming

Proc Gchart - format frequency midpoint values

ErikLund_Jensen — Mon, 17 Jun 2019 17:23:47 GMT

Hi community.

I can't find a way to format frequency values in proc gchart. I made the following example with automatic midpoint values 10000, 20000 etc, and I want the values formatted with commax12.0, so the values are shown as 10.000, 20.000 etc. Any help would be much appreciated.

* Make some test data;
data have (drop=i);;
	do afd = 'Adf1','Afd2','Afd3','Afd4';
		do j = 1 to ranuni(3)*50000;
			output;
		end;
	end;
run;

* Plot afd / frequency;
proc gchart data=have;
	hbar afd / type=freq;
run;
quit;

Re: Proc Gchart - format frequency midpoint values

DanH_sas — Mon, 17 Jun 2019 17:46:29 GMT

Try this instead:

proc sgplot data=have;
 xaxis valuesformat=commax12.;
 hbar afd;
 yaxistable afd / stat=freq;
 yaxistable afd / stat=percent;
run;

Hope this helps!

Dan

Re: Proc Gchart - format frequency midpoint values

FreelanceReinh — Tue, 18 Jun 2019 09:02:17 GMT

Hi @ErikLund_Jensen,

You can use the STATFMT= option of the HBAR statement:

hbar afd / type=freq statfmt=commax12.;

It applies to the frequency table as well, except for the percentages, though.

Re: Proc Gchart - format frequency midpoint values

ErikLund_Jensen — Tue, 18 Jun 2019 13:37:32 GMT

Thanks to @DanH_sas and @FreelanceReinh for input.

Proc sgplot seems a good alternative to gchart, but it would be rather complicated to change to a new procedure with a different syntax in several reports, where most of the formatting and layout control is in macro variables.

So I am very happy that it could be done with a minor change to Proc gchart.