Displaying side-by-side subgroups using gchart and vbar

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

Displaying side-by-side subgroups using gchart and vbar

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.


Accepted Solutions
Solution
‎07-25-2013 04:17 PM
Super User
Posts: 11,343

Re: Displaying side-by-side subgroups using gchart and vbar

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


All Replies
Solution
‎07-25-2013 04:17 PM
Super User
Posts: 11,343

Re: Displaying side-by-side subgroups using gchart and vbar

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.

New Contributor
Posts: 3

Re: Displaying side-by-side subgroups using gchart and vbar

It worked, thank you for the help.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

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