Example 29.7: Merging Columns in a Comparative Pareto Chart

Details and Examples

Example 29.7: Merging Columns in a Comparative Pareto Chart

See PARETO14 in the SAS/QC Sample Library

This example is a continuation of Example 29.4 and illustrates a method for merging the columns in a comparative Pareto chart. Suppose that controls for metallization were introduced on Wednesday. To show the effect of the controls, the columns for Monday and Tuesday are to be merged into a column labeled Before Controls, and the remaining columns are to be merged into a column labeled After Controls. The following statements introduce a format named CNTLFMT that merges the levels of DAY:

   proc format;
      value cntlfmt   1-2 = 'Before Controls'
                      3-5 = 'After Controls' ;
   run;

The following statements create the chart shown in Output 29.7.1:

   title 'Pareto Analysis by Process and Control Phase' ;
   proc pareto data=failure7;
      vbar cause / class       = ( process day )
                   freq        = counts
                   cbars       = vigb
                   cframe      = ligr
                   cframetop   = ligr
                   cframeside  = ligr
                   last        = 'Miscellaneous'
                   scale       = count
                   catleglabel = 'Failure Causes:'
                   intertile   = 1.0
                   nohlabel
                   nocurve
                   nlegend ;
      format day cntlfmt. ;
      label  day = 'Status of Controls for Metallization';
   run;

Output 29.7.1: Merging Classification Levels

The levels of DAY are determined by its formatted values, Before Controls and After Controls. By default, the order in which the columns are displayed is determined by the internal values. In this example, there are multiple distinct internal values for each level, and the procedure uses the internal value that occurs first in the input data set.

Chapter Contents
Previous
Next
Top