topic Re: Putting Percentages in Tile Charts in Graphics Programming

Putting Percentages in Tile Charts

dbcrow — Wed, 19 Dec 2018 20:49:54 GMT

Hi, SAS Users!

I'm trying to create a tile chart in which the tiles contain both the labels of the group they represent and the percentage that that group is of the total population. Here's some code:


*Figure 4:  Tile Chart w/ Relative Sizes of Native American Groups;
data naan_tilechart;
	input class pop total;
cards;
1 164038 1087183
2 486212 1087183
3 228101 1087183
4 208832 1087183
;
run;



data naan_tilechart;
	set naan_tilechart;
	per = pop/total;
	format per percent9.1;
run;

proc format;
	label class = "Race/Ethnicity Category"
		pop = "Count";
	value class
		1="1-Race, Non-Hisp"
		2="1-Race, Hisp"
		3=">1-Race, Non-Hisp"
		4=">1-Race, Hisp"
		;
run;


title1 "Native American/Alaskan Natives";
title2 "By Race and Hispanic Origin";
proc gtile data=naan_tilechart;
 	TILE pop
 	tileby=(class);
	format class class.;
run;

And here's the resulting tile chart:

What I would like to do is (1) insert the percentages for each tile and (2) eliminate the--is it an axis label?--"class" above the upper left-hand corner of the chart.

Thanks,

David

Re: Putting Percentages in Tile Charts

SuryaKiran — Wed, 19 Dec 2018 21:22:13 GMT

Hello,

Create a new variable concatenating percent and class.

data naan_tilechart;
	set naan_tilechart;
	per = pop/total;
	format per percent9.1;
Class_new=cats(put(class,class.),'(',put(per,percent9.1),')');

run;

title1 "Native American/Alaskan Natives";
title2 "By Race and Hispanic Origin";
proc gtile data=naan_tilechart;
 	TILE pop
 	tileby=(class_new);
	format class class.;
label class_new="09"x; /* This will blank the label name*/
run;

Re: Putting Percentages in Tile Charts

dbcrow — Wed, 19 Dec 2018 22:32:13 GMT

Thanks, SuryaKiran-

Is there no data label option in PROC GTILE?

Also, how would I get the percentage on a separate line? Your solution is great, but it looks a little cluttered to me.

Thanks for the patience.

Best,

David

Re: Putting Percentages in Tile Charts

dbcrow — Wed, 19 Dec 2018 23:09:33 GMT

And one other question (sorry to be such a bother): how can I export the graph as an image with the title?

Thanks,

David