1.1 - 8.10 - VARMAX Syntax Elements - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)
TargetColumns
Specify the InputTable columns containing the response data. Null values are allowed at the end of the series. If you specify StepAhead, the function reports predicted values for the missing values, using values from the predictor columns for those time periods.
ExogenousColumns
[Optional] Specify the InputTable columns containing the exogenous (independent) predictors.
Default behavior: The function calculates the model without exogenous vectors.
PartitionColumns
[Optional] Specify the InputTable partition columns to pass to the output.
OrderP
[Required if you omit Orders table and PDQ, disallowed otherwise.] Specify the value of the nonseasonal parameter p for the VARMAX model, an INTEGER in the range [0, 10].
OrderD
[Required if you omit Orders table and PDQ, disallowed otherwise.] Specify the value of the nonseasonal parameter d for the VARMAX model, the INTEGER 0 or 1.
OrderQ
[Required if you omit Orders table and PDQ, disallowed otherwise.] Specify the value of the nonseasonal parameter q for the VARMAX model, an INTEGER in the range [0, 10].
PDQ
[Required if you omit Orders table and OrderP, OrderD, and OrderQ; disallowed otherwise.] Specify the parameters p, d, and q for the VARMA part of the model. These values must be in the ranges for OrderP, OrderD, and OrderQ, respectively.
SeasonalOrderP
[Optional if you omit Orders table and SeasonalPDQ, disallowed otherwise.] Specify the value of the seasonal parameter sp for the VARMAX model, an INTEGER in the range [0, 10].
SeasonalOrderD
[Optional if you omit Orders table and SeasonalPDQ, disallowed otherwise.] Specify the value of the seasonal parameter sd for the VARMAX model, an INTEGER in the range [0, 3].
SeasonalOrderQ
[Optional if you omit Orders table and SeasonalPDQ, disallowed otherwise.] Specify the value of the seasonal parameter sq for the VARMAX model, an INTEGER in the range [0, 10].
SeasonalPDQ
[Optional if you omit Orders table and SeasonalOrderP, SeasonalOrderD, and SeasonalOrderQ; disallowed otherwise.] Specify seasonal parameters sp, sd, and sq for the VARMA part of the model. These values must be in the ranges for SeasonalOrderP, SeasonalOrderD, and SeasonalOrderQ, respectively.
If you specify this syntax element, you must also specify the Period syntax element.
Default behavior: The function treats the model as nonseasonal.
Period
[Required if you specify SeasonalPDQ or SeasonalOrderP, SeasonalOrderD, and SeasonalOrderQ; disallowed otherwise.] Specify the period of each season. The period must be a positive INTEGER value.
Default behavior: The function treats the model as nonseasonal.
ExogenousOrder
[Optional] Specify the order of the exogenous variables. If the current time is t and ExogenousOrder is b, the following values of the exogenous time series are used in calculating the response: X t X t-1 ... X t-b+1.
Default behavior: The function calculates the model without exogenous vectors.
Lag
[Optional] Specify the lag in the effect of the exogenous variables on the response variables. For example, if lag is 3, and ExogenousOrder is b, the prediction Y i is based on X i-3 to X i-b-2.
Default: 0
IncludeMean
[Optional if you omit Orders table, disallowed otherwise.] Specify whether to add the mean vector of the response series in the VARMAX model.
If this syntax element is 'true', the values of the difference parameters d (in the PDQ syntax element) and sd (in the SeasonalPDQ syntax element) must be 0.
Default: 'false'
IncludeDrift
[Optional if you omit Orders table, disallowed otherwise.] Specify whether to add the drift term of the response series in the VARMAX model. The drift term applies only when d is 1.
IncludeDrift and IncludeMean cannot both be true. If either the syntax elements or order table specifies true for both IncludeDrift and IncludeMean, the function issues an error message.
Default: 'false'
MaxIterNum
[Optional] Specify the maximum number of iterations performed. The max_iteration_number must be a positive INTEGER value.
Default: 100
StepAhead
[Optional] Specify the number of steps to forecast after the end of the time series. The predict_steps must be a positive INTEGER value.
Default behavior: The function calculates no forecast values.
FitMethod
[Optional] Specify the method for fitting the model parameters:
Option Description
'SSE' (Default) Sum of squared error.
'ML' Maximum likelihood. This method is more accurate, but slower to calculate.