The SPC Procedure

Example 20.1 Saving Results in Output Data Tables

The following statements perform and R chart analysis on the data table mycas.AllProcesses that is created in the section Getting Started: SPC Procedure and save the results in OUTTABLE= and OUTLIMITS= data tables:

proc spc data=mycas.AllProcesses;
   xrchart / noprint
             outtable  = mycas.AllTable
             outlimits = mycas.AllLimits;
run;

The NOPRINT option suppresses the display of the exception summary table. Output 20.1.1 shows a partial listing of the mycas.AllTable data table.

Output 20.1.1: Partial Listing of the mycas.AllTable Data Table

_VAR_	subgroupname	subgroup	_SIGMAS_	_LIMITN_	_SUBN_	_LCLX_	_SUBX_	_MEAN_	_UCLX_	_STDDEV_	_SUBR_	_R_	_UCLR_
Time	Lot	1	3	6	6	7.94314	8.00833	8.00307	8.06299	0.048927	0.16	0.124	0.24847
Time	Lot	2	3	6	6	7.94314	8.02167	8.00307	8.06299	0.048927	0.09	0.124	0.24847
Time	Lot	3	3	6	6	7.94314	7.97833	8.00307	8.06299	0.048927	0.07	0.124	0.24847
Time	Lot	4	3	6	6	7.94314	8.00667	8.00307	8.06299	0.048927	0.10	0.124	0.24847
Time	Lot	5	3	6	6	7.94314	8.01833	8.00307	8.06299	0.048927	0.16	0.124	0.24847
Time	Lot	6	3	6	6	7.94314	8.00667	8.00307	8.06299	0.048927	0.12	0.124	0.24847
Time	Lot	7	3	6	6	7.94314	7.98500	8.00307	8.06299	0.048927	0.15	0.124	0.24847
Time	Lot	8	3	6	6	7.94314	8.03000	8.00307	8.06299	0.048927	0.11	0.124	0.24847
Time	Lot	9	3	6	6	7.94314	8.03000	8.00307	8.06299	0.048927	0.15	0.124	0.24847
Time	Lot	10	3	6	6	7.94314	7.99167	8.00307	8.06299	0.048927	0.10	0.124	0.24847

Output 20.1.2 displays the mycas.AllLimits data table.

Output 20.1.2: mycas.AllLimits Data Table

processname	subgroupname	_SIGMAS_	_LIMITN_	_LCLX_	_MEAN_	_UCLX_	_STDDEV_	_LCLR_	_R_	_UCLR_	_TYPE_
Time	Lot	3	6	7.94	8.00	8.06	0.049	0.000	0.124	0.25	ESTIMATE
Diameter	Batch	3	5	34.98	34.99	35.01	0.010	0.000	0.022	0.05	ESTIMATE
Partgap	Sample	3	5	241.94	260.00	278.05	13.454	0.000	31.293	66.17	ESTIMATE
Breakstrength	Sample	3	V	V	59.98	V	2.111	V	V	V	ESTIMATE
Amount	Batch	3	V	V	11.98	V	0.044	V	V	V	ESTIMATE
Delay	Day	3	V	V	9.53	V	8.512	V	V	V	ESTIMATE
KWatts	Day	3	20	3362.10	3497.56	3633.02	201.937	312.779	754.225	1195.67	ESTIMATE
Weight	Lot	3	5	21.49	24.61	27.74	2.330	0.000	5.420	11.46	ESTIMATE

Note that limits variables for three of the processes have the special missing value V, because the data for those processes have varying subgroup sample sizes.

The mycas.AllLimits data table has the same format as a LIMITS= data table, so it could provide limits for these processes in a later run of PROC SPC.

Last updated: December 21, 2018