topic How to align group labels of the hbar in sgplot, and remove space between hbars and labels in Graphics Programming

How to align group labels of the hbar in sgplot, and remove space between hbars and labels

Jason2020 — Tue, 05 Oct 2021 19:42:55 GMT

Hello,

I am using proc sgplot code below to make this graph. However, I would like the group labels to be left-aligned, and the bars to be close to the group labels (now there is a space). Also, it would be desirable to move the group data values of the hbar a little away from the bars so that they are more readable. I use sas v9.4 (TS1M4).

Your help is appreciated.

proc sgplot;

styleattrs datacontrastcolors=(very_dark_blue dark_red)

datacolors=(greenish_Blue "vivid yellowish brown")

datalinepatterns=(solid);

hbarparm category=region3 response=colpercent / group=periodontitis4 grouporder=ascending

datalabel name='bar' dataskin=crisp;

scatter x=totpercent y=region3 / markerchar=totpercent

markercharattrs=(size=14 weight=bold) name='scatter';

xaxis discreteorder=data

label='% Subjects'

labelattrs=(size=16pt weight=bold)

valueattrs=(size=14pt);

yaxis grid label='Geographic Regions'

labelattrs=(size=20pt weight=bold)

valueattrs=(size=14pt weight=bold)

display=(noticks) ;

keylegend 'bar' / location=inside position=topright

titleattrs=(weight=bold size=14pt)

valueattrs=(color=black size=14pt)

title="" down=2;

run;

Re: How to align group labels of the hbar in sgplot, and remove space between hbars and labels

Jay54 — Tue, 05 Oct 2021 19:55:30 GMT

You are using a SCATTER plot overlay to display the totpercent values. This causes the overlap on the values on the top of the bar. This is also causing the extra space at the left near the y-axis. You can use the DATALABEL=totpercent option on the HBARPARM itself and drop the SCATTER statement.

Re: How to align group labels of the hbar in sgplot, and remove space between hbars and labels

Jason2020 — Tue, 05 Oct 2021 20:15:27 GMT

I removed the SCATTER and added the DATALABEL=totpercent.
The extra space is now resolved. However, the total percent is not showing, and the group labels "Central, North West, etc" are not left-aligned. Anything I can do to correct the latter 2 issues?
Thanks.

Re: How to align group labels of the hbar in sgplot, and remove space between hbars and labels

DanH_sas — Wed, 06 Oct 2021 13:45:17 GMT

The DATALABEL option did not work because the grouped bar chart is stacked (it would have worked for a "cluster" display). The best way to make this work for you is to use a TEXT plot (see the code below). There are options to adjust the text alignment and for disabling the text plot from contributing to the "min" offset. You want it to contribute to the other offsets so that there is no clipping.

Hope this helps!

Dan

proc sgplot;
styleattrs datacontrastcolors=(very_dark_blue dark_red)
   datacolors=(greenish_Blue "vivid yellowish brown")
   datalinepatterns=(solid);
hbarparm category=region3 response=colpercent / group=periodontitis4 grouporder=ascending
  datalabel name='bar' dataskin=crisp;
text x=totpercent y=region3 text=totpercent / position=right
  contributeoffsets=(xmax ymin ymax)
  textattrs=(size=14 weight=bold);
xaxis discreteorder=data
  label='% Subjects'
  labelattrs=(size=16pt weight=bold)
  valueattrs=(size=14pt);
yaxis grid label='Geographic Regions'
  labelattrs=(size=20pt weight=bold)
  valueattrs=(size=14pt weight=bold)
  display=(noticks) ;
keylegend 'bar' / location=inside position=topright
  titleattrs=(weight=bold size=14pt)
  valueattrs=(color=black size=14pt)
  title=""  down=2;
run;

Re: How to align group labels of the hbar in sgplot, and remove space between hbars and labels

Jason2020 — Wed, 06 Oct 2021 12:40:51 GMT

Dan: Your solution worked nicely. The only change I made is to replace MARKERCHARATTRS with TEXTATTRS because it caused an error.
Thank you very much. The final graph is shown below.

Re: How to align group labels of the hbar in sgplot, and remove space between hbars and labels

DanH_sas — Wed, 06 Oct 2021 13:48:53 GMT

Sorry about not changing MARKERCHARATTRS to TEXTATTRS. I edited the solution for everyone's future reference. Thanks!

Re: How to align group labels of the hbar in sgplot, and remove space between hbars and labels

Jason2020 — Wed, 06 Oct 2021 20:21:37 GMT

Dan,
One final question: I am placing two versions of this plot side by side, and therefore would like to remove the yaxis labels (valueattrs) "Central, North West, etc" from one of the 2 plots. Is there a way to do that?

Jason

Re: How to align group labels of the hbar in sgplot, and remove space between hbars and labels

DanH_sas — Wed, 06 Oct 2021 22:03:26 GMT

The DISPLAY option you are using on your YAXIS statement supports up to four options inside the parentheses:

NOTICKS - remove the tick mark lines
NOVALUES - remove the tick value text
NOLINE - remove the axis line
NOLABEL - remove the axis label

DISPLAY=NONE removes everything. DISPLAY=ALL shows everything. Try these out to get the look you want. As an example, to remove the axis labels and values, you would do DISPLAY=(NOLABEL NOVALUES).

Re: How to align group labels of the hbar in sgplot, and remove space between hbars and labels

Jason2020 — Thu, 07 Oct 2021 11:57:04 GMT

Great. Thank you very much