Chapter Contents
Chapter Contents
Previous
Previous
Next
Next
The STDIZE Procedure

Getting Started

The following example demonstrates how you can use the STDIZE procedure to obtain location and scale measures of your data.

In the following hypothetical data set, a random sample of grade 12 students is selected from a number of co-educational schools. Each school is classified as one of two types: Urban or Rural. There are 40 observations.

The variables are id (student identification), Type (type of school attended: `urban'=urban area and `rural'=rural area), and total (total assessment scores in History, Geometry, and Chemistry).

The following DATA step creates the SAS data set TotalScores.

   data TotalScores;
      title 'High School Scores Data';
      input id Type $  total;
      datalines;   
    1      rural        135 
    2      rural        125 
    3      rural        223 
    4      rural        224 
    5      rural        133 
    6      rural        253 
    7      rural        144 
    8      rural        193 
    9      rural        152 
   10      rural        178 
   11      rural        120 
   12      rural        180 
   13      rural        154 
   14      rural        184 
   15      rural        187 
   16      rural        111 
   17      rural        190 
   18      rural        128 
   19      rural        110 
   20      rural        217 
   21      urban        192 
   22      urban        186 
   23      urban         64 
   24      urban        159 
   25      urban        133 
   26      urban        163 
   27      urban        130 
   28      urban        163 
   29      urban        189 
   30      urban        144 
   31      urban        154 
   32      urban        198 
   33      urban        150 
   34      urban        151 
   35      urban        152 
   36      urban        151 
   37      urban        127 
   38      urban        167 
   39      urban        170 
   40      urban        123 
   ;
   run;

Suppose you would now like to standardize the total scores in different types of schools prior to any further analysis. Before standardizing the total scores, you can use the Schematic Plots from PROC UNIVARIATE to summarize the total scores for both types of schools.

   proc univariate data=TotalScores plot;
      var total;
      by Type;
   run;

The PLOT option in the PROC UNIVARIATE statement creates the Schematic Plots and several other types of plots. The Schematic Plots display side-by-side box plots for each BY group (Figure 59.1). The vertical axis represents the total scores, and the horizontal axis displays two box plots: the one on the left is for the rural scores and the one on the right is for the urban scores.

High School Scores Data

The UNIVARIATE Procedure
Schematic Plots

                          |                                                     
                      260 +                                                     
                          |            |                                        
                          |            |                                        
                          |            |                                        
                      240 +            |                                        
                          |            |                                        
                          |            |                                        
                          |            |                                        
                      220 +            |                                        
                          |            |                                        
                          |            |                                        
                          |            |                                        
                      200 +            |           |                            
                          |            |           |                            
                          |         +-----+        |                            
                          |         |     |        |                            
                      180 +         |     |        |                            
                          |         |     |        |                            
                          |         |     |     +-----+                         
                          |         *--+--*     |     |                         
                      160 +         |     |     |     |                         
                          |         |     |     *--+--*                         
                          |         |     |     |     |                         
                          |         |     |     |     |                         
                      140 +         |     |     +-----+                         
                          |         |     |        |                            
                          |         +-----+        |                            
                          |            |           |                            
                      120 +            |                                        
                          |            |                                        
                          |            |                                        
                          |                                                     
                      100 +                                                     
                          |                                                     
                          |                                                     
                          |                                                     
                       80 +                                                     
                          |                                                     
                          |                                                     
                          |                        0                            
                       60 +                                                     
                           ------------+-----------+-----------                 
                     Type             rural       urban                         

Figure 59.1: Schematic Plots from PROC UNIVARIATE

Inspection reveals that one urban score is a low outlier. Also, if you compare the lengths of two boxplots, there seems to be twice as much dispersion for the rural scores as for the urban scores.

High School Scores Data

The UNIVARIATE Procedure
Variable: total

Type=urban

Extreme Observations
Lowest Highest
Value Obs Value Obs
64 3 170 19
123 20 186 2
127 17 189 9
130 7 192 1
133 5 198 12

Figure 59.2: Table for Extreme Observations when Type=urban

Figure 59.2 displays the table from PROC UNIVARIATE for the lowest and highest five total scores for urban schools. The outlier (Obs = 3), marked in Figure 59.1 by the symbol `0', has a score of 64.

The following statements use the traditional standardization method (METHOD=STD) to compute the location and scale measures:

   proc stdize data=totalscores method=std pstat;
      title2 'METHOD=STD';
      var total;
      by Type;
   run;

High School Scores Data
METHOD=STD

The STDIZE Procedure

Type=rural

Location and Scale Measures
Location = mean Scale = standard deviation
Name Location Scale N
total 167.050000 41.956713 20

 


High School Scores Data
METHOD=STD

The STDIZE Procedure

Type=urban

Location and Scale Measures
Location = mean Scale = standard deviation
Name Location Scale N
total 153.300000 30.066768 20

Figure 59.3: Location and Scale Measures Table when METHOD=STD

Figure 59.3 displays the table of location and scale measures from the PROC STDIZE statement. PROC STDIZE uses the mean as the location measure and the standard deviation as the scale measure for standardizing. The PSTAT option displays this table; otherwise, no display is created.

The ratio of the scale of rural scores to the scale of urban scores is approximately 1.4 (41.96/30.07). This ratio is smaller than the dispersion ratio observed in the previous Schematic Plots.

The STDIZE procedure provides several location and scale measures that are resistant to outliers. The following statements invoke three different standardization methods and display the Location and Scale Measures tables:

   proc stdize data=totalscores method=mad pstat;
      title2 'METHOD=MAD';
      var total;
      by Type;
   run;

   proc stdize data=totalscores method=iqr pstat;
      title2 'METHOD=IQR';
      var total;
      by Type;
   run;

   proc stdize data=totalscores method=abw(4) pstat;
      title2 'METHOD=ABW(4)';
      var total;
      by Type;
   run;

The results from this analysis are displayed in the following figures.

High School Scores Data
METHOD=MAD

The STDIZE Procedure

Type=rural

Location and Scale Measures
Location = median Scale = median abs dev
from median
Name Location Scale N
total 166.000000 32.000000 20

 


High School Scores Data
METHOD=MAD

The STDIZE Procedure

Type=urban

Location and Scale Measures
Location = median Scale = median abs dev
from median
Name Location Scale N
total 153.000000 15.500000 20

Figure 59.4: Location and Scale Measures Table when METHOD=MAD

Figure 59.4 displays the table of location and scale measures when the standardization method is MAD. The location measure is the median, and the scale measure is the median absolute deviation from median. The ratio of the scale of rural scores to the scale of urban scores is approximately 2.06 (32.0/15.5) and is close to the dispersion ratio observed in the previous Schematic Plots.

High School Scores Data
METHOD=IQR

The STDIZE Procedure

Type=rural

Location and Scale Measures
Location = median Scale = interquartile
range
Name Location Scale N
total 166.000000 61.000000 20

 


High School Scores Data
METHOD=IQR

The STDIZE Procedure

Type=urban

Location and Scale Measures
Location = median Scale = interquartile
range
Name Location Scale N
total 153.000000 30.000000 20

Figure 59.5: Location and Scale Measures Table when METHOD=IQR

Figure 59.5 displays the table of location and scale measures when the standardization method is IQR. The location measure is the median, and the scale measure is the interquartile range. The ratio of the scale of rural scores to the scale of urban scores is approximately 2.03 (61/30) and is, in fact, the dispersion ratio observed in the previous Schematic Plots.

High School Scores Data
METHOD=ABW(4)

The STDIZE Procedure

Type=rural

Location and Scale Measures
Location = biweight 1-step M-estimate
Scale = biweight A-estimate
Name Location Scale N
total 162.889603 56.662855 20

 


High School Scores Data
METHOD=ABW(4)

The STDIZE Procedure

Type=urban

Location and Scale Measures
Location = biweight 1-step M-estimate
Scale = biweight A-estimate
Name Location Scale N
total 156.014608 28.615980 20

Figure 59.6: Location and Scale Measures Table when METHOD=ABW

Figure 59.6 displays the table of location and scale measures when the standardization method is ABW. The location measure is the biweight 1-step M-estimate, and the scale measure is the biweight A-estimate. Note that the initial estimate for ABW is MAD. The tuning constant (4) of ABW is obtained by the following steps:

  1. For rural scores, the location estimate for MAD is 166.0 and the scale estimate for MAD is 32.0. The maximum of the rural scores is 253 (not shown), and the minimum is 110 (not shown). Thus, the tuning constant needs to be 3 so that it does not reject any observation that has a score between 110 to 253.
  2. For urban scores, the location estimate for MAD is 153.0 and the scale estimate for MAD is 15.5. The maximum of the rural scores is 198, and the minimum (also an outlier) is 64. Thus, the tuning constant needs to be 4 so that it rejects the outlier (64) but includes the maximum (198) as an normal observation.
  3. The maximum of the tuning constants, obtained in steps 1 and 2, is 4.

Refer to Goodall (1983, Chapter 11) for details on the tuning constant. The ratio of the scale of rural scores to the scale of urban scores is approximately 2.06 (32.0/15.5). It is also close to the dispersion ratio observed in the previous Schematic Plots.

The preceding analysis shows that METHOD=MAD, METHOD=IQR, and METHOD=ABW all provide better dispersion ratios than does METHOD=STD.

You can recompute the standard deviation after deleting the outlier from the original data set for comparison. The following statements create a DATA set NoOutlier that excludes the outlier from the TotalScores data set and invoke PROC STDIZE with METHOD=STD.

   data NoOutlier;
      set totalscores;
      if (total = 64) then delete;
   run;
   
   proc stdize data=NoOutlier method=std pstat;
      title2 'after removing outlier, METHOD=STD';
      var total;
      by Type;
   run;

High School Scores Data
after removing outlier, METHOD=STD

The STDIZE Procedure

Type=rural

Location and Scale Measures
Location = mean Scale = standard deviation
Name Location Scale N
total 167.050000 41.956713 20

 


High School Scores Data
after removing outlier, METHOD=STD

The STDIZE Procedure

Type=urban

Location and Scale Measures
Location = mean Scale = standard deviation
Name Location Scale N
total 158.000000 22.088207 19

Figure 59.7: After Deleting the Outlier, Location and Scale Measures Table when METHOD=STD

Figure 59.7 displays the location and scale measures after deleting the outlier. The lack of resistance of the standard deviation to outliers is clearly illustrated: if you delete the outlier, the sample standard deviation of urban scores changes from 30.07 to 22.09. The new ratio of the scale of rural scores to the scale of urban scores is approximately 1.90 (41.96/22.09).

Chapter Contents
Chapter Contents
Previous
Previous
Next
Next
Top
Top

Copyright © 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.