SAS Institute. The Power to Know

SAS/ETS(R) 9.2 User's Guide

Previous Page | Next Page

The X12 Procedure

OUTPUT Statement
OUTPUT OUT= SAS-data-set 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

If the OUT= option is omitted, the SAS System names the new data set by using the default DATAn convention.

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 Census Bureau X12-ARIMA software. Currently available tables are A1, A2, A6, A7, A8, A8AO, A8LS, A8TC, A9, A10, B1, C17, C20, D1, D7, D8, D9, D10, D10B, D10D, D11, D11A, D11F, D11R, D12, D13, D16, D16B, D18, E5, E6, E6A, E6R, E7, and MV1. If no table is specified, table A1 is output to the 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/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;

Note that 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 costs, while the table D11 values for sales are contained in the variable sales_D11, and the variable costs_D11 contains the table D11 values for costs. If necessary, the variable name is shortened so that the table name can be added. Currently, you cannot specify the output variable names. If DATE= is specified in the PROC X12 statement, then that variable is included in the output data set. Otherwise, a variable named _DATE_ is the date identifier.

Previous Page | Next Page | Top of Page