This example uses FCS methods to impute missing values in both continuous and CLASS variables in a data set with an arbitrary
missing pattern. The following statements invoke the MI procedure and impute missing values for the Fish3
data set:
proc mi data=Fish3 seed=1305417 out=outex7; class Species; fcs nbiter=10 discrim(Species/details) reg(Width/details); var Species Length Width; run;
The DISCRIM option uses the discriminant function method to impute the classification variable Species
, and the REG option uses the regression method to impute the continuous variable Height
. By default, the regression method is also used to impute other continuous variables, Length
and Width
.
The "Model Information" table in Output 63.7.1 describes the method and options used in the multiple imputation process.
The "FCS Model Specification" table in Output 63.7.2 describes methods and imputed variables in the imputation model. The procedure uses the discriminant function method to impute
the variable Species
, and the regression method to impute other variables.
The "Missing Data Patterns" table in Output 63.7.3 lists distinct missing data patterns with corresponding frequencies and percentages.
With the specified DETAILS option for variables Species
and Height
, parameters used in each imputation for these two variables are displayed in the "Group Means for FCS Discriminant Method"
table in Output 63.7.4 and in the "Regression Models for FCS Method" table in Output 63.7.5.
Output 63.7.4: FCS Discrim Model for Species
Group Means for FCS Discriminant Method | ||||||
---|---|---|---|---|---|---|
Species | Variable | Imputation | ||||
1 | 2 | 3 | 4 | 5 | ||
Parkki | Length | -0.268298 | -0.611484 | -0.430752 | -0.508489 | -1.096890 |
Parkki | Width | -0.374514 | -0.920031 | -0.695627 | -0.444730 | -1.183297 |
Perch | Length | 0.073272 | 0.281238 | 0.135766 | 0.105996 | 0.280959 |
Perch | Width | 0.104187 | 0.345404 | 0.211220 | 0.109806 | 0.365960 |
Roach | Length | -0.293847 | -0.296757 | -0.485885 | 0.094638 | -0.028394 |
Roach | Width | -0.507327 | -0.352964 | -0.626142 | -0.033285 | -0.243456 |
Output 63.7.5: FCS Regression Model for Height
Regression Models for FCS Method | |||||||
---|---|---|---|---|---|---|---|
Imputed Variable |
Effect | Species | Imputation | ||||
1 | 2 | 3 | 4 | 5 | |||
Width | Intercept | -0.080952 | -0.008262 | -0.040466 | -0.083230 | -0.047121 | |
Width | Species | Parkki | -0.100521 | -0.096675 | -0.022778 | -0.160418 | -0.092341 |
Width | Species | Perch | 0.150457 | 0.119791 | 0.108795 | 0.132785 | 0.152929 |
Width | Length | 0.928032 | 0.939600 | 1.039315 | 0.975903 | 0.961029 |
The following statements list the first 10 observations of the data set Outex7
in Output 63.7.6:
proc print data=outex7(obs=10); title 'First 10 Observations of the Imputed Data Set'; run;
Output 63.7.6: Imputed Data Set
First 10 Observations of the Imputed Data Set |
Obs | _Imputation_ | Species | Length | Width |
---|---|---|---|---|
1 | 1 | Roach | 16.2000 | 2.26800 |
2 | 1 | Roach | 20.3000 | 2.82170 |
3 | 1 | Roach | 21.2000 | 2.40895 |
4 | 1 | Roach | 18.6497 | 3.17460 |
5 | 1 | Roach | 22.2000 | 3.57420 |
6 | 1 | Roach | 22.8000 | 3.35160 |
7 | 1 | Roach | 23.1000 | 3.39570 |
8 | 1 | Perch | 23.7000 | 3.88340 |
9 | 1 | Roach | 24.7000 | 3.75440 |
10 | 1 | Roach | 24.3000 | 3.54780 |
After the completion of five imputations by default, the "Variance Information" table in Output 63.7.7 displays the between-imputation variance, within-imputation variance, and total variance for combining complete-data inferences for continuous variables. The relative increase in variance due to missingness, the fraction of missing information, and the relative efficiency for each variable are also displayed. These statistics are described in the section Combining Inferences from Multiply Imputed Data Sets.
The "Parameter Estimates" table in Output 63.7.8 displays a 95% mean confidence interval and a t statistic with its associated p-value for each of the hypotheses requested with the default MU0=0 option.