The X12 Procedure

OUTPUT Statement

  • OUTPUT OUT= SAS-data-set <YEARSEAS> tablename1 tablename2 …;

The OUTPUT statement creates an output data set that contains specified tables. The data set is named by the OUT= option.

OUT=SAS-data-set

names the data set to contain the specified tables. If the OUT= option is omitted, the data set is named using the default DATAn convention.

YEARSEAS
YRSEAS

specifies that two additional variables be added to the OUT= data set. The two additional variables are the variables _YEAR_ and _SEASON_. The variable _YEAR_ contains the year of the date identifying the observation. The variable _SEASON_ contains the month for monthly data, or quarter for quarterly data, of the date that identifies the observation. For monthly data, the value of _SEASON_ is between 1 and 12. For quarterly data, the value of _SEASON_ is between 1 and 4. The _YEAR_ and _SEASON_ variables are useful when creating seasonal plots.

tablename1 tablename2 …

For each table to be included in the output data set, you must specify the X12 tablename keyword. The keyword corresponds to the title label used by the U.S. Census Bureau X-12-ARIMA software. Currently available tables are A1, A2, A6, A7, A8, A8AO, A8LS, A8TC, A9, A10, A19, B1, C17, C20, D1, D7, D8, D9, D10, D10B, D10D, D11, D11A, D11F, D11R, D12, D13, D16, D16B, D18, E1, E2, E3, E5, E6, E6A, E6R, E7, E8, and MV1. If no table is specified in the OUTPUT statement, Table A1 is output to the OUT= data set by default.

The tablename keywords that can be used in the OUTPUT statement are listed in the section Displayed Output, ODS Table Names, and OUTPUT Tablename Keywords. The following is an example of a VAR statement and an OUTPUT statement:

   var sales costs;
   output out=out_x12  b1 d11;

The default variable name used in the output data set is the input variable name followed by an underscore and the corresponding table name. The variable sales_B1 contains the Table B1 values for the variable sales, the variable costs_B1 contains the Table B1 values for the variable costs, the variable sales_D11 contains the Table D11 values for the variable sales, and the variable costs_D11 contains the Table D11 values for the variable costs. If necessary, the variable name is shortened so that the table name can be added. If the DATE= variable is specified in the PROC X12 statement, then that variable is included in the output data set; otherwise, a variable named _DATE_ is written to the OUT= data set as the date identifier.