X13 Procedure

Example 45.7 MDLINFOIN= and MDLINFOOUT= Data Sets

(View the complete code for this example.)

This example illustrates the use of MDLINFOIN= and MDLINFOOUT= data sets. Using the data set shown, PROC X13 step identifies the model with outliers as displayed in Output 45.7.1. Output 45.7.2 shows the data set that represents the chosen model.

data b1;
   input y @@;
   datalines;
   112 118 132 129
   121 135 148 148
   136 119 104 118
   115 126 141 135
   125 149 270 170
   158 133 114 140
;
title 'Model Identification Output to MDLINFOOUT= Data Set';
proc x13 data=b1 start='1980q1' interval=qtr MdlInfoOut=mdl;
   automdl;
   outlier;
run ;
proc print data=mdl;
run;

Output 45.7.1: Displayed Model Identification with Outliers

Model Identification Output to MDLINFOOUT= Data Set

The X13 Procedure

Critical Values to use in Outlier
Detection
For Variable y
Begin1980Q1
End1985Q4
Observations24
MethodAdd One
AO Critical Value3.419415
LS Critical Value3.419415

Final Automatic Model Selection
For Variable y
Source of ModelOrders AlteredEstimated Model
Automatic Model ChoiceNo( 2,1,0)( 0,0,0)

Regression Model Parameter Estimates
For Variable y
TypeParameterNoEstEstimateStandard
Error
t ValuePr > |t|
Automatically IdentifiedAO 1984Q3Est102.365895.9658417.16<.0001

Exact ARMA Maximum Likelihood Estimation
For Variable y
ParameterLagEstimateStandard
Error
t ValuePr > |t|
Nonseasonal AR10.408920.202132.020.0554
 2-0.537100.20975-2.560.0178


Output 45.7.2: PROC X13 MDLINFOOUT= Data Set Model with Outlier Detection

Model Identification Output to MDLINFOOUT= Data Set

Obs_NAME__MODELTYPE__MODELPART__COMPONENT__PARMTYPE__DSVAR__VALUE__FACTOR__LAG__SHIFT__NOEST__EST__STDERR__TVALUE__PVALUE__STATUS__SCORE__LABEL_
1yREGEVENTSCALEAOAO01JUL1984D....0102.3665.9658417.15870.000000.  
2yARIMAFORECASTNONSEASONALDIFy..1.......  
3yARIMAFORECASTNONSEASONALARy.11.00.4090.202132.02310.055385.  
4yARIMAFORECASTNONSEASONALARy.12.0-0.5370.20975-2.56060.017830.  


Suppose that after examining the output from the preceding example, you decide that an Easter regressor should be added to the model. The following statements create a data set with the model identified above and adds a US Census Bureau Predefined Easter(25) regressor. The new model data set to be used as input in the MDLINFOIN= option is displayed in the data set shown in Output 45.7.3.

data pluseaster;
   _NAME_ = 'y';
   _MODELTYPE_ = 'REG';
   _MODELPART_ = 'PREDEFINED';
   _COMPONENT_ = 'SCALE';
   _PARMTYPE_ = 'EASTER';
   _DSVAR_ = 'EASTER';
   _VALUE_ = 25;
run;

data mdlpluseaster;
   set mdl;
run;

title 'Model with Easter(25) Regression Added';
proc append base=mdlpluseaster data=pluseaster force;
run;
proc print data=mdlpluseaster;
run;

Output 45.7.3: MDLINFOIN= Data Set Model with Easter(25) Regression Added

Model with Easter(25) Regression Added

Obs_NAME__MODELTYPE__MODELPART__COMPONENT__PARMTYPE__DSVAR__VALUE__FACTOR__LAG__SHIFT__NOEST__EST__STDERR__TVALUE__PVALUE__STATUS__SCORE__LABEL_
1yREGEVENTSCALEAOAO01JUL1984D....0102.3665.9658417.15870.000000.  
2yARIMAFORECASTNONSEASONALDIFy..1.......  
3yARIMAFORECASTNONSEASONALARy.11.00.4090.202132.02310.055385.  
4yARIMAFORECASTNONSEASONALARy.12.0-0.5370.20975-2.56060.017830.  
5yREGPREDEFINEDSCALEEASTEREASTER25.........  


The following statements estimate the regression and ARIMA parameters by using the model described in the new data set mdlpluseaster. The results of estimating the new model are shown in Output 45.7.4.

proc x13 data=b1 start='1980q1' interval=qtr
   MdlInfoIn=mdlpluseaster MdlInfoOut=mdl2;
   estimate;
run;

Output 45.7.4: Estimate Model with Added Easter(25) Regression

Model with Easter(25) Regression Added

The X13 Procedure

Regression Model Parameter Estimates
For Variable y
TypeParameterNoEstEstimateStandard
Error
t ValuePr > |t|
EasterEaster[25]Est6.732504.733351.420.1696
User DefinedAO01JUL1984DEst105.837956.1268917.27<.0001

Exact ARMA Maximum Likelihood Estimation
For Variable y
ParameterLagEstimateStandard
Error
t ValuePr > |t|
Nonseasonal AR10.452330.206762.190.0401
 2-0.548550.21583-2.540.0190


The new model estimation results are displayed in the data set mdl2 shown in Output 45.7.5.

proc print data=mdl2;
run;

Output 45.7.5: MDLINFOOUT= Data Set, Estimation of Model with Easter(25) Regression Added

Model with Easter(25) Regression Added

Obs_NAME__MODELTYPE__MODELPART__COMPONENT__PARMTYPE__DSVAR__VALUE__FACTOR__LAG__SHIFT__NOEST__EST__STDERR__TVALUE__PVALUE__STATUS__SCORE__LABEL_
1yREGPREDEFINEDSCALEEASTEREASTER25...06.7334.733351.42240.16961.  
2yREGEVENTSCALEAOAO01JUL1984D....0105.8386.1268917.27430.00000.  
3yARIMAFORECASTNONSEASONALDIFy..1.......  
4yARIMAFORECASTNONSEASONALARy.11.00.4520.206762.18770.04014.  
5yARIMAFORECASTNONSEASONALARy.12.0-0.5490.21583-2.54150.01899.  


Last updated: June 19, 2025