Adding symbol at the end of bars in a waterfall plot

[VCM]

I am creating a waterfall plot where I need to add a hash symbol to then end of any bar where VAR1 has a certain value.  I've created variable ZZ with value = "#" when VAR1 meets the condition (if VAR1 = 1, then ZZ = "#").

Now, how do I add this in the proc template?  I tried markersymbol, but it puts the symbol on the zero (beginning of the bar), not at the end:

proc template;
define statgraph &repbase.;
begingraph;
entrytitle "(Number of Subjects = &num)"/TEXTATTRS=(weight=bold size=10pt);
layout overlay/xaxisopts=(label="Subjects" labelattrs=(weight=bold size=8pt)
griddisplay=on tickvalueattrs=(weight=bold size=7pt) type=discrete
display=(&x_axis_display))
yaxisopts=(label="&YAXIS_LABEL" labelattrs=(weight=bold size=8pt)
griddisplay=on
tickvalueattrs=(weight=bold size=8pt)
linearopts=(&y_axis_scale )
griddisplay=on);
barchart x=usubjid y=min/ group=TRT01AN name="trt" barwidth=0.4;
scatterplot x=usubjid y=label2/MARKERCHARACTER=zz MARKERCHARACTERATTRS=(weight=bold size=6pt);
referenceline y=-30 /lineattrs=(thickness=1px pattern=34 color=cx000000 ) CURVELABELATTRS=(weight=bold size=8pt);
referenceline y=20/lineattrs=(thickness=1px pattern=34 color=cx000000 ) CURVELABELATTRS=(weight=bold size=8pt);

discretelegend "trt"/title="Treatment Group:"  titleattrs=(weight=bold size=10pt) valueattrs=(weight=bold size=10pt);
endlayout;
endgraph;
end;
run;

proc sgrender data=tmm_plot template=&repbase.;
run;

Note that I am using SAS 9.2.  Is there an option I can use?

Many thanks!

[Reeza]

If you're using SAS 9.4 maybe DATALABEL options instead?

https://support.sas.com/documentation/cdl/en/grstatgraph/69718/HTML/default/viewer.htm#p08qhdljvzthm...

[VCM]

Hi Reeza--

Unfortunately, I'm running in a client's system, and I'm pretty much stuck with 9.2. 😞  But thanks for replying! 🙂

[Jay54 · Accepted solution]

With SAS 9.2, you can overlay a SCATTERPLOT statement on the BARCHART statement using GTL as you have done.  Maybe the value of the "label2" variable is not correctly computed.  I did the something similar in this article to place the asterix on some bars using SGPLOT.  http://blogs.sas.com/content/graphicallyspeaking/2017/07/30/clinical-graphs-waterfall-plot/

[VCM]

Thank you, Sanjay, that was exactly it!  I updated the label2 value (defined in the body of the program) as min + 4 (for positive values) or min - 4 (for negative values), to allow a little bit of space between the edge of the bar and the symbol.