Creating a Pareto Chart Using Frequency Data

See PARETO5 in the SAS/QC Sample LibraryIn some situations, a count (frequency) is available for each category, or you can compress a large data set by creating a frequency variable for the categories before applying the PARETO procedure.

For example, you can use the FREQ procedure to obtain the compressed data set Failure2 from the data set Failure1.

proc freq data=Failure1;
   tables Cause / noprint out=Failure2;
run;

A listing of Failure2 is shown in Figure 15.8.

Figure 15.8: The Data Set Failure2 Created Using PROC FREQ

IC Manufacturing Problems

Obs Cause COUNT PERCENT
1 Contamination 14 45.1613
2 Corrosion 2 6.4516
3 Doping 1 3.2258
4 Metallization 2 6.4516
5 Miscellaneous 3 9.6774
6 Oxide Defect 8 25.8065
7 Silicon Defect 1 3.2258


The following statements produce a Pareto chart for the data in Failure2:

title 'Analysis of IC Failures';
symbol v=dot;
proc pareto data=Failure2;
   vbar Cause / freq     = Count
                scale    = count
                interbar = 1.0
                last     = 'Miscellaneous'
                nlegend  = 'Total Circuits'
                cframenleg;
run;

The chart is displayed in Figure 15.9.

Figure 15.9: Pareto Chart with Frequency Scale

Pareto Chart with Frequency Scale


A slash (/) is used to separate the process variable Cause from the options specified in the VBAR statement. The frequency variable Count is specified with the FREQ= option. Specifying the keyword COUNT with the SCALE= option requests a frequency scale for the vertical axis.

The INTERBAR= option inserts a small space between the bars, and specifying LAST='Miscellaneous' causes the category Miscellaneous to be displayed last regardless of its frequency. The NLEGEND= option adds a sample size legend labeled Total Circuits, and the CFRAMENLEG option frames the legend. The SYMBOL statement marks points on the curve with dots.

There are two sets of tied categories in this example; Corrosion and Metallization each occur twice, and Doping and Silicon Defect each occur once. The procedure displays tied categories in alphabetical order of their formatted values. Thus, Corrosion appears before Metallization, and Doping appears before Silicon Defect in Figure 15.9. This is simply a convention, and no practical significance should be attached to the order in which tied categories are arranged.