This SAS Note shows how to use the Graph Template Language, GTL, and the SGRENDER procedure to create a bar chart with a line overlay.

---

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

data plantProd;
  attrib prod label='Production';
  attrib prod_pct label='Production %' format=percent5.2;
  input prod prod_pct Time $ Site $;
  Time=translate(Time, 'A0'x, '.');  /* map '.' to non-breaking space */
  datalines;
321 0.0334  w01 US64
373 0.0173  w01 CA41
218 0.0367  w08 US64
420 0.0188  w08 CA41
117 0.0163  w16 US64
461 0.0190  w16 CA41
64  0.0441  w24 US64
320 0.0208  w24 CA41
156 0.0261  w32 US64
620 0.0116  w32 CA41
115 0.0193  w40 US64
700 0.0058  w40 CA41
110 0.0091  w48 US64
642 0.0039  w48 CA41
157 0.0099  w52 US64
586 0.0012  w52 CA41
.   .       ..  US64
.   .       ..  CA41
4657  0.0315  Q1  US64
2491  0.0162  Q1  CA41
1434  0.0251  Q2  US64
2147  0.0112  Q2  CA41
1696  0.0314  Q3  US64
3206  0.0155  Q3  CA41
2895  0.0399  Q4  US64
4174  0.0226  Q4  CA41
.     .       ... US64
.     .       ... CA41
6091  0.0294  H1  US64
4638  0.0145  H1  CA41
4591  0.0364  H2  US64
7380  0.0197  H2  CA41
;
run;

proc template;
 define statgraph chunked;
  begingraph ;
    dynamic _icon _yaxis _xaxis;
    EntryTitle "Factory Output by Week, Quarter and Half-Year" ;

%let line_attr_opts = pattern=solid thickness=3; 
%let marker_attr_opts = symbol=squareFilled size=12;

    legendItem name="line" type=line /
        lineattrs=(color=grey &line_attr_opts)
        label="Production %";
    layout overlay / xaxisopts=( display=_xaxis type=discrete )
        yaxisopts=( griddisplay=on offsetmin=0 display=_yaxis)
        y2axisopts=( offsetmin=0 display=_yaxis);
      BarChartParm X=time Y=prod / group=Site name="bar" dataskin=matte
        fillAttrs=(transparency=0.1);
      SeriesPlot X=time Y=prod_pct / group=Site display=all break=true
        yaxis=y2 markerattrs=(&marker_attr_opts)
        lineattrs=( &line_attr_opts) ;
      /* inlay markers */
      ScatterPlot X=time Y=prod_pct /  yaxis=y2
        markerattrs=(color=white symbol=square size=8);
      if (exists(_icon) ne 1)
         DiscreteLegend "bar" "line" / title="Site:";
      endif;
    endlayout;
    if (exists(_icon) ne 1)
      entryFootnote halign=left
        textAttrs=(style=normal) "Paper: Hebbar & Matange (2013)."
                                " Free Expressions and Other GTL Tips."
        textAttrs=( ) " SAS Global Forum." ;
    endif;
  endgraph;
 end;
run;

/*--Create Graph--*/
ods graphics / reset noscale width=8in height=4.5in imagename='Chunked_V94';
proc sgrender template=chunked data=plantProd;
  dynamic _xaxis='ticks tickvalues';
run;

---

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

Operating System and Release Information