Example 5.1 Reading Specification Limits
See CAPSPEC2 in the SAS/QC Sample LibraryYou can specify specification limits either in the SPEC statement or in a SPEC= data set. In Computing Capability Indices, limits were specified in a SPEC statement. This example illustrates how to create a SPEC= data set to read specification
limits with the SPEC= option in the PROC CAPABILITY statement.
Consider the drink can data presented in Computing Descriptive Statistics. Suppose, in addition to the fluid weight of each drink can, the weight of the can itself is stored in a variable named Cweight
, and both variables are saved in a data set called Can2
. A partial listing of Can2
follows:
proc print data=Can2(obs=5);
run;
Output 5.1.1: The Data Set Can2
12.07 |
1.07 |
12.02 |
0.86 |
12.00 |
1.06 |
12.01 |
1.08 |
11.98 |
1.02 |
The following DATA step creates a data set named Limits
containing specification limits for the fluid weight and the can weight. Limits
has 4 variables (_VAR_
, _LSL_
, _USL_
, and _TARGET_
) and 2 observations. The first observation contains the specification limit information for the variable Weight
, and the second contains the specification limit information for the variable Cweight
.
data Limits;
length _var_ $8;
_var_ = 'Weight';
_lsl_ = 11.95;
_target_ = 12;
_usl_ = 12.05;
output;
_var_ = 'Cweight';
_lsl_ = 0.90;
_target_ = 1;
_usl_ = 1.10;
output;
run;
The following statements read the specification information from the Limits
data set into the CAPABILITY procedure by using the SPEC= option. These statements print summary statistics, capability indices,
and specification limit information for Weight
and Cweight
. Figure 5.1 and Figure 5.2 display the output for Weight
. Output 5.1.2 displays the output for Cweight
.
title 'Process Capability Analysis of Drink Can Data';
proc capability data=Can2 specs=Limits;
var Cweight;
run;
Output 5.1.2: Printed Output for Variable Cweight
The CAPABILITY Procedure
Variable: Cweight (Can Weight (ounces))
100 |
100 |
1.004 |
100.4 |
0.06330941 |
0.00400808 |
-0.074821 |
-0.5433858 |
101.1984 |
0.3968 |
6.30571767 |
0.00633094 |
1.004000 |
0.06331 |
1.000000 |
0.00401 |
1.040000 |
0.29000 |
|
0.08500 |
Note: The mode displayed is the smallest of 2 modes with a count of 8.
158.5862 |
<.0001 |
50 |
<.0001 |
2525 |
<.0001 |
0.987310 |
0.4588 |
0.061410 |
>0.1500 |
0.048175 |
>0.2500 |
0.361939 |
>0.2500 |
1.150 |
1.140 |
1.105 |
1.080 |
1.045 |
1.000 |
0.960 |
0.910 |
0.900 |
0.870 |
0.860 |
0.86 |
2 |
1.11 |
42 |
0.88 |
89 |
1.12 |
28 |
0.88 |
64 |
1.12 |
34 |
0.90 |
68 |
1.13 |
48 |
0.90 |
59 |
1.15 |
52 |
0.900000 |
3.00000 |
1.000000 |
92.00000 |
1.100000 |
5.00000 |
0.526515 |
0.453237 |
0.599670 |
0.547575 |
0.446607 |
0.647299 |
0.505454 |
0.408856 |
0.600808 |
0.505454 |
0.409407 |
0.601501 |
0.525467 |
0.454973 |
0.601113 |