Chapter Contents
Chapter Contents
Previous
Previous
Next
Next
The SURVEYREG Procedure

Example 62.4: Stratified Sampling

This example illustrates the SURVEYREG procedure to perform a regression in a stratified sample design. Consider a population of 235 farms producing corn in the states of Nebraska and Iowa. You are interested in the relationship between corn yield (CornYield) and the total farm size (FarmArea).

Each state is divided into several regions, and each region is used as a stratum. Within each stratum, a simple random sample with replacement is drawn. A total of 19 farms is selected to the stratified simple random sample. The sample size and population size within each stratum are displayed in Table 62.3.

Table 62.3: Number of Farms in Each Stratum
      Number of Farms in
Stratum State Region Population Sample
1Iowa11003
2 2505
3 3153
4Nebraska1306
5 2402
 Total 23519

Three models are considered to represent the data:

Data from the stratified sample are saved in the SAS data set Farms.

   data Farms;
      input State $ Region FarmArea CornYield Weight; 
      datalines; 
   Iowa     1 100  54 33.333
   Iowa     1  83  25 33.333
   Iowa     1  25  10 33.333
   Iowa     2 120  83 10.000
   Iowa     2  50  35 10.000
   Iowa     2 110  65 10.000
   Iowa     2  60  35 10.000
   Iowa     2  45  20 10.000
   Iowa     3  23   5  5.000
   Iowa     3  10   8  5.000
   Iowa     3 350 125  5.000
   Nebraska 1 130  20  5.000
   Nebraska 1 245  25  5.000
   Nebraska 1 150  33  5.000
   Nebraska 1 263  50  5.000
   Nebraska 1 320  47  5.000
   Nebraska 1 204  25  5.000
   Nebraska 2  80  11 20.000
   Nebraska 2  48   8 20.000
   ;

In the data set Farms, the variable Weight represents the sampling weight. In this example, the sampling weight is proportional to the reciprocal of the sampling rate within each stratum from which a farm is selected. The information on population size in each stratum is saved in the SAS data set TotalInStrata.

   data TotalInStrata;
      input State $ Region _TOTAL_; 
      datalines;
   Iowa     1 100
   Iowa     2  50
   Iowa     3  15
   Nebraska 1  30
   Nebraska 2  40
   ;

Using the sample data from the data set Farms and the control information data from the data set TotalInStrata, you can fit Model I using PROC SURVEYREG.

   title1 'Analysis of Farm Area and Corn Yield';
   title2 'Model I: Same Intercept and Slope';
   proc surveyreg data=Farms total=TotalInStrata;
      strata State Region / list;
      model CornYield = FarmArea / covb;
      weight Weight;
   run;

Output 62.4.1: Data Summary and Stratum Information Fitting Model I
 
Analysis of Farm Area and Corn Yield
Model I: Same Intercept and Slope

The SURVEYREG Procedure
Regression Analysis for Dependent Variable CornYield

Data Summary
Number of Observations 19
Sum of Weights 234.99900
Weighted Mean of CornYield 31.56029
Weighted Sum of CornYield 7416.6
 
Design Summary
Number of Strata 5
 
Fit Statistics
R-square 0.3882
Root MSE 20.6422
Denominator DF 14
 
Stratum Information
Stratum
Index
State Region N Obs Population Total Sampling
Rate
1 Iowa 1 3 100 0.03
2   2 5 50 0.10
3   3 3 15 0.20
4 Nebraska 1 6 30 0.20
5   2 2 40 0.05

Output 62.4.1 displays the data summary and stratification information fitting Model I. The sampling rates are automatically computed by the procedure based on the sample sizes and the population totals in strata.

Output 62.4.2: Estimated Regression Coefficients and the Estimated Covariance Matrix
 
Analysis of Farm Area and Corn Yield
Model I: Same Intercept and Slope

The SURVEYREG Procedure
Regression Analysis for Dependent Variable CornYield

Tests of Model Effects
Effect Num DF F Value Pr > F
Model 1 21.74 0.0004
Intercept 1 4.93 0.0433
FarmArea 1 21.74 0.0004

NOTE: The denominator degrees of freedom for the F tests is 14.

 

Estimated Regression Coefficients
Parameter Estimate Standard Error t Value Pr > |t|
Intercept 11.8162978 5.31981027 2.22 0.0433
FarmArea 0.2126576 0.04560949 4.66 0.0004

NOTE: The denominator degrees of freedom for the t tests is 14.

 

Covariance of Estimated Regression Coefficients
  Intercept FarmArea
Intercept 28.300381277 -0.146471538
FarmArea -0.146471538 0.0020802259

Output 62.4.2 displays tests of model effects and the estimated regression coefficients and their covariance matrix.

Alternatively, you can assume that the linear relationship between corn yield (CornYield) and farm area (FarmArea) is different among the states. Therefore, you consider fitting Model II.

In order to analyze the data using Model II, you create auxiliary variables FarmAreaNE and FarmAreaIA to represent farm area in different states:

