Output Data Sets :: SAS/QC(R) 12.1 User's Guide

Output Data Sets

OUTLIMITS= Data Set

The OUTLIMITS= data set saves control limits and control limit parameters. The following variables can be saved:

Table 17.33: OUTLIMITS= Data Set

Variable	Description
`_ALPHA_`	probability ( $\alpha$ ) of exceeding limits
`_CP_`	capability index $C_{p}$
`_CPK_`	capability index $C_{pk}$
`_CPL_`	capability index
`_CPM_`	capability index $C_{pm}$
`_CPU_`	capability index
`_INDEX_`	optional identifier for the control limits specified with the OUTINDEX= option
`_LCLM_`	lower control limit for subgroup median
`_LCLR_`	lower control limit for subgroup range
`_LIMITN_`	sample size associated with the control limits
`_LSL_`	lower specification limit
`_MEAN_`	estimate of process mean ( $\bar{M}$ , $\tilde{M}$ , $\overline{\overline{X}}$ , or $\mu _0$ )
`_R_`	value of central line on range chart
`_SIGMAS_`	multiple (k) of standard error of $M_{i}$ or $R_{i}$
`_STDDEV_`	process standard deviation ( $\hat{\sigma }$ or $\sigma _{0}$ )
`_SUBGRP_`	subgroup-variable specified in the MRCHART statement
`_TARGET_`	target value
`_TYPE_`	type (estimate or standard value) of `_MEAN_` and `_STDDEV_`
`_UCLM_`	upper control limit for subgroup median
`_UCLR_`	upper control limit for subgroup range
`_USL_`	upper specification limit
`_VAR_`	process specified in the MRCHART statement

Notes:

If the control limits vary with subgroup sample size, the special missing value V is assigned to the variables _LIMITN_, _LCLM_, _UCLM_, _LCLR_, _R_, and _UCLR_.
If the limits are defined in terms of a multiple k of the standard errors of $M_{i}$ and $R_{i}$ , the value of _ALPHA_ is computed as $\alpha =2(1-F_{med}(k,n))$ , where $F_{med}(\cdot ,n)$ is the cumulative distribution function of the median of a random sample of n standard normally distributed observations, and n is the value of _LIMITN_. If _LIMITN_ has the special missing value V, this value is assigned to _ALPHA_.
If the limits are probability limits, the value of _SIGMAS_ is computed as $k=F_{med}^{-1}(1-\alpha /2,n)$ , where $F_{med}^{-1}(\cdot ,n)$ is the inverse distribution function of the median of a random sample of n standard normally distributed observations, and n is the value of _LIMITN_. If _LIMITN_ has the special missing value V, this value is assigned to _SIGMAS_.
The variables _CP_, _CPK_, _CPL_, _CPU_, _LSL_, and _USL_ are included only if you provide specification limits with the LSL= and USL= options. The variables _CPM_ and _TARGET_ are included if, in addition, you provide a target value with the TARGET= option. See Capability Indices for computational details.
Optional BY variables are saved in the OUTLIMITS= data set.

The OUTLIMITS= data set contains one observation for each process specified in the MRCHART statement. For an example of an OUTLIMITS= data set, see Saving Control Limits.

OUTHISTORY= Data Set

The OUTHISTORY= option saves subgroup summary statistics. The following variables are saved:

the subgroup-variable
a subgroup median variable named by process suffixed with M
a subgroup range variable named by process suffixed with R
a subgroup sample size variable named by process suffixed with N

Given a process name that contains 32 characters, the procedure first shortens the name to its first 16 characters and its last 15 characters, and then it adds the suffix.

Variables containing subgroup medians, ranges, and sample sizes are created for each process specified in the MRCHART statement. For example, consider the following statements:

proc shewhart data=Steel;
   mrchart (Width Diameter)*lot / outhistory=Summary;
run;

The data set Summary contains variables named Lot, WidthM, WidthR, WidthN, DiameterM, DiameterR, and DiameterN.

Additionally, the following variables, if specified, are included:

BY variables
block-variables
symbol-variable
ID variables
_PHASE_ (if the OUTPHASE= option is specified)

For an example of an OUTHISTORY= data set, see Saving Summary Statistics.

OUTTABLE= Data Set

The OUTTABLE= data set saves subgroup summary statistics, control limits, and related information. The following variables are saved:

Variable	Description
`_ALPHA_`	probability ( $\alpha$ ) of exceeding control limits
`_EXLIM_`	control limit exceeded on median chart
`_EXLIMR_`	control limit exceeded on range chart
`_LCLM_`	lower control limit for median
`_LCLR_`	lower control limit for range
`_LIMITN_`	nominal sample size associated with the control limits
`_MEAN_`	estimate of process mean ( $\bar{M}$ , $\tilde{M}$ , $\overline{\overline{X}}$ , or $\mu _0$ )
`_R_`	average range
`_SIGMAS_`	multiple (k) of the standard error associated with control limits
subgroup	values of the subgroup variable
`_SUBM_`	subgroup median
`_SUBN_`	subgroup sample size
`_SUBR_`	subgroup range
`_TESTS_`	tests for special causes signaled on median chart
`_TESTS2_`	tests for special causes signaled on range chart
`_UCLM_`	upper control limit for mean
`_UCLR_`	upper control limit for range
`_VAR_`	process specified in the MRCHART statement

In addition, the following variables, if specified, are included:

BY variables
block-variables
symbol-variable
ID variables
_PHASE_ (if the READPHASES= option is specified)

Notes:

Either the variable _ALPHA_ or the variable _SIGMAS_ is saved depending on how the control limits are defined (with the ALPHA= or SIGMAS= options, respectively, or with the corresponding variables in a LIMITS= data set).
The variable _TESTS_ is saved if you specify the TESTS= option. The kth character of a value of _TESTS_ is k if Test k is positive at that subgroup. For example, if you request all eight tests and Tests 2 and 8 are positive for a given subgroup, the value of _TESTS_ has a 2 for the second character, an 8 for the eighth character, and blanks for the other six characters.
The variable _TESTS2_ is saved if you specify the TESTS2= option. The kth character of a value of _TESTS2_ is k if Test k is positive at that subgroup.
The variables _EXLIM_, _EXLIMR_, _TESTS_, and _TESTS2_ are character variables of length 8. The variable _PHASE_ is a character variable of length 48. The variable _VAR_ is a character variable whose length is no greater than 32. All other variables are numeric.

For an example of an OUTTABLE= data set, see Saving Control Limits.

MRCHART Statement: SHEWHART Procedure

Output Data Sets

OUTLIMITS= Data Set

OUTHISTORY= Data Set

OUTTABLE= Data Set