Creating a positive-negative bar chart

Rodcjones — Wed, 17 Mar 2021 14:25:30 GMT

I am seeking a reference that will help me create what I believe is called a "positive-negative" bar chart (although I'm not sure). Here's an example visual I found on the web at http://beatexcel.com/positive-negative-bar-chart/ .

In the SAS documentation I found this reference (specifically the BASELINEINTERCEPT statement) https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=grstatgraph&docsetTarget=n1dlakkx61v72in1k3ebm8rz18qd.htm&locale=en

But this is not helpful to me because I prefer/need to do SGPLOT or other SAS Graphics procedures rather than this if possible.

This is a sample dataset I'm trying to graph in this way.

data have;
input day $ value ;
datalines;
Wednesday 1.13203258
Tuesday 1.055489878
Thursday 0.050301811
Monday -0.145520643
Saturday -0.281669589
Sunday -0.281669589
Friday -1.360262415
;

Re: Creating a positive-negative bar chart

ballardw — Wed, 17 Mar 2021 14:32:53 GMT

Basic HBAR for the data shown:

proc sgplot data=have;
   hbar day /response=value;
run;

And possible order control using the categoryorder option.

proc sgplot data=have;
   hbar day /response=value 
            categoryorder=respdesc;
run;

Re: Creating a positive-negative bar chart

Rodcjones — Wed, 17 Mar 2021 14:40:27 GMT

Simple, elegant and perfect solution - thank you!

topic Re: Creating a positive-negative bar chart in SAS Programming

Creating a positive-negative bar chart

Re: Creating a positive-negative bar chart

Re: Creating a positive-negative bar chart