Hey all,
My labels are not placing correctly. I am using a sas example to make a population pyramid style graph with proc gchart.
The counts should either be inside the bar, or outside, not both. Also, 20,000 on the Female side is missing and I'm not sure why. I am attaching a photo and the data set for clarity.
Here is how I have modified the code to fit my data (I have only made small changes for variable names and scale):
/* Set the graphics environment */
goptions reset=all border cback=white htitle=12pt htext=10pt;
/* Convert the data values for one group to negative values to create the input data set, CONVERT.
CONVERT contains the same variables as POPPYRAMIDSEXAGESTATE; however, the values of COUNT for
the female drivers are made negative to force a zero reference line in the bar chart. */
data convert;
set poppyramidsexagestate;
if sex='FEMALE' then count=-count;
format count comma15.;
run;
/* Create a format for the values of COUNT. The POSVAL. format adds a comma and suppresses the
sign on the values so that negative values appear as positive values. */
proc format;
picture posval low-high='000,009';
run;
/* Create the Annotate data set, ANLABELS. ANLABELS adds the labels to the bars. Because data
values are used to place the labels, XSYS and YSYS use the absolute data coordinate system, 2.
A value of A for WHEN causes the labels to overlay the chart. */
data anlabels(drop=cdcage sex );
length text $ 8;
retain function 'label' when 'a' xsys ysys '2' hsys '3' size 2.5;
set convert;
midpoint=cdcage; subgroup=sex;
text=" " || left(put(count, posval.));
/* POSITION changes to place label outside of bar if bar is too small. */
if count ge -1000 and sex='F' then position='<';
else if sex='F' then position='>';
/* POSITION changes to place label outside of bar if bar is too small. */
if count le 1000 and sex='M' then position='>';
else if sex='M' then position='<';
output;
run;
/* Add a title to the graph */
title1 'Number of blah blah blah by Sex and Age Group, Blah 2014';
/* Modify the appearance of the axes. In the AXIS2 statement, the VALUE= option suppresses the third
tick mark so that the range for each group is zero to the maximum value. */
axis1 label=(justify=left 'Age') style=0;
axis2 label=none value=(tick=3 '') minor=none major=none
width=3 order=(-30000 to 30000 by 5000);
/* Create the bar chart */
proc gchart data=convert;
/* The FORMAT statement applies the POSVAL format to the values of count. */
format count posval.;
/* The NOTE statement places the labels "Female" and "Male" above the population tree. */
note font="Albany AMT/bold" move=(25pct,86pct) h=12pt 'Female'
move=(70pct,86pct) 'Male';
/* In the HBAR statement, SUBGROUP= names the variable that determines the groups, and ANNOTATE= includes the annotation defined in the ANLABELS data set. */
hbar cdcage / sumvar=count discrete nostat subgroup=sex
maxis=axis1 raxis=axis2 nolegend annotate=anlabels;
run;
quit;
Data set 'convert':
cdcage
SEX
count
1
FEMALE
-863
1
MALE
1089
2
FEMALE
-2219
2
MALE
3016
3
FEMALE
-2240
3
MALE
3355
4
FEMALE
-1425
4
MALE
3574
5
FEMALE
-4472
5
MALE
11730
6
FEMALE
-3740
6
MALE
11173
7
FEMALE
-3255
7
MALE
8609
8
FEMALE
-3962
8
MALE
8939
9
FEMALE
-5341
9
MALE
7891
10
FEMALE
-26304
10
MALE
15324
... View more
