Creating a Data Set Outside the GAGE Application

Note: This section assumes you have some knowledge of creating SAS data sets.

Suppose your gage study data are stored in an external file, and you want to use the GAGE application but do not want to type in the data. How do you create a SAS data set that can be read by the GAGE application?

Table A.2 lists the SAS variables needed for the general information and the measurements in a GAGE data set.

Table A.2 GAGE Data Set Variables
 

Variable

Description

Name

Type

Length

Values

Test ID

TESTID

character

8

 

Date

DATE

numeric

8

 

Performed By

WHO

character

30

 

Part No. & Name

PART

character

20

 

Characteristics

CHAR

character

20

 

Specification

SPEC

character

20

 

Gage Name

GAGENAME

character

20

 

Gage No.

GAGENO

character

20

 

Gage Type

GAGETYPE

character

20

 

Sigma Multiple

SPREAD

numeric

8

4, 5.15, 6

Analysis

PTYPE

character

1

T, V

Tolerance

TOL

numeric

8

 

Operator (condition)

CONDITN

character

8

 

Part

SAMPLE

numeric

8

1–15

Trial 1

TRIAL1

numeric

8

 

Trial 2

TRIAL2

numeric

8

 

Trial 3

TRIAL3

numeric

8

 

Trial 4

TRIAL4

numeric

8

 

A GAGE data set must have one observation for each combination of values of CONDITN and PART. You can have up to four operators (values of CONDITN), and each must be assigned a unique value. The MMDDYY8. format must be associated with the DATE variable. A PTYPE value of V indicates that you want a percent of process variation analysis. A PTYPE value of T indicates that you want a percent of tolerance analysis. The variable TOL must be assigned a tolerance value when PTYPE = T.

Return to the gasket thickness gage example described in the section Getting Started. Assume you are using the SAS System under Microsoft Windows, and the gasket thicknesses are stored in the external file c:\gage\gthick.dat. A partial listing of the data in gthick.dat is as follows:

Columns: 0----+----1----+----2----+----3
          George    1   0.65      0.6
          George    2   1.0       1.0
          George    3   0.85      0.8
          George    4   0.85      0.95
                      .
                      .
                      .
          Robert    7   0.95      0.95
          Robert    8   0.8       0.8
          Robert    9   1.05      1.05
          Robert   10   0.85      0.8

The following statements read the data into a GAGE SAS data set named SASUSER.GASKET. The LENGTH statement guarantees that each variable is represented in the data set. For the GAGE application to identify the data set as valid, the TYPE and ALTER data set options must be specified as shown.

data sasuser.gasket (type=_GRR alter=_GAGE);
   length testid $8 date 8 who $30 part char spec gagename
          gageno gagetype $20 spread 8 ptype $1 tol 8
          conditn $8 sample trial1 trial2 trial3 trial4 8;
   format date mmddyy8.;
   retain testid   'Gasket'         date     '17apr02'd
          who      'John Smith'     part     'Gasket'
          spec     '0.6-1.0 mm'     gagename 'Thickness'
          gageno   'X-2034'         gagetype '0-10 mm'
          spread   5.15             ptype    'T'
          tol      0.4;
   infile 'c:\gage\gthick.dat';
   input conditn $ 1-8 sample 10-11 trial1 15-18
         trial2 25-28;
run;

Figure A.26 is a partial listing of the SAS data set SASUSER.GASKET.

Figure A.26 The SAS Data Set SASUSER.GASKET

OBS TESTID DATE WHO PART CHAR SPEC GAGENAME GAGENO GAGETYPE

1 Gasket 04/17/02 John Smith Gasket 0.6-1.0 mm Thickness X-2034 0-10 mm 2 Gasket 04/17/02 John Smith Gasket 0.6-1.0 mm Thickness X-2034 0-10 mm 3 Gasket 04/17/02 John Smith Gasket 0.6-1.0 mm Thickness X-2034 0-10 mm 4 Gasket 04/17/02 John Smith Gasket 0.6-1.0 mm Thickness X-2034 0-10 mm

OBS SPREAD PTYPE TOL CONDITN SAMPLE TRIAL1 TRIAL2 TRIAL3 TRIAL4

1 5.15 T 0.4 George 1 0.65 0.60 . . 2 5.15 T 0.4 George 2 1.00 1.00 . . 3 5.15 T 0.4 George 3 0.85 0.80 . . 4 5.15 T 0.4 George 4 0.85 0.95 . . . . .

OBS TESTID DATE WHO PART CHAR SPEC GAGENAME GAGENO GAGETYPE

27 Gasket 04/17/02 John Smith Gasket 0.6-1.0 mm Thickness X-2034 0-10 mm 28 Gasket 04/17/02 John Smith Gasket 0.6-1.0 mm Thickness X-2034 0-10 mm 29 Gasket 04/17/02 John Smith Gasket 0.6-1.0 mm Thickness X-2034 0-10 mm 30 Gasket 04/17/02 John Smith Gasket 0.6-1.0 mm Thickness X-2034 0-10 mm

OBS SPREAD PTYPE TOL CONDITN SAMPLE TRIAL1 TRIAL2 TRIAL3 TRIAL4

27 5.15 T 0.4 Robert 7 0.95 0.95 . . 28 5.15 T 0.4 Robert 8 0.80 0.80 . . 29 5.15 T 0.4 Robert 9 1.05 1.05 . . 30 5.15 T 0.4 Robert 10 0.85 0.80 . .