BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
shaknon
Calcite | Level 5

Hello,

I am trying to graph data similar to the following data set "Employees":

AgeYear
192000
252000
182001
452000
......
382001

I used gchart to graph the data as follows:

proc gchart data = Employees;

     vbar Age / MIDPOINTS= 0 to 100 by 10 subgroup = Year ;

     run;

quit;

I want the chart to display the midpoints on the x-axis (10 age categories) and the frequency of each age category on the y-axis for each year (i.e. 2000 and 2001). I want the year subgroups to be displayed side by side for each age category. However, with this code I get the 2001 bars stacked on top of the 2000 bars for each age category. I looked online and I read many examples such as this example, but I am not sure why my code is not displaying the subgroup bars side by side as illustrated in the previous example.

Any help would be appreciated. Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
ballardw
Super User

I would try

vbar year/ group age;

format age chartage.;

Where chartage is a custom format that looks something like

Proc format;

value chartage

0-5 = ' 0 -5'

6-15 = ' 6-15'

16-25= '16-25'

(etc);

Notice that the example doesn't use MIDPOINTS and SUBGROUP is within GROUP.

View solution in original post

2 REPLIES 2
ballardw
Super User

I would try

vbar year/ group age;

format age chartage.;

Where chartage is a custom format that looks something like

Proc format;

value chartage

0-5 = ' 0 -5'

6-15 = ' 6-15'

16-25= '16-25'

(etc);

Notice that the example doesn't use MIDPOINTS and SUBGROUP is within GROUP.

shaknon
Calcite | Level 5

It worked, thank you for the help.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1609 views
  • 0 likes
  • 2 in conversation