CSPATIALREG Procedure
Example 13.6 Comparison of Multiple Models
Data Description and Objective
Example in this section uses the CrimeOH and CrimeWmat data sets that are described in Columbus Crime Data to demonstrate fitting and comparison of multiple models in PROC CSPATIALREG.
Comparison of Multiple Models
The following statements fit multiple models to the CrimeOH and CrimeWmat data sets, which are described in Columbus Crime Data, using the regressors Income and HValue:
/*-- TYPE=AUTO --*/
proc cspatialreg data=mylib.CrimeOH Wmat=mylib.CrimeWmat;
model crime=income hvalue / type=AUTO;
spatialid sid;
run;
In this example, the TYPE=AUTO option is specified in the MODEL statement to fit seven models—SAC, SARMA, SAR, SEM, SMA, CAR, and LINEAR. However, the CAR model is not fitted because the input spatial weights matrix is not symmetric. The parameter estimates for the six remaining models—SAC, SARMA, SAR, SEM, SMA, and LINEAR—are shown in Output 13.6.1. The comparison of these six models is provided in Output 13.6.2. If AIC is used for model comparison, Output 13.6.2 suggests that the SAR model is the best model among the six candidate models, because its AIC value is the smallest.
Output 13.6.1: Parameter Estimates of Multiple Models
| Parameter Estimates | ||||||
|---|---|---|---|---|---|---|
| Model Type | Parameter | DF | Estimate | Standard Error | t Value | Approx Pr > |t| |
| SAC | Intercept | 1 | 47.784032 | 9.279544 | 5.15 | <.0001 |
| income | 1 | -1.025892 | 0.334029 | -3.07 | 0.0021 | |
| hvalue | 1 | -0.281653 | 0.093369 | -3.02 | 0.0026 | |
| _rho | 1 | 0.368061 | 0.181191 | 2.03 | 0.0422 | |
| _lambda | 1 | 0.166684 | 0.298147 | 0.56 | 0.5761 | |
| _sigma2 | 1 | 95.603530 | 19.475445 | 4.91 | <.0001 | |
| SARMA | Intercept | 1 | 48.802582 | 9.537830 | 5.12 | <.0001 |
| income | 1 | -1.018561 | 0.334811 | -3.04 | 0.0023 | |
| hvalue | 1 | -0.286879 | 0.092709 | -3.09 | 0.0020 | |
| _rho | 1 | 0.341517 | 0.200492 | 1.70 | 0.0885 | |
| _lambda | 1 | -0.258955 | 0.416859 | -0.62 | 0.5345 | |
| _sigma2 | 1 | 96.762195 | 20.618634 | 4.69 | <.0001 | |
| SAR | Intercept | 1 | 45.079467 | 7.871241 | 5.73 | <.0001 |
| income | 1 | -1.031616 | 0.328416 | -3.14 | 0.0017 | |
| hvalue | 1 | -0.265927 | 0.088222 | -3.01 | 0.0026 | |
| _rho | 1 | 0.431018 | 0.123619 | 3.49 | 0.0005 | |
| _sigma2 | 1 | 95.494608 | 19.507896 | 4.90 | <.0001 | |
| SEM | Intercept | 1 | 59.914436 | 5.881216 | 10.19 | <.0001 |
| income | 1 | -0.942892 | 0.370508 | -2.54 | 0.0109 | |
| hvalue | 1 | -0.302218 | 0.090549 | -3.34 | 0.0008 | |
| _lambda | 1 | 0.560314 | 0.152809 | 3.67 | 0.0002 | |
| _sigma2 | 1 | 95.554137 | 20.025909 | 4.77 | <.0001 | |
| SMA | Intercept | 1 | 59.375752 | 5.872720 | 10.11 | <.0001 |
| income | 1 | -0.928794 | 0.361190 | -2.57 | 0.0101 | |
| hvalue | 1 | -0.288025 | 0.086456 | -3.33 | 0.0009 | |
| _lambda | 1 | -0.788372 | 0.273593 | -2.88 | 0.0040 | |
| _sigma2 | 1 | 115.685990 | 25.337065 | 4.57 | <.0001 | |
| LINEAR | Intercept | 1 | 68.618863 | 4.588210 | 14.96 | <.0001 |
| income | 1 | -1.597304 | 0.323739 | -4.93 | <.0001 | |
| hvalue | 1 | -0.273931 | 0.099989 | -2.74 | 0.0062 | |
| _sigma2 | 1 | 122.751696 | 24.799493 | 4.95 | <.0001 | |
Output 13.6.2: Comparison of Multiple Models
| Model Comparison | |||||||
|---|---|---|---|---|---|---|---|
| Model Type | Status | Reason | Number of Iterations | Max Abs Gradient | Log Likelihood | AIC | SBC |
| SAC | 0 | Convergence criterion (ABSGCONV=0.00001) satisfied. | 36 | 0.0000 | -182.4 | 376.8950 | 388.2459 |
| SARMA | 0 | Convergence criterion (FCONV=1E-8) satisfied. | 16 | 0.0445 | -182.4 | 376.8184 | 388.1693 |
| SAR | 0 | Convergence criterion (ABSGCONV=0.00001) satisfied. | 16 | 0.0000 | -182.6 | 375.1147* | 384.5738* |
| SEM | 0 | Convergence criterion (FCONV=1E-8) satisfied. | 35 | 0.0706 | -183.6 | 377.1833 | 386.6424 |
| SMA | 0 | Convergence criterion (FCONV=1E-8) satisfied. | 16 | 0.0255 | -183.5 | 376.9300 | 386.3891 |
| LINEAR | 0 | Convergence criterion (ABSGCONV=0.00001) satisfied. | 16 | 0.0000 | -187.4 | 382.7542 | 390.3215 |
| Asterisk (*) denotes the best model in the column. | |||||||