topic Re: How to create a nice graph with age group and gender in SAS Programming

How to create a nice graph with age group and gender

Mscarboncopy — Thu, 29 Aug 2024 14:39:12 GMT

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!!!

Re: How to create a nice graph with age group and gender

svh — Thu, 29 Aug 2024 14:44:58 GMT

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.

Re: How to create a nice graph with age group and gender

PaigeMiller — Thu, 29 Aug 2024 15:36:20 GMT

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.

Re: How to create a nice graph with age group and gender

Mscarboncopy — Thu, 29 Aug 2024 16:23:46 GMT

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.

Re: How to create a nice graph with age group and gender

ballardw — Thu, 29 Aug 2024 16:26:39 GMT

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.

Re: How to create a nice graph with age group and gender

Mscarboncopy — Thu, 29 Aug 2024 16:37:31 GMT

Thank you!

Re: How to create a nice graph with age group and gender

Mscarboncopy — Thu, 29 Aug 2024 17:54:34 GMT

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

Thank you!