topic Re: Is there is any way to get rid of Final bar in Waterfall chart in Graphics Programming

Is there is any way to get rid of Final bar in Waterfall chart

sanjay1 — Wed, 21 Sep 2016 16:14:00 GMT

HI Sas Experts,

I wanted to remove the final bar from the waterfall chart. Please guide

Please check the attched image.

Re: Is there is any way to get rid of Final bar in Waterfall chart

BrunoMueller — Wed, 21 Sep 2016 19:55:29 GMT

Yes there is.

You will need to use GTL to do this.

For a start you can use your Proc SGPLOT code and add the TMPLOUT= option. This will write out the GTL code to a file.

proc sgplot data=sashelp.class tmplout="c:\temp\sgplot.sas";
  waterfall category=age response=height ;
run;

Then adapt the code like below. Check the doc for the WATERFALLCHART statement it has the DISPLAY= option.

ods path
  (prepend) work.mytemplates (update)
;

proc template;
  define statgraph sgplot_waterfall;
    begingraph / collation=binary;
      layout overlay / yaxisopts=(labelFitPolicy=Split) y2axisopts=(labelFitPolicy=Split);
        WaterfallChart Category=Age Response=Height / 
          primary=true LegendLabel="Height" NAME="WATERFALL"
          display=(
          FILL 
          /*            FINALBAR displays the “final” bar */
          OUTLINE 
          CONNECT 
          )
        ;
      endlayout;
    endgraph;
  end;
run;

proc sgrender data=sashelp.class template=sgplot_waterfall;
run;

Bruno

Re: Is there is any way to get rid of Final bar in Waterfall chart

sanjay1 — Thu, 22 Sep 2016 07:58:52 GMT

Hi Bruno,

Thats working fine, can i also get the values on the top of the each bar.(and I also want to get the space between each bar is there is anyway to do this).

Thank you very much.

Re: Is there is any way to get rid of Final bar in Waterfall chart

BrunoMueller — Fri, 23 Sep 2016 08:17:58 GMT

Have a look at the doc for the WATERFALL statement, data values can usally be displayed with the DATALABEL option.

Bruno