topic Re: Gchart clustered bar chart in Graphics Programming

Gchart clustered bar chart

JaneS — Fri, 09 Apr 2021 18:14:39 GMT

I have a question how to create a clustered graph is SAS.

The data is the following:

Year	County	Statewide
2015	20.00%	50.00%
2016	40.00%	32.00%
2017	30.00%	12.00%
2018	70.00%	0.00%
2019	90.00%	80.00%
2020	100.00%	90.00%
2021	100.00%	100.00%

And the graph I am trying to create in SAS is the following:

Could you please help with the code for it? I was thinking to use proc gchart but then it looks like there should be two vbar arguments and I am not sure how to combine them.

Thank you!

Re: Gchart clustered bar chart

ballardw — Fri, 09 Apr 2021 19:04:37 GMT

@JaneS wrote:

I have a question how to create a clustered graph is SAS.

The data is the following:

Year County Statewide

2015 20.00% 50.00%

2016 40.00% 32.00%

2017 30.00% 12.00%

2018 70.00% 0.00%

2019 90.00% 80.00%

2020 100.00% 90.00%

2021 100.00% 100.00%

And the graph I am trying to create in SAS is the following:

Could you please help with the code for it? I was thinking to use proc gchart but then it looks like there should be two vbar arguments and I am not sure how to combine them.

Thank you!

To have reasonable control over the "clustering" you need to reshape the data a bit so that the same variable holds the county and statewide as values.

Here is an example:

data have;
   input Year	County:percent8.	Statewide:Percent8.;
datalines;
2015	20.00%	50.00%
2016	40.00%	32.00%
2017	30.00%	12.00%
2018	70.00%	0.00%
2019	90.00%	80.00%
2020	100.00%	90.00%
2021	100.00%	100.00%
;

proc transpose data=have out=need;
   by year;
run;   


proc sgplot data=need;
   vbar year / response=COL1 group=_name_
              groupdisplay=cluster;
   format col1 percent8.;
   label _name_='Source'
         col1 ='Value'
   ;
run;

Proc transpose is a basic tool for reshaping the data. I did not get into any of the options for renaming variables.

I strongly suggest use of SGPLOT instead of Gchart as there are more options to control appearance and is where SAS is concentrating improvements.

Re: Gchart clustered bar chart

JaneS — Fri, 09 Apr 2021 19:35:28 GMT

Thank you so much, it was very helpful!

One more question what would be the best wat to show the percentage for each bar?

Re: Gchart clustered bar chart

ballardw — Fri, 09 Apr 2021 20:16:15 GMT

@JaneS wrote:

Thank you so much, it was very helpful!

One more question what would be the best wat to show the percentage for each bar?

I suggest looking at the documentation here: https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.4&docsetId=grstatproc&docsetTarget=n0yjdd910dh59zn1toodgupaj4v9.htm&locale=en

Knowing where to look is half the battle and since the SGPLOT procedure has roughly 50 different statements, some with 30+ options spend some getting famililiar.

The option DATALABEL will show default labels of values, or if have a different variable in the data set you want to show then Datalabel=thatvariablename