{{\hv FarmAreaNE}}=\{ {0 & {{\rm if the farm is from Iowa}} \ {{\hv FarmArea}} &
 {{\rm if the farm is from Nebraska}}
 } .
{{\hv FarmAreaIA}}=\{ {{{\hv FarmArea}} &
 {{\rm if the farm is from Iowa}} \ 0 & {{\rm if the farm is from Nebraska}}
 } .

The following statements create these variables in a new data set called FarmsByState and use PROC SURVEYREG to fit Model II.

   title1 'Analysis of Farm Area and Corn Yield';
   title2 'Model II: Same Intercept, Different Slopes';
   data FarmsByState; set Farms;
      if State='Iowa' then do;
         FarmAreaIA=FarmArea ; FarmAreaNE=0 ;
      end;
      else do;
         FarmAreaIA=0 ; FarmAreaNE=FarmArea;
      end;
   run;

The following statements perform the regression using the new data set FarmsByState. The analysis uses the auxilary variables FarmAreaIA and FarmAreaNE as the regressors.

   proc SURVEYREG data=FarmsByState total=TotalInStrata;
      strata State Region;
      model CornYield = FarmAreaIA FarmAreaNE / covb;
      weight Weight;
   run;

Output 62.4.3: Regression Results from Fitting Model II
 
Analysis of Farm Area and Corn Yield
Model II: Same Intercept, Different Slopes

The SURVEYREG Procedure
Regression Analysis for Dependent Variable CornYield

Data Summary
Number of Observations 19
Sum of Weights 234.99900
Weighted Mean of CornYield 31.56029
Weighted Sum of CornYield 7416.6
 
Design Summary
Number of Strata 5
 
Fit Statistics
R-square 0.8158
Root MSE 11.6759
Denominator DF 14
 
Estimated Regression Coefficients
Parameter Estimate Standard Error t Value Pr > |t|
Intercept 4.04234816 3.80934848 1.06 0.3066
FarmAreaIA 0.41696069 0.05971129 6.98 <.0001
FarmAreaNE 0.12851012 0.02495495 5.15 0.0001

NOTE: The denominator degrees of freedom for the t tests is 14.

 

Covariance of Estimated Regression Coefficients
  Intercept FarmAreaIA FarmAreaNE
Intercept 14.511135861 -0.118001232 -0.079908772
FarmAreaIA -0.118001232 0.0035654381 0.0006501109
FarmAreaNE -0.079908772 0.0006501109 0.0006227496

Output 62.4.3 displays the data summary, design information, fit summary, and parameter estimates and their covariance matrix. The estimated slope parameters for each state are quite different from the estimated slope in Model I. The results from the regression show that Model II fits these data better than Model I.

For Model III, different intercepts are used for the linear relationship in two states. The following statements illustrate the use of the NOINT option in the MODEL statement associated with the CLASS statement to fit Model III.

   title1 'Analysis of Farm Area and Corn Yield';
   title2 'Model III: Different Intercepts and Slopes';
   proc SURVEYREG data=FarmsByState total=TotalInStrata;
      strata State Region;
      class State;
      model CornYield = State FarmAreaIA FarmAreaNE 
         / noint covb solution;
      weight Weight;
   run;

The model statement includes the classification effect State as a regressor. Therefore, the parameter estimates for effect State will presents the intercepts in two states.

Output 62.4.4: Regression Results for Fitting Model III
 
Analysis of Farm Area and Corn Yield
Model III: Different Intercepts and Slopes

The SURVEYREG Procedure
Regression Analysis for Dependent Variable CornYield

Data Summary
Number of Observations 19
Sum of Weights 234.99900
Weighted Mean of CornYield 31.56029
Weighted Sum of CornYield 7416.6
 
Design Summary
Number of Strata 5
 
Fit Statistics
R-square 0.9300
Root MSE 11.9810
Denominator DF 14
 
Estimated Regression Coefficients
Parameter Estimate Standard Error t Value Pr > |t|
State Iowa 5.27797099 5.27170400 1.00 0.3337
State Nebraska 0.65275201 1.70031616 0.38 0.7068
FarmAreaIA 0.40680971 0.06458426 6.30 <.0001
FarmAreaNE 0.14630563 0.01997085 7.33 <.0001

NOTE: The denominator degrees of freedom for the t tests is 14.

 

Covariance of Estimated Regression Coefficients
  State Iowa State Nebraska FarmAreaIA FarmAreaNE
State Iowa 27.790863033 0 -0.205517205 0
State Nebraska 0 2.8910750385 0 -0.027354011
FarmAreaIA -0.205517205 0 0.0041711265 0
FarmAreaNE 0 -0.027354011 0 0.0003988349

Output 62.4.4 displays the regression results for fitting Model III, including the data summary, parameter estimates, and covariance matrix of the regression coefficients. The estimated covariance matrix shows a lack of correlation between the regression coefficients from different states. This suggests that Model III might be the best choice for building a model for farm area and corn yield in these two states.

However, some statistics remain the same under different regression models, for example, Weighted Mean of CornYield. These estimators do not rely on the particular model you use.

Chapter Contents
Chapter Contents
Previous
Previous
Next
Next
Top
Top

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