SAS/GRAPH Software: Reference

Example 7. Using BY-group Processing to Generate a Series of Charts

Features:

AXIS statement options:

LABEL=

MAJOR=

MINOR=

NOPLANE

ORDER=

STYLE=

VALUE=

BY statement

GOPTIONS statement options:

HSIZE=

VSIZE=

OPTIONS statement option:

NOBYLINE

PATTERN statement option:

COLOR=

TITLE statement:

#BYVAL

Sample library member: GR08N07

This example uses a BY statement with the GCHART procedure to produce a separate 3D vertical bar chart for each value of the BY variable TYPE. The three charts, which are shown in Output for BY Value Corn, Output for BY Value Rice, and Output for BY Value Wheat following the code, show leading grain producers for 1995 and 1996.

The program suppresses the default BY lines and instead uses #BYVAL in the TITLE statement text string to include the BY variable value in the title for each chart.

The AXIS1 statement that is assigned to the vertical (response) axis is automatically applied to all three graphs generated by the BY statement. This AXIS statement removes all the elements of the response axis except the label. The same AXIS statement also includes an ORDER= option. Because this option is applied to all the graphs, it ensures that they all use the same scale of response values.

Because no subgroups are specified and the PATTERNID= option is omitted, the color specified in the single PATTERN statement is used by all the bars.

Assign the libref and set the graphics environment. HSIZE= and VSIZE= set the horizontal and vertical size of the graphics output area.

libname reflib 'SAS-data-library';
goptions reset=global gunit=pct border cback=white
         colors=(black blue green red)
         ftitle=swissb ftext=swiss htitle=5
         htext=4 hsize=5in vsize=5in;

Create the data set REFLIB.GRAINLDR. REFLIB.GRAINLDR contains data about grain production in five countries for 1995 and 1996. The quantities in AMOUNT are in thousands of metric tons. MEGTONS converts these quantities to millions of metric tons.

data reflib.grainldr;
   length country $ 3 type $ 5;
   input year country $ type $ amount;
   megtons=amount/1000;
   datalines;
1995 BRZ  Wheat    1516
1995 BRZ  Rice     11236
1995 BRZ  Corn     36276
...more data lines...
1996 USA  Wheat    62099
1996 USA  Rice     7771
1996 USA  Corn     236064
;

Create a format for the values of COUNTRY.

proc format;
  value $country 'BRZ' = 'Brazil'
                 'CHN' = 'China'
                 'IND' = 'India'
                 'INS' = 'Indonesia'
                 'USA' = 'United States';
run;

Suppress the default BY-line and define a title that includes the BY-value. #BYVAL inserts the value of the BY variable COUNTRY into the title of each report.

options nobyline;
title1 'Leading #byval(type) Producers'
        j=c '1995 and 1996';
footnote1 j=r h=3 'GR08N07 ';

Specify a color for the bars.

pattern1 color=green;

Define the axis characteristics for the response axes. ORDER= specifies the range of values for the response axes. ANGLE=90 in the LABEL= option rotates the label 90 degrees. All the other options remove axis elements. MAJOR=, MINOR=, and VALUE= remove the tick marks and values. STYLE=0 removes the line. NOPLANE removes the 3D plane.

axis1 order=(0 to 550 by 100)
      label=(angle=90 'Millions of Metric Tons')
      major=none
      minor=none
      value=none
      style=0
      noplane;

Define midpoint axis characteristics. SPLIT= defines the character that causes an automatic line break in the axis values.

axis2 label=none
      split=' ';

Sort data according to values of BY variable. The data must be sorted before running PROC GCHART with the BY statement.

proc sort data=reflib.grainldr out=temp;
     by type;
run;

Generate the vertical bar charts using a BY statement. The BY statement produces a chart for each value of SITE. The FORMAT statement assigns the $COUNTRY. format to the chart variable. Assigning AXIS1 to RAXIS= causes all three charts to have the same response axis.

proc gchart data=temp (where=(megtons gt 31))
     gout=reflib.excat;
   by type;
   format country $country.;
   vbar3d country / sumvar=megtons
                    outside=sum
                    descending
                    shape=hexagon
                    width=8
                    coutline=black
                    cframe=grayaa
                    maxis=axis2
                    raxis=axis1 name='gr08n07';
run;
quit;

Output for BY Value Corn

[IMAGE]

Output for BY Value Rice

[IMAGE]

Output for BY Value Wheat

[IMAGE]

Chapter Contents
Previous
Next
Top of Page