PROC X12: TRANSFORM Statement :: SAS/ETS(R) 9.22 User's Guide

The X12 Procedure

TRANSFORM Statement

TRANSFORM options ;

The TRANSFORM statement transforms or adjusts the series prior to estimating a regARIMA model. With this statement, the series can be Box-Cox (power) transformed. The "Prior Adjustment Factors" table is associated with the TRANSFORM statement.

Only one of the following options can appear in the TRANSFORM statement:

POWER=value

transforms the input series, $\text{[math]}$ , by using a Box-Cox power transformation,

$\text{[math]}$

The power $\text{[math]}$ must be specified (for example, POWER=0.33). The default is no transformation ( $\text{[math]}$ ), that is, POWER=1. The log transformation (POWER=0), square root transformation (POWER=0.5), and the inverse transformation (POWER=–1) are equivalent to the corresponding FUNCTION= option.

Table 34.4 Power Values Related to the Census Bureau Function Argument
FUNCTION=	Transformation	Range for $\text{[math]}$	Equivalent Power Argument
NONE	$\text{[math]}$	All values	POWER=1
LOG	$\text{[math]}$	$\text{[math]}$ for all $\text{[math]}$	POWER=0
SQRT	$\text{[math]}$	$\text{[math]}$ for all $\text{[math]}$	POWER=0.5
INVERSE	$\text{[math]}$	$\text{[math]}$ for all $\text{[math]}$	POWER=–1
LOGISTIC	$\text{[math]}$	$\text{[math]}$ for all $\text{[math]}$	No equivalent

FUNCTION=NONE

FUNCTION=LOG

FUNCTION=SQRT

FUNCTION=INVERSE

FUNCTION=LOGISTIC

FUNCTION=AUTO

specifies the transformation to be applied to the series prior to estimating a regARIMA model. The transformation used by FUNCTION=NONE, LOG, SQRT, INVERSE, and LOGISTIC is related to the POWER= option as shown in Table 34.4. FUNCTION=AUTO uses selection based on Akaike’s information criterion (AIC) to decide between a log transformation and no transformation. The default is FUNCTION=NONE.

However, the FUNCTION= and POWER= options are not completely equivalent. In some cases, using the FUNCTION= option causes the program to automatically select other options. For example, FUNCTION=NONE causes the default mode to be MODE=ADD in the X11 statement. Also, the choice of transformation invoked by the FUNCTION=AUTO option can impact the default mode of the X11 statement.

There are restrictions on the value used in the POWER= and FUNCTION= options when preadjustment factors for seasonal adjustment are generated from a regARIMA model. When seasonal adjustment is requested with the X11 statement, any value of the POWER option can be used for the purpose of forecasting the series with a regARIMA model. However, this is not the case when factors generated from the regression coefficients are used to adjust either the original series or the final seasonally adjusted series. In this case, the only accepted transformations are the log transformation, which can be specified as POWER=0 for multiplicative or log-additive seasonal adjustments, and no transformation, which can be specified as POWER=1 for additive seasonal adjustments. If no seasonal adjustment is performed, any POWER transformation can be used. The preceding restrictions also apply when FUNCTION=NONE and FUNCTION=LOG are specified.

Top of Page