Hi there, I customized the barchart from the customer. Now the color of the bars changes in dependent from the value (plus/minus) in red or green. I realized it in the discreteattrmap in proc template. Now I’ve the problem with the labels of the grouped data in the legend. I can’t setting the legendlabel for this grouped data; every time I get written ‘G’ (for green) and ‘R’ (for red) in the legend. Where can I set the label for this grouped data in the legend ? Thank you very much in advanced Brigitte ~~~~~~~~~~~~~~~ here the code snippet ~~~~~~~~~~~ data WORK.DATA_GRAPH; input MONAT_TXT $ KER_GESAMT_IST_AJ BAR_COLOR $ KER_GESAMT_IST_VJ ; datalines; January 288425 G 300000 February -280184 R -100000 March 652716 G -50000 ; run; proc template;                 define statgraph ker_graph;                 dynamic _MONAT_TXT                      _KER_GESAMT_IST_VJ                      _KER_GESAMT_IST_AJ                     ;                 begingraph / designheight = 600 designwidth = 1200 border = false;                 entrytitle _id='title' halign=left 'Jahresverlauf operatives Ergebnis' /                            textattrs=(weight=bold style=normal size=9 family='Arial');                 /* Bars farbig, je nach Wert  */                 discreteattrmap name="colorbysign";                      value 'G' /fillattrs=(color=green) ;                      value 'R' /fillattrs=(color=red) ;                 enddiscreteattrmap;                 discreteattrvar attrvar=signvar var=BAR_COLOR attrmap="colorbysign" ;                 layout lattice _id='lattice' /                      columndatarange=data columngutter=10 rowdatarange=data rowgutter=10;                 layout overlay _id='overlay' /                        barchart     _id='bar'     x=_MONAT_TXT y=_KER_GESAMT_IST_AJ  /                                 group=signvar legendlabel='XXXXX'                                 dataskin=gloss                                 barlabel=true                                 barlabelattrs=(color=BLACK style=NORMAL family='Arial' size=9)                                  barwidth=0.5                                 name='bar'                                 ;                        seriesplot   _id='series'  x=_MONAT_TXT y=_KER_GESAMT_IST_VJ  /                                 connectorder=xaxis                                 display=(markers)                                 lineattrs=(color=BLUE THICKNESS=3)                                 markerattrs=(symbol=CIRCLEFILLED color=BLUE size=9)                                 name='series';                  endlayout;                 sidebar /                     align=bottom spacefill=false;                        discretelegend _id='legend' 'bar'  'series' /                        border=true displayclipped=true halign=center opaque=true valign=center                       valueattrs=(color=BLACK style=NORMAL family='Arial' size=9);                 endsidebar;                 endlayout;                 endgraph;                 end;            run; proc sgrender data  = WORK.DATA_GRAPH           template = KER_GRAPH;                dynamic            _MONAT_TXT = "MONAT_TXT"             _KER_GESAMT_IST_VJ  = "KER_GESAMT_IST_VJ"                 _KER_GESAMT_IST_AJ  = "KER_GESAMT_IST_AJ"             ;            run; ... View more

Hi there, I work with SAS 9.3 and want to generate a waterfall chart with grouped data. I’m using proc template and sgrender. The downwards bar I want to display with the red color, the ascending bar with the green color. I want to use the statement “fillattrs=(COLOR=GREEN CONTRASTCOLOR=RED)” but I make something wrong, it don’t works….  😞 Do you have an idea what’s wrong or circumvention for this problem? Thank you very much for your help. Brigitte ~~~~~~~~~~~~~~~~ code ~~~~~~~~~~~ data WORK.DATA_GRAPH;      input MONAT_TXT $ KER_GESAMT_IST_AJ POSNEG; datalines; Jan2011 288425 1 Feb2011 -280884 0 Mar2011 652716 1 Apr2011 200244 1 May2011 27043 1 Jun2011 415841 1 Jul2011 -308976 0 Aug2011 -46304 0 Sep2011 474226 1 ; run; proc template;                 define statgraph KER_GRAPH_WATERFALL ;                 begingraph / designheight = 600 designwidth = 1200 border = false;                 entrytitle _id='title' halign=left 'Jahresverlauf operatives Ergebnis' / textattrs=(weight=bold style=normal size=9 family='Arial');                 layout overlay;                      waterfallchart category=MONAT_TXT response=KER_GESAMT_IST_AJ /                            colorgroup=POSNEG fillattrs=(COLOR=GREEN CONTRASTCOLOR=RED)                            barlabel=true dataskin=gloss                            datalabelattrs=(color=BLACK style=NORMAL family='Arial' size=9)                                                 ;                 endlayout;                 endgraph;            end;            proc sgrender data     = WORK.DATA_GRAPH    template = KER_GRAPH_WATERFALL ; run; ... View more