How to create a nice graph with age group and gender

[Mscarboncopy]

Hi

I am trying to create a simple graph with age group and gender but somehow it is not working.

This is my code and the graph. I do not understand why it is spliting my age groups

Proc format;

Value agef

65-69 = 'Age 65-69'

70-79 = 'Age 70-79'

81-84 = 'Age 81-84'

;

run;

Data newfinal;

Set FINAL;

Format age agef. Region reg.;

run;

axis1 label=('Number of People')

 minor=(number=1)

 offset=(0,0);

 /* Define legend characteristics */

legend1 label=none value=('Men' 'Women');

 /* Chart the values of AGE */

proc gchart data=newfinal;

hbar age / subgroup=gender

 legend=legend1

 autoref

 clipref

 coutline=black

 raxis=axis1;

run;

 /* Add order= to response axis */

 axis1 order=(0 to 24 by 2)

 label=('Number of People')

 minor=(number=1)

 offset=(0,0);

 /* Modify midpoint axis label*/

 axis2 label=('Age' j=r 'Group')

 /* Create chart */;

hbar3d age /

 freq

 freqlabel='Total in Group'

 subgroup=gender

 autoref

 maxis=axis2

 raxis=axis1

 legend=legend1

 coutline=black

       width=3.5

 space=2;

run;

quit;

all numeric but I formatted the age to be able to show in the graph - might be what is causing the issue, the original data is numeric with the actual age of each participant.

ID	Age	gender
1	Age 70-79	2
2	Age 65-69	1
3	Age 65-69	2
4	Age 81-84	1
5	Age 65-69	1
6	Age 65-69	2
7	Age 81-84	2
8	Age 81-84	2
9	Age 81-84	2
10	Age 65-69	2
11	Age 65-69	2
12	Age 70-79	1
13	Age 65-69	2
14	Age 65-69	2
15	Age 70-79	1
16	Age 65-69	2
17	Age 70-79	2
18	Age 65-69	2
19	Age 70-79	2
20	Age 65-69	1
21	Age 81-84	2
22	Age 65-69	2
23	Age 70-79	2
24	Age 65-69	2

Thank you!!!

[svh]

I think you have observations with an age of 80, which is not covered in your format statement. Thus, the unformattted value is being displayed for that age. 

[PaigeMiller]

PROC GCHART picks its own levels for the Y-axis, and I'm guessing it has picked levels that are 5 units apart. If you want your own levels to be used, as you did in AXIS1 (for the x-axis), use the ORDER option for AXIS2.

[Mscarboncopy]

I figured it out. It was my variable formatting.

Now what I can't figure out is how to remove these tick mark on the Age axis. I do not need the 1.5 or 2.5. This is being generated in the code I shared and I cannot figure out how to change it. Thank you again.

[ballardw · Accepted solution]

Try

axis2 label=('Age' j=r 'Group')
         order=(1 2 3)
;

That 1.5 and 2.5 tell me that your data is not actually using the age format that you displayed which would be using values more like 65 70 and 81. 

[Mscarboncopy]

Thank you!

[Mscarboncopy]

One last thing. How do I make all of these labels a little bigger on each of the axis?

Thank you!