Tabular Syntax: TEMPLATE Procedure | SAS 9.1 Output Delivery System Users Guide

PROC TEMPLATE ;

EDIT definition- path -1 <AS definition-path-2 > < / STORE= libref . template-store >;
- statements-and-attributes
- END ;

DEFINE COLUMN column-path < / STORE= libref . template-store >;
- statements-and-attributes
- END ;

DEFINE FOOTER footer-path < / STORE= libref . template-store >
- statements-and-attributes
- END ;

DEFINE HEADER definition- name ;
- statements-and-attributes
- END ;

DEFINE TABLE table-path </ STORE= libref . template-store >;
- statements-and-attributes
- END ;

The following table lists the statements that you use to add different features to your SAS tabular output.

Table 10.1: PROC TEMPLATE Statements
Task	Statement
Edit an existing definition for a table, column, header, or footer.	EDIT
Create a column definition.	DEFINE COLUMN
Create a footer definition.	DEFINE FOOTER
Create a header definition.	DEFINE HEADER
Create a table definition.	DEFINE TABLE

EDIT Statement

Edits an existing definition for a table, column, header, or footer

Requirement: An END statement must follow the EDIT statement, after all of the editing instructions.

Interaction: In some cases, you can use an EDIT statement inside a set of editing instructions.

When you edit a table definition, you can also edit one or more column, header, or footer definitions that are defined in the table.
When you edit a column definition, you can also edit one or more header definitions that are defined for that column.

Restriction: If you edit a definition that is a link, you break the link and create a separate definition.

Featured in: Example 1 on page 515

EDIT definition-path-1 < AS definition-path-2 > </ STORE= libref . template-store >;
- attribute-statements ;
- END ;

Required Arguments

definition-path-1

specifies a definition to edit. definition-path-1 consists of one or more names , separated by periods. Each name represents a directory in a template store. (A template store is a type of SAS file.)
Interaction: The STORE= option specifies a particular template store to read from and to write to.
Tip: You can determine what definitions a procedure or DATA step uses by submitting the ODS TRACE ON statement before you run the SAS program (see ODS TRACE Statement on page 197).

Options

AS definition-path-2

specifies the location in which to store the edited definition, where definition-path-2 consists of one or more names, separated by periods. Each name represents a directory in a template store. (A template store is a type of SAS file.) By default, PROC TEMPLATE writes the edited definition to the first template store that you can write to in the current path.
Default: If you do not specify AS definition-path-2 , PROC TEMPLATE writes the edited definition to definition-path-1 in the first template store that you can write to.
Restriction: If the current EDIT statement is inside a set of editing instructions, then you cannot use the AS definition-path-2 option.

STORE= libref . template-store

specifies the template store from which to read definition-path-1 and in which to store definition-path-2 .

Statements and Attributes

The EDIT statement supports the same statements and attributes as the DEFINE TABLE statements. For more information, see DEFINE TABLE Statement on page 410.

Editing an Existing Definition

There are two steps to follow when you edit an existing definition.

Open a copy of the specified file.

By default, PROC TEMPLATE looks for definition-path-1 in the list of template stores that is defined by the PATH statement (see PATH Statement on page 276). It opens a copy of the first definition path that it finds in a template store that has read access.
Save the modified file.

PROC TEMPLATE writes the modified definition to the first template store in the current path with update access. If you do not specify a second definition path to write to, then it uses definition-path-1 . Therefore, if you have update access to the template store from which you read definition-path-1 , then you actually modify the original definition. Otherwise , the modified file is written to a template store to which you do have update access.

If you do specify a second definition path, then PROC TEMPLATE writes the edited definition to the specified path in the first template store to which you have write access.

DEFINE COLUMN Statement

Creates a definition for a column

Requirement: An END statement must be the last statement in the definition.

Interaction: A column definition can include one or more header definitions.

See also: DEFINE HEADER Statement on page 395

Featured in: Example 3 on page 528 and Example 5 on page 539

DEFINE COLUMN column-path < / STORE= libref . template-store >;
- < column-attribute-1 ;< column-attribute-n ;>>
- CELLSTYLE expression-1 AS < style-element-name ><[ style-attribute-specification(s) ] > < , expression-n AS < style-element-name ><[ style-attribute-specification(s) ]>>;
- COMPUTE AS expression ;
- DEFINE HEADER definition-path ;
  - statements-and-attributes
  - END ;
- DYNAMIC variable-1 < text-1 > < variable-n < text-n >>;
- MVAR variable-1 < text-1 > < variable-n < text-n >>;
- NMVAR variable-1 < text-1 > < variable-n < text-n >>;
- NOTES text ;
- TRANSLATE expression-1 INTO expression-2 < , expression-n INTO expression-m >;
- END ;

Table 10.2: DEFINE COLUMN Statements
Task	Statement
Set one or more column attributes.	column-attributes
Set the style element of the cells in the column according to the values of the variables .	CELLSTYLE-AS
Compute values for a column that is not in the data component, ormodify the values ofa columnthat isin the data component.	COMPUTE AS
Create a definition for a column header. DEFINE HEADER Define a symbol that references a value that the data component supplies from the procedure or DATA step.	DYNAMIC
Define a symbol that references a macro variable. ODS will use the variable as a string. References to the macro variable are resolved when ODS binds the definition and the data component to produce an output object.	MVAR
Define a symbol that references a macro variable. ODS will convert the variable s value to a number (stored as a double) before using it. References to the macro variable are resolved when ODS binds the definition and the data component to produce an output object.	NMVAR
Provide information about the column.	NOTES
Translate the specified values to other values.	TRANSLATE-INTO
End the definition.	END

Required Arguments

column-path

specifies where to store the column definition. A column-path consists of one or more names, separated by periods. Each name represents a directory in a template store. (A template store is a type of SAS file.) PROC TEMPLATE writes the definition to the first template store that you can write to in the current path.

Restriction: If the definition is nested inside another definition, definition-path must be a single-level name because the nested definition is stored where the original definition is stored.

Restriction: If you want to reference the definition that you are creating from another definition, do not nest the definition inside another one. For example, if you want to reference a column definition from multiple tables, do not define the column inside a table definition.

Options

STORE= libref . template-store

specifies the template store in which to store the definition. If the template store does not exist, it is created.
Restriction: If the definition is nested inside another definition, you cannot use the STORE= option for the nested definition because it is stored where the original definition is stored.
Restriction: The STORE= option does not become part of the definition.

Column Attributes

This section lists all the attributes that you can use in a column definition. For all attributes that support a value of ON, the following forms are equivalent:

ATTRIBUTE-NAME  ATTRIBUTE-NAME=ON

For all of the attributes that support a value of variable , variable can be any variable that you declare in the column definition with the DYNAMIC, MVAR, or NMVAR statement. If the attribute is a boolean, then the value of variable should resolve to either true or false as shown in the following table:

Table 10.3: Boolean Values
True	False
ON	OFF
_ON_	_OFF_
1	0
TRUE	FALSE
YES	NO
_YES_	_NO_

Table 10.4: Column Attributes
Task	Attribute	Valid Destinations
Influence the appearance of the cells contents
Specify whether or not to suppress the value of a variable from one row to the next , if the value does not change based on the formatted value of the variable.	BLANK_DUPS	All except OUTPUT
Specify whether or not to suppress the value of a variable from one row to the next, if the value does not change based on the raw value of the variable.	BLANK_INTERNAL_DUPS	All except OUTPUT
Select the best format for a column of a table.	CHOOSE_FORMAT=	All
Specify whether or not to wrap the text in the current column.	FLOW	LISTING
Specify the format for the column.	FORMAT=	All
Specify the number of decimals for the column if it isn t specified with FORMAT= column attribute.	FORMAT_NDEC=	All
Specify the format width for the column if it isn t specified with FORMAT= column attribute.	FORMAT_WIDTH=	All
Supply a numeric value against which values in the column are compared to eliminate trivial values from printing.	FUZZ=	All except OUTPUT
Specify the horizontal justification of the format field within the column (and for the column header if the definition for the header does not include JUST=).	JUST=	All except OUTPUT
Specify whether to justify the format field within the column, or to justify the value within the column, without regard to the format field.	JUSTIFY	All destinations except LISTING behave as if JUSTIFY=ON.
When the text in the column uses more than one line, specify whether to try to divide the text equally among all lines or to maximize the amount of text in each line.	MAXIMIZE	LISTING
Specify whether ornot to draw a continuous line in the current column above the first table footer (or, if there is no table footer, below the last row of the column).	OVERLINE	LISTING
Specify whether or not to treat the text as preformatted text.	PREFORMATTED	HTML, MARKUP family, PRINTER family, and RTF
Specify whether or not to print the column.	PRINT	All except OUTPUT
Specify a separator character to append to each value in the column.	SEPARATOR=	LISTING
Specify the style element and style attributes to use for the column.	STYLE=	HTML, MARKUP family, PRINTER family, and RTF
Specify the split character for the data in the column.	TEXT_SPLIT=	All except OUTPUT
Specify whether or not to draw a continuous line in the current column below the column header (or, if there is no column header, above the first row of the column).	UNDERLINE=	LISTING
Specify the vertical justification for the column.	VJUST=	HTML, MARKUP family, PRINTER family, and RTF
Specify the width of the column in characters .	WIDTH=	LISTING
Specify the maximum width for this column.	WIDTH_MAX=	LISTING
Customize column headers
Specify the text for the column header.	HEADER=	All
Specify whether or not to print the column header.	PRINT_HEADERS	All except OUTPUT
Influence the relationship to other columns
Specify whether or not the column definition is generic; that is, whether or not it can be used by more than one variable.	GENERIC=	All except OUTPUT
Specify whether or not the column is an ID column.	ID	LISTING and PRINTER family
Specify whether or not to merge the current column with the column immediately to its right.	MERGE	All except OUTPUT
Specify whether or not to merge the current column with the column immediately to its left.	PRE_MERGE	All except OUTPUT
Specify the number of blank characters to leave between the current column and the column immediately to its left.	PRE_SPACE=	LISTING
Specify the number of blank characters to leave between the current column and the column immediately to its right.	SPACE=	LISTING
Influence the presentation of data panels
Influence the place at which ODS splits a table when it creates multiple data panels.	GLUE=	LISTING, PRINTER family, and RTF
Specify whether or not to delete the current column from the output object if doing so enables all the remaining columns to fit in the space that is provided without splitting the table into multiple data panels.	OPTIONAL	LISTING
Other column attributes
Specify which format to use if both a column definition and a datacomponent specifyaformat.	DATA_FORMAT_OVERRIDE	All
Specify the name of the column in the data component to associate with the current column.	DATANAME=	All
Specify which special characters in headers for generic columns are to be used as split characters.	DEF_SPLIT	All
Specify whether or not to include the column in an output data set.	DROP	OUTPUT
Specify a label for the column.	LABEL=	OUTPUT
Specify the column definition that the current definition inherits from.	PARENT=	All
Specify the name to use for the corresponding variable in an output data set.	VARNAME=	OUTPUT

BLANK_DUPS<=ON | OFF | variable >

specifies whether or not to suppress the value of a variable from one row to the next, if the value does not change based on the formatted value of the variable.
Default: OFF
Interaction: If the CLASSLEVELS= table attribute is in effect, ODS ignores BLANK_DUPS=ON when any value changes in a preceding column that is also marked with BLANK_DUPS=ON.
ODS Destinations: All except OUTPUT. Note that when the PRINTER destination suppresses the value of a variable, it also suppresses the horizontal rule above the blank cell .
Featured in: Example 5 on page 539

BLANK_INTERNAL_DUPS<=ON | OFF | variable >

specifies whether or not to suppress the value of a variable from one row to the next, if the value does not change based on the raw value of the variable.
Default: OFF
Interaction: If the CLASSLEVELS= table attribute is in effect, ODS ignores BLANK_INTERNAL_DUPS=ON when any value changes in a preceding column that is also marked with BLANK_INTERNAL_DUPS=ON.
ODS Destinations: All except OUTPUT. Note that when the PRINTER destination suppresses the value of a variable, it also suppresses the horizontal rule above the blank cell.

CHOOSE_FORMAT= COMPROMISE | MAX | MAX_ABS | MIN_MAX

selects a format based on the actual values in the column of the table.
Default: If you omit the CHOOSE_FORMAT column attribute, then the default format is either determined by the data component or by other attributes.
Restriction: CHOOSE_FORMAT is not supported for computed columns because those columns values are computed outside of the data object .
Tip: If you specify a small value for the FORMAT_WIDTH= option, then CHOOSE_FORMAT may create a dw.3 format.
ODS Destinations: All
See: For more information about column formats, see How Are Values in Table Columns Formatted? on page 514.
COMPROMISE
- looks at all of the values in the column and selects a good compromise format to work well for most values, but extreme values may shift to BEST format.
- Tip: FORMAT_NDEC=d specifies the precision in digits.
- Tip: The FORMAT_WIDTH= option suggests a maximum width. The actual format width may be smaller or it may be larger.

MAX
- selects a format based on the maximum value in the column. Values are all expected to be positive so no space is reserved for a minus sign.
- Default: By default, FORMAT_WIDTH=10 and FORMAT_NDEC= is ignored.

MAX_ABS
- selects a format based on the maximum absolute value in the column. The format reserves space for a minus sign whether it is needed or not.

MIN_MAX
- selects a format based on the minimum and maximum value in the column. The format reserves space for a minus sign only where it is actually needed.
- Interaction: If FORMAT_NDEC= d is specified, a maximum of d decimal places is used.

DATA_FORMAT_OVERRIDE<=ON | OFF | variable >

specifies which format to use if both a column definition and a data component specify a format.
Default: OFF
ODS Destinations: All
ON
- Uses the format in the data component.

OFF
- Uses the format in the column definition.

variable
- Uses the format of the specified variable.

DATANAME= column-name

specifies the name of the column in the data component to associate with the current column.
Default: By default, ODS associates the current column with a column of the same name in the data component.
ODS Destinations: All

DEF_SPLIT

specifies which special characters in headers for generic columns are to be used as split characters.
ODS Destinations: All

DROP<=ON | OFF | variable >

specifies whether or not to include the column in an output data set.
Default: OFF
ODS Destinations: OUTPUT

FLOW<=ON | OFF | variable >

specifies whether or not to wrap the text in the current column if it is too long to fit in the space that is provided.
Default: ON if the format width of the column is greater than the column width. OFF if the format width of the column is not greater than the column width.
See also: MAXIMIZE= on page 384
ODS Destinations: LISTING

Note: The HTML and PRINTER destinations always wrap the text if it is too long to fit in the space that is provided.

FORMAT= format-name < format-width < decimal-width >> | variable

specifies the format for the column.
Default: If you do not specify the FORMAT= , PROC TEMPLATE uses the format that the data component provides. If the data component does not provide a format, PROC TEMPLATE uses
- BEST8. for integers
- 12.3 for doubles
- the length of the variable for character variables.

Restriction: If you specify a format width for a numeric column, then its value cannot exceed 32.
ODS Destinations: All

FORMAT_NDEC= number | variable

specifies the number of decimals for the column.
Default: the decimal width that is specified with the FORMAT= column attribute.
Range: Number is a whole number from 0 to 32
Interaction: If you specify a decimal width using both the FORMAT= and the FORMAT_NDEC= attributes, then PROC TEMPLATE uses the width that you specify with the FORMAT= attribute.
ODS Destinations: All

FORMAT_WIDTH= positive-integer | variable

specifies the format width for the column.
Default: If you omit the column attribute FORMAT_WIDTH=, then the format specified in the FORMAT= attribute is used.
Range: 1 to 32 for numeric variables; operating system limit for character variables
Interaction: If you specify a format width using both the FORMAT= and the FORMAT_WIDTH= attributes, then PROC TEMPLATE uses the width that you specify with the FORMAT= attribute.
ODS Destinations: All

FUZZ= number | variable

supplies a numeric value against which values in the column are compared to eliminate trivial values from printing. A number whose absolute value is less than or equal to the FUZZ= value is printed as 0. However, the real value of the number is used in any computations based on that number.
Default: the smallest representable floating-point number on the computer that you are using
ODS Destinations: All except OUTPUT

GENERIC<=ON | OFF | variable >

specifies whether or not the column definition can be used by more than one column. Generic columns are useful in tables with many similar columns. For example, the table definitions for both PROC SQL and the DATA step define only two columns: one for character variables and one for numeric variables. When a program runs, it determines which column definition the data component should use for each column.
Default: OFF
ODS Destinations: All except OUTPUT
Featured in: Example 3 on page 528 and Example 5 on page 539

GLUE= integer | variable

Influences the places at which ODS splits a table when it creates multiple data panels. ODS creates multiple data panels from a table that is too wide to fit in the allotted space. The higher the value of GLUE= is, the less likely it is that ODS will split the table between the current column and the column to its right.
Default: 1
Range: -1 to 327
Tip: A value of -1 forces the table to split between the current column and the column to its right.
ODS Destinations: LISTING, PRINTER family, and RTF

HEADER= header-specification

specifies the text for the column header. header-specification can be one of the following:
text
- specifies the actual text of the header.
- Requirement: text must be enclosed by quotation marks.
header-name
- specifies the name of a header definition to use. You create a header definition with the DEFINE HEADER statement (see DEFINE HEADER Statement on page 395). If header-name is a single-level name, the header definition must occur within the current column definition.
variable
- specifies the name of a variable that you declare with the DYNAMIC, MVAR, or NMVAR statement. The value of the variable becomes the column header.

_LABEL_
- Uses the label that is specified in the data component for the column header.

Default: _LABEL_
Interaction: If you are using the OUTPUT destination, then the HEADER= attribute does not change the label of the variable in the data set. To change the label in the data set, you must use the LABEL= attribute.
Tip: The HEADER= option provides a simple way for you to specify the text of a column header. If you want to customize the header further, use the DEFINE HEADER statement with the appropriate header attributes. (See DEFINE HEADER Statement on page 395.)
Tip: You can use the split character in the text of the header to force the text to a new line.
See also: LABEL= on page 384 and TEXT_SPLIT= on page 387.
ODS Destinations: All
Featured in: Example 3 on page 528 and Example 1 on page 342

ID<=ON | OFF | variable >

specifies whether or not the column is an ID column. An ID column is repeated on each data panel. (ODS creates multiple data panels when a table is too wide to fit in the allotted space.)
Default: OFF
Tip: ODS treats all columns up to and including a column that is marked with ID=ON as ID columns.
ODS Destinations: LISTING and PRINTER family
Featured in: Example 3 on page 528

JUST= justification | variable

specifies the horizontal justification of the format field within the column (and of the header if the definition for the header does not include JUST=).
- justification can be one of the following:

LEFT
- specifies left justification.
- Alias: L

RIGHT
- specifies right justification.
- Alias: R

CENTER
- specifies center justification.
- Alias: C

Default: LEFT for columns that contain character values; RIGHT for columns that contain numeric values.
Interaction: For the Listing destination, ODS justifies the format field within the column width. At times, you may need to specify the JUSTIFY= attribute to get the results that you want. See the discussion of JUSTIFY= on page 384.
See also: FORMAT= on page 381 and WIDTH= on page 388.
Main discussion: How Are Values in Table Columns Justified? on page 512
ODS Destinations: All except OUTPUT
Featured in: Example 1 on page 515

JUSTIFY<=ON | OFF | variable >

specifies whether to justify the format field within the column or to justify the value within the column without regard to the format field.
Default: OFF
Interaction: JUSTIFY=ON can interfere with decimal alignment.
Tip: If you translate numeric data to character data, you may need to use JUSTIFY= to align the data.
Main discussion: How Are Values in Table Columns Justified? on page 512
Featured in: Example 5 on page 539

ODS Destinations: All destinations except LISTING behave as if JUSTIFY=ON

LABEL= text | variable

specifies a label for the column in the output data set.
Default: If you do not specify a label, ODS uses the label that is specified in the data component. If no label is specified in the data component, ODS uses the header for the column as the label.
ODS Destinations: OUTPUT
Tip: If the Output destination is open, LABEL= provides a label for the corresponding variable in the output data set. This label overrides any label that is specified in the data component.

MAXIMIZE<=O N | OFF | variable >

specifies whether to try to divide the text equally among all lines or to maximize the amount of text in each line when the text in the column uses more than one line. For example, if the text spans three lines, MAXIMIZE=ON might result in 45% of the text on the first line, 45% of the text on the second line, and 10% of the text on the third line. MAXIMIZE=OFF would result in 33% of the text on each line. MAXIMIZE=ON may write lines of text that vary greatly in length. MAXIMIZE=OFF may result in using less than the full column width.
Default: OFF
Interaction: This attribute is effective only if the column is defined with FLOW=ON (see the discussion of FLOW= on page 381).
ODS Destinations: LISTING

MERGE<=ON | OFF | variable >

specifies whether or not to merge the current column with the column immediately to its right. When you set MERGE=ON for the current column, the data in each row of the column is merged with the data in the same row of the next column. ODS applies the format, justification, spacing, and prespacing attributes to each column independently. Then, it concatenates the columns. Finally, it applies to the concatenated data all the remaining attributes that are specified on the column that does not have MERGE= set.
Default: OFF
Restriction: You cannot use both MERGE=ON and PRE_MERGE=ON in the same column definition. You cannot merge or premerge a column with another column that has either MERGE=ON or PRE_MERGE=ON. Note that you can merge three columns by setting MERGE=ON for the first column, no merge or premerge attributes for the second column, and PRE_MERGE=ON for the third column.
See also: PRE_MERGE= on page 385
ODS Destinations: All except OUTPUT

OPTIONAL<=ON | OFF | variable >

specifies whether or not to delete the current column from the output object if doing so enables all the remaining columns to fit in the space that is provided without splitting the table into multiple data panels.
Default: OFF
Interaction: If multiple column definitions contain OPTIONAL=ON, PROC TEMPLATE includes either all or none of these columns in the output object.
ODS Destinations: LISTING

OVERLINE<=ON | OFF | variable >

specifies whether or not to draw a continuous line in the current column above the first table footer (or, if there is no table footer, below the last row of the column). PROC TEMPLATE uses the second formatting character to draw the line. (See the discussion of FORMCHAR= on page 417.)
Default: OFF
ODS Destinations: LISTING

PARENT= column-path

specifies the column definition that the current definition inherits from. A column-path consists of one or more names, separated by periods. Each name represents a directory in a template store. (A template store is a type of SAS file.) The current definition inherits from the specified column in the first template store that you can read from in the current path.

When you specify a parent, all the attributes and statements that are specified in the parent s definition are used in the current definition unless the current definition specifically overrides them.
ODS Destinations: All

PREFORMATTED<=ON | OFF | variable >

specifies whether or not to treat the text as preformatted text. When text is preformatted, ODS honors line breaks as well as leading, trailing, and internal spaces. It also displays the text in a monospace font.
Default: OFF
Interaction: When PREFORMATTED=ON, ODS uses the datafixed style element unless you specify another style element with the STYLE= column attribute.
ODS Destinations: HTML, MARKUP family, PRINTER family, and RTF

PRE_MERGE<=ON | OFF | variable >

specifies whether or not to merge the current column with the column immediately to its left. When you set PRE_MERGE=ON for the current column, the data in each row of the column is merged with the data in the same row of the previous column. ODS applies the format, justification, spacing, and prespacing attributes to each column independently. Then, it concatenates the columns. Finally, it applies to the concatenated data all the remaining attributes that are specified on the column that does not have PRE_MERGE= set.
Default: OFF
Restriction: You cannot use both MERGE=ON and PRE_MERGE=ON in the same column definition. You cannot merge or premerge a column with another column that has either MERGE=ON or PRE_MERGE=ON. Note that you can merge three columns by setting MERGE=ON for the first column, no merge or premerge attributes for the second column, and PRE_MERGE=ON for the third column.
See also: MERGE= on page 384
ODS Destinations: All except OUTPUT

PRE_SPACE= non-negative-integer

specifies the number of blank characters to leave between the current column and the column immediately to its left.
Default: A value in the range that is bounded by the COL_SPACE_MIN and COL_SPACE_MAX table attributes.
Interaction: If PRE_SPACE= and SPACE= are specified for the same intercolumn space, ODS honors PRE_SPACE=.
See also: SPACE= on page 386, COL_SPACE_MIN= on page 416, and COL_SPACE_MAX= on page 416
ODS Destinations: LISTING

PRINT<=ON | OFF | variable >

specifies whether or not to print the column.
Default: ON
See also: OPTIONAL= on page 385 and DROP= on page 381
ODS Destinations: All except OUTPUT

PRINT_HEADERS<=ON | OFF | variable >

specifies whether or not to print the column header and any underlining and overlining.
Default: ON
See also: UNDERLINE= on page 387 and OVERLINE= on page 385
ODS Destinations: All except OUTPUT

SEPARATOR= character | variable

specifies a separator character to append to each value in the column.
Default: None
Restriction: The SEPARATOR= column attribute is valid only for character variables.
Tip: To specify a hexadecimal character as the separator character, put an x after the closing quote. For example, the following option assigns the hexadecimal character 2D as the separator character: separator= 2D x
ODS Destinations: LISTING

SPACE= positive-integer | variable

specifies the number of blank characters to leave between the current column and the column immediately to its right.
Default: A value in the range that is bounded by the COL_SPACE_MIN and COL_SPACE_MAX table attributes.
Interaction: If PRE_SPACE= and SPACE= are specified for the same intercolumn space, ODS honors PRE_SPACE=.
See also: PRE_SPACE= on page 386, COL_SPACE_MIN= on page 416, and COL_SPACE_MAX= on page 416
ODS Destinations: LISTING

STYLE=< style-element-name ><[ style-attribute-specification(s) ]>

specifies the style element and any changes to its attributes to use for the current column. Neither style-attribute-specification nor style-element-name is required. However, you must use at least one of them.

Note: You can use braces ({ and }) instead of square brackets ([ and ]).

style-element-name
- is the name of the style element to use to display the data in the column. The style element must be part of a style definition that is registered with the Output Delivery System. SAS provides some style definitions. You can create your own style definitions with PROC TEMPLATE (see DEFINE STYLE Statement on page 288). By default, ODS displays different parts of ODS output with different style elements. For example, by default, the data in a column is displayed with the style element data . The style elements that you would be most likely to use with the STYLE= column attribute are
  - data
  - datafixed
  - dataempty
  - dataemphasis
  - dataemphasisfixed
  - datastrong
  - datastrongfixed.
- The style element provides the basis for displaying the column. Additional style attributes that you provide can modify the display.
- For information on viewing a style definition so that you can see the style elements that are available, see Viewing the Contents of a Style Definition on page 319. For information about the default style definition that ODS uses, see The Default Style Definition for HTML and Markup Languages on page 320.
  
  style-element-name can be either the name of a style element or a variable whose value is a style element.
- Default: data

style-attribute-specification
- describes the style attribute to change. Each style-attribute-specification has this general form:
  - style-attribute-name = style-attribute-value
- For information on the style attributes that you can specify, see Style Attributes and Their Values on page 292.

ODS Destinations: HTML, MARKUP family, PRINTER family, and RTF
Featured in: Example 3 on page 528
Tip: If you use the STYLE= attribute inside a quoted string, then you must add a space before or after the carriage return to prevent errors. SAS does not interpret a carriage return as a space. You must explicitly specify spaces in your quoted strings.

TEXT_SPLIT= character | variable

specifies the split character for the data in the column. PROC TEMPLATE breaks a value in the column when it reaches that character and continues the value on the next line. The split character itself is not part of the data and does not appear in the column.
Default: None
ODS Destinations: All except OUTPUT

UNDERLINE<=ON | OFF | variable >

specifies whether or not to draw a continuous line in the current column below the column header (or, if there is no column header, above the first row of the column). PROC TEMPLATE uses the second formatting character to draw the line.
Default: OFF
Main discussion: See the discussion of FORMCHAR= on page 417.
ODS Destinations: LISTING

VARNAME= variable-name | variable

specifies the name to use for the corresponding variable in an output data set.
Default: If you do not specify VARNAME=, PROC TEMPLATE uses the value of the DATANAME= attribute. If you do not specify DATANAME=, PROC TEMPLATE uses the name of the column.
Tip: If you use VARNAME= to specify the same name for different columns, a number is appended to the name each time that the name is used.
ODS Destinations: OUTPUT

VJUST= justification | variable

Specifies the vertical justification for the column. justification can be one of the following:
TOP
- places the first line of text as high as possible.
- Alias: T

CENTER
- centers the text vertically.
- Alias: C

BOTTOM
- places the last line of text as low as possible.
- Alias: B

Default: TOP for the Printer destination; CENTER for the HTML destination
ODS Destinations: HTML, MARKUP family, PRINTER family, and RTF
Featured in: Example 3 on page 528

WIDTH= positive-integer | variable

specifies the width of the column in characters.
Default: If you do not specify a width, PROC TEMPLATE uses the format width. If the column has no format associated with it, PROC TEMPLATE uses a width of
- 8 for integers
- 12 for doubles
- data length for character variables.

Interaction: The length of the column header can influence the width of the column.
See also: WIDTH_MAX on page 388 and WIDTH= on page 406.
ODS Destinations: LISTING

WIDTH_MAX= positive-integer | variable

specifies the maximum width allowed for this column. By default, PROC TEMPLATE extends the width of the column if the header is wider than the data. The width of the column can be anywhere between the values of WIDTH= and WIDTH_MAX=.
Default: the width of the format for the column
ODS Destinations: LISTING

CELLSTYLE-AS Statement

Sets the style element of the cells in the column according to the values of the variables. Use this statement to set the presentation characteristics (such as foreground color , font face, flyover) of individual cells

Featured in: Example 5 on page 539

CELLSTYLE expression-1 AS < style-element-name ><[ style-attribute-specification(s) ] >< , expression-n AS < style-element-name ><[ style-attribute-specification(s) ]>>;

Required Arguments

expression

is an expression that is evaluated for each cell in the column. It can be any expression that is valid in the WHERE statement (or the WHERE= data set option). For information on expressions that you can use in the WHERE statement, see Statements in SAS Language Reference: Dictionary . Use _VAL_ to represent the value of the current column. You may also reference symbols that you declared in a DYNAMIC, MVAR, or NMVAR statement in the definition.

If expression resolves to TRUE (a non-zero value), the style element that is specified is used for the current cell. If expression is FALSE (zero), the next expression in the statement is evaluated. Thus, you can string multiple expressions together to format cells conditionally.
Restriction: You can not reference the values of other columns in expression .
Tip: Using an expression of 1 as the last expression in the CELLSTYLE-AS statement sets the style element for any cells that did not meet an earlier condition.

Options

Note: Neither style-attribute-specification nor style-element-name is required. However, you must use at least one of them.

style-attribute-specification

describes a style attribute to set. Each style-attribute-specification has this general form:
- style-attribute-name = style-attribute-value

For information on the style attributes that you can set in a column definition, see Style Attributes and Their Values on page 292.
Default: If you don t specify any style attributes to modify, ODS uses the unmodified style-element-name .

style-element-name

is the name of the style element that is used to display the data in the column. The style element must be part of a style definition that is registered with the Output Delivery System. SAS provides some style definitions. You can create your own style definitions by using PROC TEMPLATE (see DEFINE STYLE Statement on page 288). By default, ODS displays different parts of ODS output with different style elements. For example, by default, the data in a column is displayed with the style element data . The style elements that you would be most likely to use with the CELLSTYLE-AS statement in a column definition are the following.
- data
- datafixed
- dataempty
- dataemphasis
- dataemphasisfixed
- datastrong
- datastrongfixed.

The style element provides the basis for displaying the column. Additional style attributes that you provide can modify the display.
Default: data
See also: Viewing the Contents of a Style Definition on page 319.
See also: The Default Style Definition for HTML and Markup Languages on page 320.

COMPUTE AS Statement

Computes values for a column that is not in the data component, or modifies the values of a column that is in the data component

COMPUTE AS expression ;

Required Arguments

expression

is an expression that assigns a value to each table cell in the column. It can be any expression that is valid in the WHERE statement (or the WHERE= data set option). For information on expressions that you can use in the WHERE statement, see Statements in SAS Language Reference: Dictionary .

To reference another column in a COMPUTE-AS statement, use the name of the column. You can also reference symbols that you declared in a DYNAMIC, MVAR, or NMVAR statement in the current definition. In addition, if the column has values in the data component, you can reference the column itself in the expression. However, if you are creating a column that does not exist in the data component, you cannot reference the column in the expression because there is no underlying value to use.

For example, the following DEFINE COLUMN block defines a column that contains the square root of the value in the column called source :
```
define column sqroot;     compute as sqrt(source);     header='Square Root';     format=6.4;  end; 
```
Tip: The COMPUTE AS statement can alter values in an output object. None of the definitions that SAS provides modifies any values. If you want to determine if a definition was provided by SAS, use the ODS VERIFY Statement on page 205. If the definition is not from SAS, the ODS VERIFY statement returns a warning when it runs the SAS program that uses the definition. If you receive such a warning, you can use the SOURCE statement to look at the definition and determine if the COMPUTE AS statement is used to alter values. (See SOURCE Statement on page 277.)
Tip: Because you can use column names in expression , _VAL_ is not recognized as an alias for the current column.

DEFINE HEADER Statement

Creates a definition for a header inside a column definition

Main discussion: DEFINE HEADER Statement on page 395

DEFINE HEADER definition-name ;

statements-and-attributes
END ;

Required Arguments

definition-name

specifies the name of the new header.
Restriction: definition-name must be a single-level name.
- Note: If you want to reference the header definition that you are creating from another definition, you must create it outside the column definition.

statements-and-attributes

specify the statements and header attributes that you can use to define a header inside a column.
See: DEFINE HEADER Statement on page 395

DYNAMIC Statement

Defines a symbol that references a value that the data component supplies from the procedure or DATA step

Scope: You can use the DYNAMIC statement in the definition of a table, column, header, or footer. A dynamic variable that is defined in a definition is available to that definition and to all the definitions that it contains.

Featured in: Example 1 on page 342 and Example 2 on page 348

DYNAMIC variable-1 < text-1 > < variable-n < text-n >>;

Required Arguments

variable

Names a variable that the data component supplies. ODS resolves the value of the variable when it binds the definition and the data component.
Tip: Dynamic variables are most useful to the authors of SAS procedures and to DATA step programmers.

Options

text

is text that you can place in the definition to explain the dynamic variable s use. Text of this type becomes part of the compiled definition, which you can view with the SOURCE statement, whereas SAS comments do not.

MVAR Statement

Defines a symbol that references a macro variable. ODS will use the value of the variable as a string. References to the macro variable are resolved when ODS binds the definition and the data component to produce an output object

Scope: You can use the MVAR statement in the definition of a table, column, header, or footer. A macro variable that is defined in a definition is available to that definition and to all the definitions that it contains.

Featured in: Example 3 on page 528 and Example 1 on page 342

MVAR variable-1 < text-1 > < variable-n < text-n >>;

Required Arguments

variable

Names a macro variable to reference in the definition. ODS will use the value of the macro variable as a string. ODS does not resolve the value of the macro variable until it binds the definition and the data component.
Tip: You must declare macro variables this way in a definition. For example, to use the automatic macro variable SYSDATE9 in a definition, declare it in an MVAR statement and reference it as SYSDATE9, without an ampersand, in your PROC TEMPLATE step. If you use the ampersand, the macro variable resolves when the definition is compiled instead of when ODS binds the definition to the data component.

Options

text

is text that you can place in the definition to explain the macro variable s use. Text of this type becomes part of the compiled definition, which you can view with the SOURCE statement, whereas SAS comments do not.

NMVAR Statement

Defines a symbol that references a macro variable. ODS will convert the variable s value to a number (stored as a double) before using it. References to the macro variable are resolved when ODS binds the definition and the data component to produce an output object

Scope: You can use the NMVAR statement in the definition of a table, column, header, or footer. A macro variable that is defined in a definition is available to that definition and to all the definitions that it contains.

Featured in: Example 5 on page 539

NMVAR variable-1 < text-1 > < variable-n < text-n >>;

Required Arguments

variable

Names a macro variable to reference in the definition. ODS will convert the variable s value to a number (stored as a double) before using it. ODS does not resolve the macro variable until it binds the definition and the data component.
Tip: You must declare macro variables this way in a definition. For example, to use a macro variable as a number, declare it in an NMVAR statement and reference it without an ampersand. If you use the ampersand, the macro variable resolves when the definition is compiled instead of when ODS binds the definition to the data component.

Options

text

is text that you can place in the definition to explain the macro variable s use. Text of this type becomes part of the compiled definition, which you can view with the SOURCE statement, whereas SAS comments do not.

NOTES Statement

Provides information about the column

Tip: The NOTES statement becomes part of the compiled column definition, which you can view with the SOURCE statement, whereas SAS comments do not.

NOTES text ;

Required Arguments

text

provides information about the column.

TRANSLATE-INTO Statement

Translates the specified values to other values

TRANSLATE expression-1 INTO expression-2 < , expression-n INTO expression-m >;

Required Arguments

expression-1

is an expression that is evaluated for each table cell in the column. It can be any expression that is valid in the WHERE statement (or the WHERE= data set option). For information on expressions that you can use in the WHERE statement, see Statements in SAS Language Reference: Dictionary . Use _VAL_ to represent the value of the current column. You may also reference symbols that you declared in a DYNAMIC, MVAR, or NVAR statement in the table definition.

If expression-1 resolves to TRUE (a non-zero value), the translation that is specified is used for the current cell. If expression-1 is FALSE (zero), the next expression in the statement is evaluated. Thus, you can string multiple expressions together to format cells conditionally.
Restriction: You may not reference the values of other columns in expression-1 .
Tip: Using an expression of 1 as the last expression in the TRANSLATE “INTO statement specifies a translation for any cells that did not meet an earlier condition.

expression-2

is an expression that specifies the value to use in the cell in place of the variable s actual value. It can be any expression that is valid in the WHERE statement (or the WHERE= data set option). For information on expressions that you can use in the WHERE statement, see Statements in SAS Language Reference: Dictionary . Use _VAL_ to represent the value of the current column. You may also reference symbols that you declared in a DYNAMIC, MVAR, or NVAR statement in the table definition.
Restriction: expression-2 must resolve to a character value, not a numeric value.
Restriction: You may not reference the values of other columns in expression-2 .
Tip: When you translate a numeric value to a character value, the column definition does not try to apply the numeric format that is associated with the column. Instead, it simply writes the character value into the format field, starting at the left. If you want the value to be right-justified, use the JUSTIFY=ON attribute.
See also: JUSTIFY= on page 384.

END Statement

Ends the definition

END ;

DEFINE FOOTER Statement

Creates a definition for a table footer

Requirement: An END statement must be the last statement in the definition.

Featured in: Example 3 on page 528 and Example 1 on page 342

See: DEFINE HEADER Statement on page 395

DEFINE FOOTER footer-path < / STORE= libref . template-store >;
- < footer-attribute-1 ;< footer-attribute-n ;>>
- DYNAMIC variable-1 < text-1 > < variable-n < text-n >>;
- MVAR variable-1 < text-1 > < variable-n < text-n >>;
- NMVAR variable-1 < text-1 > < variable-n < text-n >>;
- NOTES text ;
- TEXT footer-specification ;
- TEXT2 footer-specification ;
- TEXT3 footer-specification ;
- END ;

The substatements in DEFINE FOOTER and the footer attributes are the same as the substatements in DEFINE HEADER and the header attributes. For details about substatements and footer attributes, see DEFINE HEADER Statement on page 395.

DEFINE HEADER Statement

Creates a definition for a table header

Requirement: An END statement must be the last statement in the definition.

Featured in: Example 3 on page 528

DEFINE HEADER header-path </ STORE= libref . template-store >;
- < header-attribute-1 ;< header-attribute-n ;>>
- DYNAMIC variable-1 < text-1 > < variable-n < text-n >>;
- MVAR variable-1 < text-1 > < variable-n < text-n >>;
- NMVAR variable-1 < text-1 > < variable-n < text-n >>;
- NOTES text ;
- TEXT header-specification ;
- TEXT2 header-specification ;
- TEXT3 header-specification ;
- END ;

Table 10.5: DEFINE HEADER Statements
Task	Statement
Set one or more header attributes.	header-attribute(s)
Define a symbol that references a value that the data component supplies from the procedure or DATA step.	DYNAMIC
Define a symbol that references a macro variable. ODS will use the value of the variable as a string. References to the macro variable are resolved when ODS binds the definition and the data component to produce an output object.	MVAR
Define a symbol that references a macro variable. ODS will convert the variable s value to a number (stored as a double) before using it. References to the macro variable are resolved when ODS binds the definition and the data component to produce an output object.	NMVAR
Provide information about the table.	NOTES
Specify the text of the header.	TEXT
Specify an alternative header to use in the listing output if the header that is provided by the TEXT statement is too long.	TEXT2
Specify an alternative header to use in the Listing output if the header that is provided by the TEXT2 statement is too long.	TEXT3
End the header definition.	END

Required Arguments

header-path

specifies where to store the header definition. A header-path consists of one or more names, separated by periods. Each name represents a directory in a template store. (A template store is a type of SAS file.) PROC TEMPLATE writes the definition to the first template store that you can write to in the current path.
Restriction: If the definition is nested inside of another definition, definition-path must be a single-level name.
Restriction: If you want to reference the definition that you are creating from another definition, then do not nest the definition inside another definition. For example, if you want to reference a header definition from multiple columns, do not define the header inside a column definition.

Options

STORE= libref . template-store

specifies the template store in which to store the definition. If the template store does not exist, it is created.
Restriction: If the definition is nested inside another definition, you cannot use the STORE= option for the nested definition because it is stored where the original definition is stored.
Restriction: The STORE= option does not become part of the definition.

Header Attributes

This section lists all the attributes that you can use in a header definition. A column header spans a single column. A spanning header spans multiple columns. These two kinds of headers are defined in the same way except that a spanning header uses the START= or the END= attribute, or both.

For all attributes that support a value of ON, the following forms are equivalent:

ATTRIBUTE-NAME  ATTRIBUTE-NAME=ON

For all of the attributes that support a value of variable , variable can be any variable that you declare in the table definition with the DYNAMIC, MVAR, or NMVAR statement. If the attribute is a boolean, then the value of variable should resolve to either true or false as shown in the following table:

Table 10.6: Boolean Values
True	False
ON	OFF
_ON_	_OFF_
TRUE	FALSE
YES	NO
_YES_	_NO_

Table 10.7: Header Attributes
Task	Attribute	Valid Destinations
Influence the appearance of the contents of the header
Specifythatspecialcharactersin headers for generic columns are to be used as split characters.	DEF_SPLIT	All
Specify whether or not to try to expand the column width to accommodate the longest word in the column header.	FORCE	LISTING
Specify the horizontal justification for the column header.	JUST=	All except OUTPUT
Specify whether to try to divide the text equally among all lines or to maximize the amount of text in each line when the text in the header uses more than one line.	MAXIMIZE	LISTING
Specify whether or not to draw a continuous line above the header.	OVERLINE	LISTING
Specify whether or not to treat the text as preformatted text.	PREFORMATTED	HTML, MARKUP family, PRINTER family, and RTF
Specify whether or not to print the header.	PRINT	All
Specify the number of blank lines to place between the current header and the next header or between the current footer and the previous footer.	SPACE=	LISTING
Specify the split character for the header.	SPLIT=	All except OUTPUT
Specify the style element and any changes to its attributes to use for the header.	STYLE=	HTML, PRINTER family, and RTF
Specify whether or not to start a new header line in the middle of a word.	TRUNCATE	LISTING
Specify whether or not to draw a continuous line underneath the header.	UNDERLINE	LISTING
Specify vertical justification for the header.	VJUST=	HTML, MARKUP family, PRINTER, family, and RTF
Specify the width of the header in characters.	WIDTH=	LISTING
Influence the content of the header
Specify a character to use to expand the header to fill the space over the column or columns that the header spans.	EXPAND=	LISTING
Specify whether or not to repeat the text of the header until the space that is allotted for the header is filled.	REPEAT	LISTING
Influence the placementof theheader
Specify the last column that a spanning header covers.	END=	All except OUTPUT
Specify the first column that a spanning header covers.	START=	All except OUTPUT
Specify whether or not to expand the header to reach the sides of the page.	EXPAND_PAGE	LISTING
Specify whether or not a spanning header appears only on the first data panel if the table is too wide to fit in the space that is provided.	FIRST_PANEL	LISTING, PRINTER family, and RTF
Specify whether or not a table footer appears only on the last data panel if the table is too wide to fit in the space that is provided.	LAST_PANEL	LISTING, PRINTER family, and RTF
Specify whether or not to extend the text of the header into the header space of adjacent columns.	SPILL_ADJ	LISTING
Specify whether or not to extend the text of the header into the adjacent margin.	SPILL_MARGIN	LISTING
Other header attributes
Specify an abbreviation for the header. ^[*]	ABBR=	MARKUP
Specify an acronym for the header. ^[*]	ACRONYM=	MARKUP
Specify an alternate description for the header. ^[*]	ALT=	MARKUP
Specify whether or not multiple columns can use the header.	GENERIC	All except OUTPUT
Specify a long description for the header. ^[*]	LONGDESC=	MARKUP
Specify the header definition that the current definition inherits from.	PARENT=	All
^[*] SAS includes these accessibility and compatibility features that improve the usability of SAS for users with disabilities . These features are related to accessibility standards for electronic information technology adopted by the U.S. Government under Section 508 of the U.S. Rehabilitation Act of 1973, as amended.

ABBR= text

specifies an abbreviation for the header.
Requirement: The text must be enclosed with quotation marks.
ODS Destinations: MARKUP

Note: SAS includes this accessibility and compatibility feature that improves the usability of SAS for users with disabilities. This feature is related to accessibility standards for electronic information technology adopted by the U.S. Government under Section 508 of the U.S. Rehabilitation Act of 1973, as amended.

ACRONYM= text

specifies an acronym for the header.
Requirement: The text must be enclosed with quotation marks.
ODS Destinations: MARKUP

Note: SAS includes this accessibility and compatibility feature that improves the usability of SAS for users with disabilities. This feature is related to accessibility standards for electronic information technology adopted by the U.S. Government under Section 508 of the U.S. Rehabilitation Act of 1973, as amended.

ALT= text

specifies an alternate description of the header.
Requirement: The text must be enclosed with quotation marks.
ODS Destinations: MARKUP

Note: SAS includes this accessibility and compatibility feature that improves the usability of SAS for users with disabilities. This feature is related to accessibility standards for electronic information technology adopted by the U.S. Government under Section 508 of the U.S. Rehabilitation Act of 1973, as amended.

DEF_SPLIT

specifies which special characters in headers for generic columns are to be used as split characters.
ODS Destinations: All

END= column-name | variable

specifies the last column that a spanning header covers.
Default: the last column
See also: START= on page 404
ODS Destinations: All except OUTPUT

EXPAND= string | variable

specifies a character to use to expand the header to fill the space over the column or columns that the header spans.
Default: none
Interaction: If you specify both the REPEAT=ON and EXPAND=ON attributes, then PROC TEMPLATE uses the EXPAND= attribute.
See also: REPEAT= on page 403

Tip: If the string or the variable that you specify contains more than one character, then PROC TEMPLATE uses only the first character.
See also: EXPAND_PAGE= on page 401
ODS Destinations: LISTING

EXPAND_PAGE<= ON | OFF | variable >

specifies whether or not to expand the header to reach the sides of the page.
Default: OFF
See also: EXPAND= on page 400
ODS Destinations: LISTING

FIRST_PANEL<= ON | OFF | variable >

specifies whether or not a spanning header appears only on the first data panel if the table is too wide to fit in the space that is provided.
Default: OFF
Restriction: Applies only to headers, not to footers
See also: LAST_PANEL= on page 402
ODS Destinations: LISTING, PRINTER family, and RTF

FORCE<= ON | OFF | variable >

specifies whether or not to try to expand the column width to accommodate the longest word in the column header. The column width can be anything between the values for the WIDTH= and WIDTH_MAX= column attributes.
Default: ON
See also: WIDTH= on page 406 and WIDTH_MAX= on page 388
ODS Destinations: LISTING

GENERIC<= ON | OFF | variable >

specifies whether or not multiple columns can use the header.
Default: OFF
Restriction: This attribute is primarily for writers of SAS procedures and for DATA step programmers.
ODS Destinations: All except OUTPUT

JUST= justification | variable

specifies the horizontal justification for the column header, where justification can be one of the following:
LEFT
- specifies left justification.
- Alias: L

RIGHT
- specifies right justification.
- Alias: R

CENTER
- specifies center justification.
- Alias: C

Default: The justification for the column
ODS Destinations: All except OUTPUT
Featured in: Example 1 on page 515

LAST_PANEL<= ON | OFF | variable >

specifies whether or not a table footer appears only on the last data panel if the table is too wide to fit in the space that is provided.
Default: OFF
Restriction: Applies only to footers, not to headers
See also: FIRST_PANEL on page 401
ODS Destinations: LISTING, PRINTER family, and RTF

LONGDESC= string

specifies the long description of the header.
Requirement: The text must be enclosed with quotation marks.
ODS Destinations: MARKUP

Note: SAS includes this accessibility and compatibility feature that improves the usability of SAS for users with disabilities. This feature is related to accessibility standards for electronic information technology adopted by the U.S. Government under Section 508 of the U.S. Rehabilitation Act of 1973, as amended.

MAXIMIZE<=ON | OFF | variable >

specifies whether to try to divide the text equally among all lines or to maximize the amount of text in each line when the text in the header uses more than one line. For example, if the text spans three lines, MAXIMIZE=ON might result in 45% of the text on the first line, 45% of the text on the second line, and 10% of the text on the third line. MAXIMIZE=OFF would may result in 33% of the text on each line. MAXIMIZE=ON may write lines of text that vary greatly in length. MAXIMIZE=OFF may result in using less than the full column width.
Default: OFF
ODS Destinations: LISTING

OVERLINE<=ON | OFF | variable >

specifies whether or not to draw a continuous line above the header. PROC TEMPLATE uses the second formatting character to draw the line. (See the discussion of FORMCHAR= on page 417.)
Default: OFF
ODS Destinations: LISTING

PARENT= header-path

specifies the header definition that the current definition inherits from. A header-path consists of one or more names, separated by periods. Each name represents a directory in a template store. (A template store is a type of SAS file.) The current definition inherits from the specified header definition in the first template store that you can read from in the current path.

When you specify a parent, all of the attributes and statements that are specified in the parent s definition are used in the current definition unless the current definition specifically overrides them.
ODS Destinations: All

PREFORMATTED<=ON | OFF | variable >

specifies whether or not to treat the text as preformatted text. When text is preformatted, ODS honors line breaks as well as leading, trailing, and internal spaces. It also displays the text in a monospace font.
Default: OFF
Interaction: When PREFORMATTED=ON, and you are defining a table header or a footer, ODS uses the headerfixed or the footerfixed style element unless you specify another style element with the STYLE= column attribute.
- When PREFORMATTED=ON, and you are defining a column header, ODS uses the rowheaderfixed style element unless you specify another style element with the STYLE= column attribute.
ODS Destinations: HTML, MARKUP family, PRINTER family, and RTF

PRINT<=ON | OFF | variable >

specifies whether or not to print the header.
Default: ON
Tip: When PRINT=ON, the column header becomes the label of the corresponding variable in any output data sets that the Output Destination creates if neither the column definition nor the data component provides a label.
ODS Destinations: All

REPEAT<=ON | OFF | variable >

specifies whether or not to repeat the text of the header until the space that is allotted for the header is filled.
Default: OFF
Interaction: If you specify both the REPEAT=ON and EXPAND=ON attributes, then PROC TEMPLATE uses the EXPAND= attribute.
See also: EXPAND= on page 400
ODS Destinations: LISTING

SPACE= positive-integer | variable

specifies the number of blank lines to place between the current header and the next header or between the current footer and the previous footer.
Default: 0
Tip: A row of underlining or overlining is considered a header or a footer.
ODS Destinations: LISTING
Featured in: Example 3 on page 528

SPILL_ADJ<=ON | OFF | variable >

specifies whether or not to extend the text of the header into the header space of adjacent columns.
Default: OFF
Interaction: FORCE=, SPILL_MARGIN=, SPILL_ADJ=, and TRUNCATE= are mutually exclusive. If you specify more than one of these attributes, then PROC TEMPLATE uses only one of these attributes. FORCE= takes precedence over the other three attributes, followed by SPILL_MARGIN=, SPILL_ADJ=, and TRUNCATE=.
See also: FORCE= on page 401, SPILL_MARGIN= on page 403, and TRUNCATE= on page 405
ODS Destinations: LISTING

SPILL_MARGIN<=ON | OFF | variable >

specifies whether or not to extend the text of the header into the adjacent margin.
Default: ON
Restriction: SPILL_MARGIN= applies only to a spanning header that spans all the columns in a data panel.
Interaction: FORCE=, SPILL_MARGIN=, SPILL_ADJ=, and TRUNCATE= attributes are mutually exclusive. If you specify more than one of these attributes, then PROC TEMPLATE uses only one of these attributes. FORCE= takes precedence over the other three attributes, followed by SPILL_MARGIN=, SPILL_ADJ=, and TRUNCATE=.
See also: FORCE= on page 401, SPILL_ADJ on page 403, and TRUNCATE= on page 405
ODS Destinations: LISTING

SPLIT= character | variable

specifies the split character for the header. PROC TEMPLATE starts a new line when it reaches that character and continues the header on the next line. The split character itself is not part of the header although each occurrence of the split character counts toward the maximum length for a label.
Tip: The first character in a header is automatically treated as a split character if it is not one of the following:
- an alphanumeric character
- a blank
- an underscore (_)
- a hyphen (-).

ODS Destinations: All except OUTPUT

START= column-name | variable

specifies the first column that a spanning header covers.
Default: the first column
See also: END= on page 400
ODS Destinations: All except OUTPUT

STYLE=< style-element-name ><[ style-attribute-specification(s) ]>

specifies the style element and any changes to its attributes to use for the header.
Requirement: The STYLE= option requires either a style-attribute-specification or a style-element-name .
Tip: You can use braces ({ and }) instead of square brackets ([ and ]).
Tip: If you use the STYLE= attribute inside a quoted string, then you must add a space before or after the carriage return to prevent errors. SAS does not interpret a carriage return as a space. You must explicitly specify spaces in your quoted strings.

style-element-name
- is the name of the style element to use to produce the header. The style element must be part of a style definition that is registered with the Output Delivery System. SAS provides some style definitions. You can create your own style definitions by using PROC TEMPLATE (see DEFINE STYLE Statement on page 288). By default, ODS produces different parts of ODS output with different elements. For example, by default, a table header is displayed with the style element header . The style elements that you would be most likely to use with the STYLE= attribute for a table header are as follows :
  - header
  - headerfixed
  - headerempty
  - headeremphasis
  - headeremphasisfixed
  - headerstrong
  - headerstrongfixed
- The style elements that you would be most likely to use with the STYLE= attribute for a table footer are as follows:
  - footer
  - footerfixed
  - footerempty
  - footeremphasis
  - footeremphasisfixed
  - footerstrong
  - footerstrongfixed
- The style elements that you would be most likely to use with the STYLE= attribute for a column header are as follows:
  - rowheader
  - rowheaderfixed
  - rowheaderempty
  - rowheaderemphasis
  - rowheaderemphasisfixed
  - rowheaderstrong
  - rowheaderstrongfixed
- The style element provides the basis for displaying the header. Additional style attributes that you provide can modify the display.
- style-element-name can be either the name of a style element or a variable whose value is a style element.
- Default: header
- See also: Viewing the Contents of a Style Definition on page 319.
- See also: The Default Style Definition for HTML and Markup Languages on page 320.

style-attribute-specification
- describes the style attribute to change. Each style-attribute-specification has this general form:
  - style-attribute-name = style-attribute-value
- ODS destinations: HTML, PRINTER family, and RTF
- Featured in: Example 1 on page 515 and Example 3 on page 528
- See also: Style Attributes and Their Values on page 292

TRUNCATE<=ON | OFF | variable >

specifies whether or not to start a new header line in the middle of a word.
ON
- starts a new line of the header when the text fills the specified column width.

OFF
- extends the width of the column to accommodate the longest word in the column header, if possible.
  
  Note: TRUNCATE=OFF is the same as FORCE=ON.

Default: OFF
Interaction: If you specify FORCE=, SPILL_MARGIN=, or SPILL_ADJ=, then the TRUNCATE= attribute is ignored.
See also: FORCE= on page 401, SPILL_MARGIN= on page 403, and SPILL_ADJ= on page 403
ODS Destinations: LISTING

UNDERLINE<=ON | OFF | variable >

specifies whether or not to draw a continuous line below the header. PROC TEMPLATE uses the second formatting character to draw the line.
Default: OFF
Main discussion: See the discussion of FORMCHAR= on page 417.
ODS Destinations: LISTING

VJUST= justification | variable

Specifies vertical justification for the header. justification can be one of the following:
TOP
- places the header as high as possible.
- Alias: T

CENTER
- centers the header vertically.
- Alias: C

BOTTOM
- places the header as low as possible.
- Alias: B

Default: BOTTOM
ODS Destinations: HTML and PRINTER family

WIDTH= positive-integer | variable

specifies the width of the header in characters.
Default: If you do not specify a width, PROC TEMPLATE uses the column width.
Tip: If you want a vertical header, specify a width of 1.
ODS Destinations: LISTING

DYNAMIC Statement

Defines a symbol that references a value that the data component supplies from the procedure or DATA step

Featured in: Example 1 on page 342 and Example 2 on page 348

DYNAMIC variable-1 < text-1 > < variable-n < text-n >>;

Required Arguments

variable

Names a variable that the data component supplies. ODS resolves the value of the variable when it binds the definition and the data component.
Tip: Dynamic variables are most useful to the authors of SAS procedures and to DATA step programmers.

Options

text

is text that you can place in the definition to explain the dynamic variable s use. Text of this type becomes part of the compiled definition, which you can view with the SOURCE statement, whereas SAS comments do not.

MVAR Statement

Featured in: Example 3 on page 528 and Example 1 on page 342

MVAR variable-1 < text-1 > < variable-n < text-n >>;

Required Arguments

variable

Names a macro variable to reference in the definition. ODS will use the value of the macro variable as a string. ODS does not resolve the value of the macro variable until it binds the definition and the data component.
Tip: You must declare macro variables this way in a definition. For example, to use the automatic macro variable SYSDATE9 in a definition, declare it in an MVAR statement and reference it as SYSDATE9, without an ampersand, in your PROC TEMPLATE step. If you use the ampersand, the macro variable resolves when the definition is compiled instead of when ODS binds the definition to the data component.

Options

text

is text that you can place in the definition to explain the macro variable s use. Text of this type becomes part of the compiled definition, which you can view with the SOURCE statement, whereas SAS comments do not.

NMVAR Statement

Featured in: Example 5 on page 539

NMVAR variable-1 < text-1 > < variable-n < text-n >>;

Required Arguments

variable

Names a macro variable to reference in the definition. ODS will convert the variable s value to a number (stored as a double) before using it. ODS does not resolve the macro variable until it binds the definition and the data component.
Tip: You must declare macro variables this way in a definition. For example, to use a macro variable as a number, declare it in an NMVAR statement and reference it without an ampersand. If you use the ampersand, the macro variable resolves when the definition is compiled instead of when ODS binds the definition to the data component.

Options

text

is text that you can place in the definition to explain the macro variable s use. Text of this type becomes part of the compiled definition, which you can view with the SOURCE statement, whereas SAS comments do not.

NOTES Statement

Provides information about the header

Tip: The NOTES statement becomes part of the compiled header definition, which you can view with the SOURCE statement, whereas SAS comments do not.

NOTES text ;

Required Arguments

text

provides information about the header.

TEXT Statement

Specifies the text of the header or the label of a variable in an output data set

Featured in: Example 3 on page 528

TEXT header-specification(s) ;

Required Arguments

header-specification(s)

specifies the text of the header. Each header-specification can be one of the following:
_LABEL_
- uses the label of the object that the header applies to as the text of the header. For example, if the header is for a column, _LABEL_ specifies the label for the variable that is associated with the column. If the header is for a table, _LABEL_ specifies the label for the data set that is associated with the table.

text-specification(s)
- specifies the text to use in the header. Each text-specification can be one of the following:
  - a quoted string
  - a variable, followed by an optional format. The variable can be any variable that is declared in a DYNAMIC, MVAR, or NMVAR statement.
- Note: If the first character in a quoted string is neither a blank character nor an alphanumeric character, and SPLIT is not in effect, the TEXT statement treats that character as the split character. (See the discussion of SPLIT= on page 404.)
- Default: If you do not use a TEXT statement, the text of the header is the label of the object that the header applies to.
- Tip: If the quoted string is a blank and it is the only item in the header specification, the header is a blank line.
- Featured in: Example 3 on page 528

TEXT2 Statement

Provides an alternative header to use in the Listing output if the header that is provided by the TEXT statement is too long

See: TEXT Statement on page 409

TEXT3 Statement

Provides an alternative header to use in the Listing output if the header that is provided by the TEXT2 statement is too long

See: TEXT Statement on page 409

DEFINE TABLE Statement

Creates a table definition

Requirement: An END statement must be the last statement in the definition.

Interaction: A table definition can contain one or more column, header, or footer definitions.

Featured in: Example 3 on page 528 and Example 5 on page 539

DEFINE TABLE table-path </ STORE= libref . template-store >;
- < table-attribute-1 ;< table-attribute-n ;>>
- CELLSTYLE expression-1 AS < style-element-name ><[ style-attribute-specification(s) ] >< , expression-n AS < style-element-name ><[ style-attribute-specification(s) ]>>;
- COLUMN column(s) ;
- DEFINE definition-type definition-name </ option(s) >; statements-and-attributes
  - END ;
- DYNAMIC variable-1 < text-1 > < variable-n < text-n >>;
- FOOTER footer-name(s) ;
- HEADER header-name(s) ;
- MVAR variable-1 < text-1 > < variable-n < text-n >>;
- NMVAR variable-1 < text-1 > < variable-n < text-n >>;
- NOTES text ;
- TRANSLATE expression-1 INTO expression-2 < , expression-n INTO expression-m ;>
- END ;

Table 10.8: DEFINE TABLE Statements
Task	Statement
Set one or more table attributes.	table-attribute(s)
Set the style element of the cells in the table that contain numeric variables according to the values of the variables.	CELLSTYLE-AS
Declare a symbol as a column in the table and specify the order of the columns.	COLUMN
Create a definition for a column, header, or footer.	DEFINE
Define a symbol that references a value that the data component supplies from the procedure or DATA step.	DYNAMIC
Declare a symbol as a footer in the table and specify the order of the footers.	FOOTER
Declare a symbol as a header in the table and specify the order of the headers.	HEADER
Define a symbol that references a macro variable. ODS will use the value of the variable as a string. References to the macro variable are resolved when ODS binds the definition and the data component to produce an output object.	MVAR
Define a symbol that references a macro variable. ODS will convert the value of the variable to a number (stored as a double) before use. References to the macro variable are resolved when ODS binds the definition and the data component to produce an output object.	NMVAR
Provide information about the table.	NOTES
Translatethe specifiednumericvaluestoother values.	TRANSLATE-INTO
End a definition, or end the editing of a definition.	END

Required Arguments

table-path

specifies where to store the table definition. A table-path consists of one or more names, separated by periods. Each name represents a directory in a template store. (A template store is a type of SAS file.) PROC TEMPLATE writes the definition to the first template store in the current path that you can write to.

Options

STORE= libref . template-store

specifies the template store in which to store the definition. If the template store does not exist, it is created.
Restriction: The STORE= option does not become part of the definition.

Table Attributes

This section lists all the attributes that you can use in a table definition. For all attributes that support a value of ON, the following forms are equivalent:

ATTRIBUTE-NAME  ATTRIBUTE-NAME=ON

Table 10.9: Boolean Values
True	False
ON	OFF
_ON_	_OFF_
1	0
TRUE	FALSE
YES	NO
_YES_	_NO_

Table 10.10: Table Attributes
Task	Attribute	Valid Destinations
Influence the layout of the table.
Specify whether or not to try to place the same number of columns in each data panel if the entire table does not fit in one data panel.	BALANCE	LISTING, PRINTER family, and RTF
Specify whether or not to center each data panel independently if the entire table does not fit in one data panel.	CENTER	LISTING, PRINTER family, RTF
Specify whether or not to force a new page before printing the table.	NEWPAGE	All except OUTPUT
Specify the number of sets of columns to place on a page.	PANELS=	LISTING and PRINTER family
Specify the number of blank characters to place between sets of columns when PANELS= is in effect.	PANEL_SPACE=	LISTING
Specify the number of lines that must be available on the page in order to print the body of the table.	REQUIRED_SPACE=	LISTING and PRINTER family
Specify the number of lines to place between the previous output object and the current one.	TOP_SPACE=	LISTING and PRINTER family
Specify whether or not to split a table that is too wide to fit in the space that is provided or to wrap each row of the table.	WRAP	LISTING and PRINTER family
Specify whether or not to add a double space after the last line of a single row when the row is wrapped.	WRAP_SPACE	LISTING and PRINTER family
Influence the layout of rows and columns.
Specify the maximum number of blank characters to place between columns.	COL_SPACE_MAX=	LISTING
Specify the minimum number of blank characters to place between columns.	COL_SPACE_MIN=	LISTING
Specify the name of the column whose value provides formatting information about the space before each row of the definition.	CONTROL=	All except OUTPUT
Specify whether or not to double space between the rows of the table.	DOUBLE_SPACE	LISTING
Specify whether or not extra space is evenly divided among all columns of the table.	EVEN	LISTING
Specify whether or not to split a long stacked column across page boundaries.	SPLIT_STACK	LISTING
Influence the display of the values in header cells and data cells.
Specify whether or not to suppress blanking the value in a column that is marked with the BLANK_DUPS column attribute if the value changes in a previous column that is also marked with the BLANK_DUPS attribute.	CLASSLEVELS=	LISTING and PRINTER family
Task Attribute Valid Destinations Specify which format to use if both a column definition and a data componentspecifyaformat.	DATA_FORMAT_OVERRIDE	All
Specify whether to justify the format fields within the columns or to justify the values within the columns without regard to the format fields.	JUSTIFY	LISTING
Specify whether or not to order the columns by their order in the data component.	ORDER_DATA	All except OUTPUT
Specify the source of the values for the format width and the decimal width if they are not specified.	USE_FORMAT_DEFAULTS	All
Use the column name as the column header if neither the column definition nor the data component specifies a header.	USE_NAME	All
Influence the layout of headers and footers.
Specify the number of blank lines to place between the last row of data and the first row of output.	FOOTER_SPACE=	LISTING
Specify the number of blank lines to place between the last row of headers and the first row of data.	HEADER_SPACE=	LISTING
Specify whether or not to draw a continuous line above the first table footer or, if there is no table footer, below the last row of data on a page.	OVERLINE	LISTING
Specify whether or not to print table footers and any overlining of the table footers.	PRINT_FOOTERS	All except OUTPUT
Specify whether or not to print table headers and any underlining of the table headers.	PRINT_HEADERS	All except OUTPUT
Specify whether or not to draw a continuous line under the last table header or, if there is no table header, then above the last row of data on a page.	UNDERLINE	LISTING
Influence the HTML output.
Specify whether or not to place the output object in a table of contents, if you create a table of contents.	CONTENTS	HTML, PDF, and PRINTER/ PS PDFMARK
Specify the label to use for the outputobject in the contents file, the Results window, and the trace record.	CONTENTS_LABEL=	HTML, PDF, PRINTER, PS PDFMARK
Other table attributes.
Specify an alternate description for the table. ^[*]	ALT=	MARKUP
Specify whether or not to print the current byline before the table.	BYLINE=	All except OUTPUT
Define the characters to use as the line-drawing characters in the table.	FORMCHAR=	LISTING
Specify a label for the table.	LABEL=	All
Specify a long description for the table. ^[*]	LONGDESC=	MARKUP
Specify the table that the current definition inherits from.	PARENT=	All
Specify the style element to use for the table and any changes to the attributes.	STYLE=	HTML, MARKUP family, PRINTER family, and RTF
Specify the special data set type of a SAS data set.	TYPE=	OUTPUT
^[*] SAS includes these accessibility and compatibility features that improve the usability of SAS for users with disabilities. These features are related to accessibility standards for electronic information technology adopted by the U.S. Government under Section 508 of the U.S. Rehabilitation Act of 1973, as amended.

ALT= text

specifies an alternate description of the table.
Requirement: The text must be enclosed with quotation marks.
ODS Destinations: MARKUP

Note: SAS includes this accessibility and compatibility feature that improves the usability of SAS for users with disabilities. This feature is related to accessibility standards for electronic information technology adopted by the U.S. Government under Section 508 of the U.S. Rehabilitation Act of 1973, as amended.

BALANCE <=ON | OFF | variable >

specifies whether or not to try to place the same number of columns in each data panel if the entire table does not fit in one data panel.
Default: OFF
ODS Destinations: LISTING, PRINTER family, and RTF

BYLINE <=ON | OFF | variable >

specifies whether or not to print the current byline before the table.
Default: OFF
Restriction: This attributes applies only if the table is not the first one on the page. If BY- group processing is in effect, a byline automatically precedes the first table on the page.
ODS Destinations: All except OUTPUT

CENTER <=ON | OFF | variable >

specifies whether or not to center each data panel independently if the entire table does not fit in the space that is provided.
Default: ON
ODS Destinations: LISTING, PRINTER family, and RTF

CLASSLEVELS <=ON | OFF | variable >

specifies whether or not to suppress blanking the value in a column that is marked with the BLANK_DUPS column attribute if the value changes in a previous column that is also marked with the BLANK_DUPS attribute.
Default: OFF
ODS Destinations: All except OUTPUT
Featured in: Example 1 on page 342

COL_SPACE_MAX= positive-integer | variable

specifies the maximum number of blank characters to place between the columns.
Default: 4
ODS Destinations: LISTING

COL_SPACE_MIN= positive-integer | variable

specifies the minimum number of blank characters to place between the columns.
Default: 2
ODS Destinations: LISTING

CONTENTS <=ON | OFF | variable >

specifies whether or not to place the output object in a table of contents, if you create a table of contents.
Default: ON
ODS Destinations: HTML, PDF, and PRINTER/PS PDFMARK

CONTENTS_LABEL= string | variable

specifies the label to use for the output object in the contents file, the Results window, and the trace record.
Default: If the SAS system option LABEL is in effect, the default label is the object s label. If LABEL is not in effect, the default label is the object s name.
ODS Destinations: HTML, PDF, and PRINTER/PS PDFMARK

CONTROL= column-name | variable

specifies the name of the column whose values provide formatting information about the space before each row of the definition. The value of CONTROL= should be the name of a column of type character with a length equal to 1.

Column Control Value	Result
a digit from 1-9	the specified number of blank lines precedes the current row
a hyphen (-)	a row of underlining precedes the current row
b or B	ODS tries to insert a panel break if the entire table does not fit in the space that is provided

Default: none

ODS Destinations: All except OUTPUT

DATA_FORMAT_OVERRIDE<=ON | OFF | variable >

specifies which format to use if both a column definition and a data component specify a format.

ON
- uses the format that the data component specifies.

OFF
- use the format that the column definition specifies.

Default: OFF

ODS Destinations: All

DOUBLE_SPACE<=ON | OFF | variable >

specifies whether or not to double space between the rows of the table.

Default: OFF

ODS Destinations: LISTING

Featured in: Example 1 on page 515 and Example 3 on page 528

EVEN<=ON | OFF | variable >

specifies whether or not extra space is evenly divided among all columns of the table.

Default: OFF

ODS Destinations: LISTING

FOOTER_SPACE=0 | 1 | 2 | variable

specifies the number of blank lines to place between the last row of data and the first row of the table footer.

Default: 1

ODS Destinations: LISTING

FORMCHAR= string | variable

defines the characters to use as the line-drawing characters in the table. Currently, PROC TEMPLATE uses only the second of the 20 possible formatting characters. This formatting character is used for underlining and overlining. To change the second formatting character, you must specify both the first and second formatting characters. For example, the following option assigns the asterisk (*) to the first formatting character, the plus sign (+) to the second character, and does not alter the remaining characters:
```
formchar=*+ 
```
Default: The SAS system option FORMCHAR= specifies the default formatting characters.

Tip: You can use any character in formatting-characters, including hexadecimal characters. If you use hexadecimal characters, then you must put an x after the closing quote. For example, the following option assigns the hexadecimal character 2D to the first formatting character, the hexadecimal character 7C to the second character, and does not alter the remaining characters:

formchar= 2D7C x
ODS Destinations: LISTING

HEADER_SPACE=0 | 1 | 2 | variable

specifies the number of blank lines to place between the last row of headers and the first row of data. A row of underscores is a header.
Default: 1
ODS Destinations: LISTING

JUSTIFY<=ON | OFF | variable >

specifies whether to justify the format fields within the columns or to justify the values within the columns without regard to the format fields.
Default: OFF
Interaction: JUSTIFY=ON can interfere with decimal alignment.
Interaction: If the column is numeric, then values are aligned to the right if you specify JUSTIFY=OFF and JUST=C.
Interaction: All destinations except LISTING justify the values in columns as if JUSTIFY=ON for JUST=R and JUST=L.
Tip: If you translate numeric data to character data, you might need to use JUSTIFY= to align the data.
Main discussion: How Are Values in Table Columns Justified? on page 512
ODS Destinations: LISTING

LABEL= text | variable

specifies a label for the table.
Default: PROC TEMPLATE uses the first of the following that it finds:
- a label that the table definition provides
- a label that the data component provides
- the first spanning header in the table.

ODS Destinations: All

LONGDESC= string

specifies the long description of the table.
Requirement: The text must be enclosed with quotation marks.
ODS Destinations: MARKUP

Note: SAS includes this accessibility and compatibility feature that improves the usability of SAS for users with disabilities. This feature is related to accessibility standards for electronic information technology adopted by the U.S. Government under Section 508 of the U.S. Rehabilitation Act of 1973, as amended.

NEWPAGE<=ON | OFF | variable >

specifies whether or not to force a new page before printing the table.
Default: OFF
Restriction: If the table is the first item on the page, ODS ignores this attribute.
ODS Destinations: All except OUTPUT

ORDER_DATA<=ON | OFF | variable >

specifies whether or not to order the columns by their order in the data component.
Default: OFF
- When ORDER_DATA=OFF, the default order for columns is the order that they are specified in the COLUMN statement. If you do not use a COLUMN statement, the default order for columns is the order in which you define them in the definition.

Tip: The Output destination always uses the order of the columns in the data component when it creates an output data set.
Interaction: ORDER_DATA is most useful for ordering generic columns.
ODS Destinations: All except OUTPUT

OVERLINE<=ON | OFF | variable >

specifies whether or not to draw a continuous line above the first table footer or, if there is no table footer, below the last row of data on a page. PROC TEMPLATE uses the second formatting character to draw the line.
Default: OFF
Main discussion: See the discussion of FORMCHAR= on page 417.
See also: UNDERLINE= on page 421 (for tables), UNDERLINE= on page 387 (for columns), and OVERLINE= on page 385 (for columns)
ODS Destinations: LISTING
Featured in: Example 1 on page 515

PANELS= positive-integer | variable

specifies the number of sets of columns to place on a page. If the width of all the columns is less than half of the linesize, you can display the data in multiple sets of columns so that rows that would otherwise appear on multiple pages appear on the same page.
Tip: If the number of panels that is specified is larger than the number of panels that can fit on the page, the definition creates as many panels as it can. Let the table definition put your data in the maximum number of panels that can fit on the page by specifying a large number of panels (for example, 99).
ODS Destinations: LISTING and PRINTER family

PANEL_SPACE= positive-integer | variable

specifies the number of blank characters to place between sets of columns when PANELS= is in effect.
Default: 2
ODS Destinations: LISTING

PARENT= table-path

specifies the table that the current definition inherits from. A table-path consists of one or more names, separated by periods. Each name represents a directory in a template store. (A template store is a type of SAS file.) The current definition inherits from the specified table in the first template store in the current path that you can read from.

When you specify a parent, all of the attributes and statements that are specified in the parent s definition are used in the current definition unless the current definition overrides them.
ODS Destinations: All

PRINT_FOOTERS<=ON | OFF | variable >

specifies whether or not to print table footers and any overlining of the table footers.
Default: ON
See also: OVERLINE= on page 419
ODS Destinations: All except OUTPUT

PRINT_HEADERS<=ON | OFF | variable >

specifies whether or not to print the table headers and any underlining of the table headers.
Default: ON
Interaction: When used in a table definition, PRINT_HEADERS affects only headers for the table, not the headers for individual columns. (See the discussion of the PRINT_HEADERS column attribute on page 386.)
See also: UNDERLINE= on page 421
ODS Destinations: All except OUTPUT

REQUIRED_SPACE= positive-integer | variable

specifies the number of lines that must be available on the page in order to print the body of the table (The body of the table is the part of the table that contains the data. It does not include headers and footers.)
Default: 3
ODS Destinations: LISTING and PRINTER family

SPLIT_STACK<=ON | OFF | variable >

specifies whether or not to split a long stacked column across page boundaries.
Default: OFF
ODS Destinations: LISTING

STYLE=< style-element-name ><[ style-attribute-specification(s) ]>

specifies the style element and any changes to its attributes to use for the table.
style-element-name
- is the name of the style element to use to display the table. The style element must be part of a style definition that is registered with the Output Delivery System. SAS provides some style definitions. You can create your own style definitions with PROC TEMPLATE (see DEFINE STYLE Statement on page 288). By default, ODS produces different parts of ODS output with different elements. For example, by default, a table is produced with the style element table . The style definitions that SAS provides do not provide another style element that you would be likely to want to use instead of table . However, you may have a user -defined style element at your site that would be appropriate to specify.
  
  The style element provides the basis for displaying the table. Additional style attributes that you provide can modify the display.
  
  style-element-name can be either the name of a style element or a variable whose value is a style element.
- See also: Viewing the Contents of a Style Definition on page 319
- See also: The Default Style Definition for HTML and Markup Languages on page 320.

style-attribute-specification
- describes the style attribute to change. Each style-attribute-specification has this general form:
  - style-attribute-name = style-attribute-value
- See also: Style Attributes and Their Values on page 292.

Default: table
Requirement: With the STYLE= option, you must specify either a style-attribute-specification or a style-element-name .
Tip: You can use braces ({ and }) instead of square brackets ([ and ]).
Tip: If you use the STYLE= attribute inside a quoted string, then you must add a space before or after the carriage return to prevent errors. SAS does not interpret a carriage return as a space. You must explicitly specify spaces in your quoted strings.
ODS Destinations: HTML, MARKUP family, PRINTER family, and RTF

TOP_SPACE= positive-integer | variable

specifies the number of lines to place between the previous output object and the current one.
Default: 1
ODS Destinations: LISTING and PRINTER family

TYPE= string | variable

specifies special type of SAS data set.
Restriction: PROC TEMPLATE does not verify the following:
- a SAS data set type that you specify is a valid data set type
- the structure of the data set that you create is appropriate for the type that you have assigned.

Tip: Most SAS data sets have no special type. However, certain SAS procedures, like the CORR procedure, can create a number of special SAS data sets. In addition, SAS/STAT software and SAS/EIS software support special data set types.
ODS Destination: OUTPUT

UNDERLINE<=ON | OFF | variable >

specifies whether or not to draw a continuous line under the last table header (or, if there is no table header, then above the first row of data on a page). PROC TEMPLATE uses the second formatting character to draw the line.
Default: OFF
Main discussion: See the discussion of FORMCHAR= on page 417.
See also: OVERLINE= on page 419 (for tables), UNDERLINE= on page 387 (for columns), and OVERLINE= on page 385 (for columns)
ODS Destinations: LISTING
Featured in: Example 1 on page 515 and Example 3 on page 528

USE_FORMAT_DEFAULTS<=ON | OFF | variable >

specifies the source of the values for the format width and the decimal width if they are not specified.
ON
- uses the default values, if any, that are associated with the format name.

OFF
- uses the PROC TEMPLATE defaults.

Default: OFF
ODS Destinations: All except OUTPUT

USE_NAME<=ON | OFF | variable >

uses the column name as the column header if neither the column definition nor the data component specifies a header.
Default: OFF
Tip: Use this attribute when column names are derived from a data set and the columns are generic.
ODS Destinations: All except OUTPUT

WRAP<=ON | OFF | variable >

specifies whether to split a wide table into multiple data panels, or to wrap each row of the table so that an entire row is printed before the next row starts.
Default: OFF
Interaction: When ODS wraps the rows of a table, it does not place multiple values in any column that contains an ID column.
See also: WRAP_SPACE= on page 422 and ID= on page 383
ODS Destinations: LISTING and PRINTER family

WRAP_SPACE<=ON | OFF | variable >

specifies whether or not to double space after the last line of a single row of the table when the row is wrapped onto more than one line.
Default: OFF
See also: WRAP= on page 422
ODS Destinations: LISTING, PRINTER family, and RTF

CELLSTYLE “AS Statement

Sets the style element of the cells in the table according to the values of the variables. Use this statement to set the presentation characteristics (such as foreground color, font face, flyover) of individual cells

Featured in: Example 5 on page 539

CELLSTYLE expression-1 AS < style-element-name ><[ style-attribute-specification(s) ]> < , expression-n AS < style-element-name ><[ style-attribute-specification(s) ]>>;

Required Arguments

expression

is an expression that is evaluated for each table cell that contains a variable. It can be any expression that is valid in the WHERE statement (or the WHERE= data set option). For information on expressions that you can use in the WHERE statement, see Statements in SAS Language Reference: Dictionary . Use _VAL_ to represent the value of the current column. You may also reference symbols that you declared in a DYNAMIC, MVAR, or NVAR statement in the table definition.

If expression resolves to TRUE (a non-zero value), the style element that is specified is used for the current cell. If expression is FALSE (zero), the next expression in the statement is evaluated. Thus, you can string multiple expressions together to format cells conditionally.
Restriction: You can not reference the values of other columns in expression .
Tip: Using an expression of 1 as the last expression in the CELLSTYLE-AS statement sets the style element for any cells that did not meet an earlier condition.

style-attribute-specification

describes a style attribute to set. Each style-attribute-specification has this general form:
- style-attribute-name = style-attribute-value

For information on the style attributes that you can set in a table definition, see Style Attributes and Their Values on page 292.

Options

style-element-name

is the name of a style element that is part of a style definition that is registered with the Output Delivery System. SAS provides some style definitions. You can create your own style definitions and style elements with PROC TEMPLATE. (See DEFINE STYLE Statement on page 288.)

The style elements that you would be most likely to use with the CELLSTYLE-AS statement are
- data
- datafixed
- dataempty
- dataemphasis
- dataemphasisfixed
- datastrong
- datastrongfixed.

The style element provides the basis for displaying the cell. Additional style attributes that you provide can modify the display.

COLUMN Statement

Declares a symbol as a column in the table and specifies the order of the columns

Featured in: Example 3 on page 528

COLUMN column(s) ;

Required Arguments

column

is one or more columns. If the column is defined outside the current table definition, you must reference it by its path in the template store. Columns in the definition are laid out from left to right in the same order that you specify them in the COLUMN statement.
Default: If you do not use a COLUMN statement, ODS makes a column for each column definition (DEFINE COLUMN statement), and places the columns in the same order that the column definitions have in the table definition.

If you use a COLUMN statement but do not use a DEFINE COLUMN statement for any of the columns, ODS uses a default column definition that is based on the type of data in the column.
Interaction: If you specify the column attribute PRINT=OFF, then you turn off the value of a column if it is part of a stacked column. If all columns in a stacked column have PRINT=OFF set, then the entire column is removed from the table.
Tip: You can use a list of variable names, such as DAY1 “DAY10, to specify multiple variables.
Main discussion: Stacking Values for Two or More Variables
- To stack values for two or more variables in the same column, put parentheses around the variables that you want to stack. In such a case, the column header for the first column inside the parentheses becomes the header for the column that contains all the variables inside parentheses. For example, the following COLUMN statement produces a definition in which
  - the value of NAME is in the first column by itself.
  - the values of CITY and STATE appear in the second column with CITY above STATE. The header for this column is the header that is associated with CITY.
  - the values HOMEPHONE and WORKPHONE appear in the third column with HOMEPHONE above WORKPHONE. The header for this column is the header that is associated with HOMEPHONE.
```
column name (city state) (homephone workphone); 
```
- You can use the asterisk (*) in the COLUMN statement to change the layout of stacking variables. An asterisk between groups of variables in parentheses stacks the first item in the first set of parentheses above the first item in the next set of parentheses, and so on until the last group of parentheses is reached. Then, the second item in the first group is stacked above the second item in the second group, and so on. For example, the following COLUMN statement produces a report in which
  - the value of NAME is in the first column by itself.
  - the values of CITY and HOMEPHONE appear in the second column with CITY above HOMEPHONE. The header for this column is the header that is associated with CITY.
  - the values STATE and WORKPHONE appear in the third column with STATE above WORKPHONE. The header for this column is the header that is associated with STATE.
```
column name (city state) * (homephone workphone); 
```

DEFINE Statement

Creates a definition inside a table definition

Main discussion: DEFINE COLUMN Statement on page 374, DEFINE FOOTER Statement on page 395, and DEFINE HEADER Statement on page 395

DEFINE definition-type definition-name </ option(s) >; statements-and-attributes

END ;

Required Arguments

definition-type

specifies the type of definition to create, where definition-type is one of the following:
COLUMN
FOOTER
HEADER
The definition-type determines what other statements and what attributes can go in the definition. For details, see the documentation for the corresponding DEFINE statement.

definition-name

specifies the name of the new object.
Restriction: definition-name must be a single-level name.
- Note: If you want to reference the definition that you are creating from another definition, you must create it outside the table definition.

Options

NOLIST

preserves the definition-type when inheriting it from another table definition.
Tip: If you specify an existing definition-name without using the NOLIST option, then the definition is overwritten.

DYNAMIC Statement

Defines a symbol that references a value that the data component supplies from the procedure or DATA step

Featured in: Example 1 on page 342 and Example 2 on page 348

DYNAMIC variable-1 < text-1 > < variable-n < text-n >>;

Required Arguments

variable

Names a variable that the data component supplies. ODS resolves the value of the variable when it binds the definition and the data component.
Tip: Dynamic variables are most useful to the authors of SAS procedures and to DATA step programmers.

Options

text

is text that you can place in the definition to explain the dynamic variable s use. Text of this type becomes part of the compiled definition, which you can view with the SOURCE statement, whereas SAS comments do not.

FOOTER Statement

Declares a symbol as a footer in the table and specifies the order of the footers

FOOTER footer-specification(s) ;

Required Arguments

footer-specification

is one or more footers. If the footer is defined outside the current table definition, you must reference it by its path in the template store. Footers in the definition are laid out from top to bottom in the same order that you specify them in the FOOTER statement. Each footer-specification can be
" string "
- specifies the text to use for the footer. If you use a string, you do not need to use a DEFINE FOOTER statement. However, you cannot specify any footer attributes except for a split character. If the SPLIT= attribute is not in effect and if the first character of the footer that you specify is neither a blank character nor an alphanumeric character, PROC TEMPLATE treats it as the split character.
- See also: SPLIT=.

footer-path
- is the path of the footer definition to use. A footer-path consists of one or more names, separated by periods. Each name represents a directory in a template store. (A template store is a type of SAS file.)

_LABEL_
- uses the label of the output object as the footer. Each SAS procedure specifies a label for each output object that it creates. The DATA step uses the value of the OBJECTLABEL= option as the label of the output object. If OBJECTLABEL= is not specified, it uses the text of the first TITLE statement as the label.

Default: If you do not use a FOOTER statement, ODS makes a footer for each footer definition (DEFINE FOOTER statement), and places the footers in the same order that the footer definitions have in the table definition.

HEADER Statement

Declares a symbol as a header in the table and specifies the order of the headers

HEADER header-specification(s) ;

Required Arguments

header-specification

is one or more headers. If the header is defined outside the current table definition, you must reference it by its path in the template store. Headers in the definition are laid out from top to bottom in the same order that you specify them in the HEADER statement. Each header-specification can be
" string "
- specifies the text to use for the header. If you use a string, you do not need to use a DEFINE HEADER statement. However, you cannot specify any header attributes except for a split character. If the SPLIT= header attribute is not in effect and if the first character of the header that you specify is neither a blank character nor an alphanumeric character, PROC TEMPLATE treats it as the split character.
  
  See also: SPLIT=.

header-path
- is the path of the header definition to use. A header-path consists of one or more names, separated by periods. Each name represents a directory in a template store. (A template store is a type of SAS file.)

_LABEL_
- uses the label of the output object as the header. Each SAS procedure specifies a label for each output object that it creates. The DATA step uses the value of the OBJECTLABEL= option as the label of the output object. If OBJECTLABEL= is not specified, it uses the text of the first TITLE statement as the label.

Default: If you do not use a HEADER statement, then ODS makes a header for each header definition (DEFINE HEADER statement), and places the headers in the same order that the header definitions have in the table definition.
Featured in: Example 3 on page 528

MVAR Statement

Featured in: Example 3 on page 528 and Example 1 on page 342

MVAR variable-1 < text-1 > < variable-n < text-n >>;

Required Arguments

variable

Names a macro variable to reference in the definition. ODS will use the value of the macro variable as a string. ODS does not resolve the value of the macro variable until it binds the definition and the data component.
Tip: You must declare macro variables this way in a definition. For example, to use the automatic macro variable SYSDATE9 in a definition, declare it in an MVAR statement and reference it as SYSDATE9, without an ampersand, in your PROC TEMPLATE step. If you use the ampersand, the macro variable resolves when the definition is compiled instead of when ODS binds the definition to the data component.

Options

text

is text that you can place in the definition to explain the macro variable s use. Text of this type becomes part of the compiled definition, which you can view with the SOURCE statement, whereas SAS comments do not.

NMVAR Statement

Featured in: Example 5 on page 539

NMVAR variable-1 < text-1 > < variable-n < text-n >>;

Required Arguments

variable

Names a macro variable to reference in the definition. ODS will convert the variable s value to a number (stored as a double) before using it. ODS does not resolve the macro variable until it binds the definition and the data component.
Tip: You must declare macro variables this way in a definition. For example, to use a macro variable as a number, declare it in an NMVAR statement and reference it without an ampersand. If you use the ampersand, the macro variable resolves when the definition is compiled instead of when ODS binds the definition to the data component.

Options

text

is text that you can place in the definition to explain the macro variable s use. Text of this type becomes part of the compiled definition, which you can view with the SOURCE statement, whereas SAS comments do not.

NOTES Statement

Provides information about the table

Tip: The NOTES statement becomes part of the compiled column definition, which you can view with the SOURCE statement, whereas SAS comments do not.

Featured in: Example 5 on page 539

NOTES text ;

Required Arguments

text

provides information about the table.

TRANSLATE-INTO Statement

Translates the specified numeric values to other values

Restriction: The TRANSLATE-INTO statement in a table definition applies only to numeric variables. To translate the values of a character variable, use TRANSLATE-INTO in the definition of that column. (See DEFINE COLUMN Statement on page 374).

Featured in: Example 5 on page 539

TRANSLATE expression-1 INTO expression-2 < , expression-n INTO expression-m >;

Required Arguments

expression-1

is an expression that is evaluated for each table cell that contains a numeric variable. It can be any numeric expression that is valid in the WHERE statement (or the WHERE= data set option). For information on expressions that you can use in the WHERE statement, see Statements in SAS Language Reference: Dictionary . Use _VAL_ to represent the value of the current column. You may also reference symbols that you declared in a DYNAMIC, MVAR, or NVAR statement in the table definition.

If expression-1 resolves to TRUE (a non-zero value), the translation that is specified is used for the current cell. If expression-1 is FALSE (zero), the next expression in the statement is evaluated. Thus, you can string multiple expressions together to format cells conditionally.

Restriction: You may not reference the values of other columns in expression-1 .

Tip: Using an expression of 1 as the last expression in the TRANSLATE “INTO statement specifies a translation for any cells that did not meet an earlier condition.

expression-2

is an expression that specifies the value to use in the cell in place of the variable s actual value. It can be any expression that is valid in the WHERE statement (or the WHERE= data set option). For information on expressions that you can use in the WHERE statement, see Statements in SAS Language Reference: Dictionary . Use _VAL_ to represent the value of the current column. You may also reference symbols that you declared in a DYNAMIC, MVAR, or NVAR statement in the table definition.
Restriction: expression-2 must resolve to a character value, not a numeric value.
Restriction: You may not reference the values of other columns in expression-2 .
Tip: When you translate a numeric value to a character value, the table definition does not try to apply the numeric format that is associated with the column. Instead, it simply writes the character value into the formatted field, starting at the left. If you want the value to be right-justified, use the JUSTIFY=ON attribute.
See also: JUSTIFY= on page 418.

END Statement

Ends the table definition

END ;

ODS Output Object Table Names

ODS Table Names and the Base SAS Procedures that Produce Them on page 430
ODS Table Names and the SAS/STAT Procedures that Produce Them on page 437
ODS Table Names and the SAS/ETS Procedures that Produce Them on page 490

ODS Table Names and the Base SAS Procedures that Produce Them

The following table lists the output object table names which Base SAS procedures produce. The table provides the name of each table, a description of what the table contains, and the option, if any, that creates the output object table. For more information about Base SAS procedures, see Base SAS Procedures Guide .

Table 10.11: ODS Table Names Produced by the CALENDAR Procedure
Table Name	Description
Calendar	Calendar

Table 10.12: ODS Table Names Produced by the CATALOG Procedure
Table Name	Description
Catalog_Random	Table generated when the catalog is in a random-access data library
Catalog_Sequential	Table generated when the catalog is in a sequential-access data library

Table 10.13: ODS Table Names Produced by the CHART Procedure
Table Name	Description
Block	Block chart
Hbar	Horizontal bar chart
Pie	Pie chart
Star	Star chart
Vbar	Vertical bar chart

Table 10.14: ODS Table Names Produced by the COMPARE Procedure
Table Name	Description	Option
CompareDatasets	Information about the data set or data sets	Omit NOSUMMARY or NOVALUE options
CompareDetails (Comparison results for observations)	List of observations that the base data set and the compare data setdonot haveincommon	PRINTALL
CompareDifferences	Report of variable value differences	Omit NOVALUES option
CompareSummary	Summary report of observations, values, and variables of unequal values
CompareVariables	List of differences in variable types or attributes between the base data set and the compare data set	Omit NOSUMMARY option or unless the variables are identical
ODS Tables Created by the ID Statement
CompareDetails	List of notes and warnings concerning duplicate ID variable values, if duplicate ID variable values exist in either the data set

Table 10.15: ODS Table Names Produced by the CORR Procedure
Table Name	Description	Option
Cov	Covariance table row/column variance DF (missing values)	COV
CronbachAlpha	Coefficient alpha	ALPHA
CronbachAlphaDel	Coefficient alpha with deleted variables	ALPHA
Csscp	Corrected sums of squares and crossproducts Row/column variable corrected sums of squares (missing values)	CSSCP
HoeffdingCorr	Hoeffding s D statistics p-value (NOPROB is not specified) Number of observations (missing values)	HOEFFDING
KendallCorr	Kendall tau-b coefficients p-value (NOPROB is not specified) Number of observations (missing values)	Pearson or omit NOCORR option
SimpleStats	Simple descriptive statistics	Omit NOSIMPLE option
SpearmanCorr	Spearman descriptive statistics	SPEARMAN
Sscp	Sums of squares and crossproducts Row/column variable sums of squares (missing values)	SSCP
VarInformation	Variable information
ODS Tables Created by the PARTIAL Statement
PartialCsscp	Partial corrected sums of squares and crossproducts	CSSCP
PartialCov	Partial covariances	COV
PartialKendallCorr	Partial Kendall tau-b coefficients	KENDALL
PartialPearsonCorr	Partial Kendall tau-b coefficients p-values (NOPROB option is not specified)
PartialSpearmanCorr	Partial Spearman correlations p-values (NOPROB option is not specified)	SPEARMAN

Table 10.16: ODS Table Names Produced by the DATASETS and CONTENTS Procedures
Table Name	Description	Option
Directory	General library information	Omit NOLIST option
Members	Library member information	Omit NOLIST option

Table 10.17: ODS Table Names Produced by the CONTENTS Procedure or the DATASETS Procedure with the CONTENTS Statement
Table Name	Description	Option
Attributes	Data set attributes	Omit SHORT option
Directory	General library information	DATA=< libref .>_ALL_ or the DIRECTORY option ^[*]
EngineHost	Engine and operating environment information	Omit SHORT option
IntegrityConstraints	List of integrity constraints	Omit SHORT option and data has integrity constraints
IntegrityConstraintsShort	Concise listing of integrity constraints	SHORT option specified and data has integrity constraints
Indexes	List of indexes	Omit SHORT option and data set is indexed
IndexesShort	Concise list of indexes	SHORT option specified and data set is indexed
Members	Library member information	DATA=< libref .>_ALL_ or the DIRECTORY option ^[*]
Position	List of variables by logical position in the data set	Omit SHORT option and specify the VARNUM option
PositionShort	Concise list of variables by logical position in the data set	SHORT and VARNUM options
Sortedby	Sort information	Omit SHORT option and data set is sorted
SortedbyShort	Concise sort information	SHORT option and data set is sorted
Variables	List of variables in alphabetical order	Omit SHORT option
VariablesShort	Concise listing of variables in alphabetical order	SHORT
^[] For PROC DATASETS, if both the NOLIST option and either the DIRECTORY option or DATA= <libref.>* _ALL_ are specified, then the NOLIST option is ignored.

Table 10.18: ODS Table Names Produced by the FREQ Procedure
Table Name	Description	Option
BinomialProp	Binomial proportion	BINOMIAL (one-way tables)
BinomialPropTest	Binomial proportion test	BINOMIAL (one-way tables)
BreslowDayTest	Breslow-day test	CMH (hx2x2 tables)
CMH	Cochran-Mantel-Haenszel statistics	CMH
ChiSq	Chi-Square tests and measures	CHISQ
CochransQ	Cochran s Q	AGREE (hx2x2 tables)
ColScores	Column scores	SCOROUT
CommonRelRisks	Common relative risks	CMH (hx2x2 tables)
Crosslist	Cross lists
CrossTabFreqs	Crosstabulation table	(n-way table request, n>1)
EqualKappaTest	Test for equal simple kappas	AGREE (hx2x2 tables)
EqualKappaTests	Test for equal kappas	AGREE (hxrxr tables, r>2)
FishersExact	Fisher s exact test	FISHER or EXACT CHISQ (2x2 tables)
JTTest	Jonckheere-Terpstra test	JT
KappaStatistics	Kappa statistics	AGREE (rxr tables, r>2, and no TEST or EXACT requests for kappas)
KappaWeight	Kappa weights	AGREE and PRINTKWT
List	List frequencies	LIST
McNemarsTest	McNemar s test	AGREE (2x2 tables)
Measures	Measures of association	MEASURES
OneWayChiSq	One-way Chi-Square goodness-of-fitness test	CHISQ (one-way tables)
OneWayFreqs	One-way frequencies	(one-way table request)
OverallKappa	Overall simple kappa coefficient	AGREE (hx2x2 tables)
Overallkappas	Overall kappa coefficients	AGREE (hxrxr tables, r>2)
RelativeRisks	Relative risk estimates	RELRISK or MEASURES (2x2 tables)
RiskDiffCol1	Column 1 risk estimates	RISKDIFF (2x2 tables)
RiskDiffCol2	Column 2 risk estimates	RISKDIFF (2x2 tables)
RowScores	Row scores	SCOROUT
SimpleKappaTest	Simple kappa tests	AGREE (2x2 tables), AGREE (rxr tables, r>2)
SymmetryTest	Test of symmetry	AGREE
TrendTest	Cochran-Armitage test for trend	TREND
WeightKappa	Weighted kappa coefficient	AGREE (rxr tables, r>2)

Table 10.19: ODS Table Names Produced by the MEANS and SUMMARY Procedures
Table Name	Description
Summary	Summary of descriptive statistics for variables across all observations and within groups of observations

Table 10.20: ODS Table Names Produced by the PLOT Procedure
Table Name	Description	Option
Plot	Single plot graph
Overlaid	two or more plots on a single set of axes	OVERLAY

Table 10.21: ODS Table Names Produced by the REPORT Procedure
Table Name	Description
Report	Detail report, summary report, or combination of both detail and summary information report

Table 10.22: ODS Table Names Produced by the SQL Procedure
Table Name	Description
SQL_Results	SAS data file or a SAS data view

Table 10.23: ODS Table Names Produced by the TABULATE Procedure
Table Name	Description
Table	Descriptive statistics in tabular format that use some or all of the variables in a data set

Table 10.24: ODS Table Names Produced by the TIMEPLOT Procedure
Table Name	Description	Option
Plot	Single plot graph	Omit the OVERLAY option
OverlaidPlot	Two or more plots on a single set of axes	OVERLAY

Table 10.25: ODS Table Names Produced by the UNIVARIATE Procedure
Table Name	Description	Option
BasicIntervals	Confidence intervals for mean, standard deviation, variance	CIBASIC
BasicMeasures	Measures of location and variability
ExtremeObs	Extreme observations
ExtremeValues	Extreme values	NEXTRAVAL=
Frequencies	Frequencies	FREQ
LocationCounts	Counts used for sign test and signed rank test	LOCCOUNT
Missing Values	Missing values
Modes	Modes	MODES
Moments	Sample moments
Plots	Line printer plots	PLOTS
Quantiles	Quantiles
RobustScale	Robust measures of scale	ROBUSTSCALE
SSPlots	Line printer side-by-side box plot	PLOTS with BY statement
TestsForLocation	Tests for location
TestsForNormality	Tests for normality	NORMALTEST
TrimmedMeans	Trimmed means	TRIMMED=
WinsorizedMeans	Winsorized means	WINSORIZED=

ODS Table Names and the SAS/STAT Procedures that Produce Them

The following table lists the output object table names which SAS/STAT procedures produce. You must license SAS/STAT software in order to produce these output objects. The table provides the name of each table, a description of what the table contains, and the option, if any, that creates the output object table. For information about SAS/STAT procedures, see

Table 10.26: ODS Table Names Produced by the ACECLUS Procedure
Table Name	Description	Option
ODS Tables Created by the PROC Statement
ConvergenceStatus	Convergence status
DataOptionInfo	Data and option information
Eigenvalues	Eigenvalues of Inv(ACE)*(COV-ACE)
Eigenvectors	Eigenvectors (raw canonical coefficients)
InitWithin	Initial within-cluster covariances estimate	INITIAL=INPUT
IterHistory	Iteration history
SimpleStatistics	Simple statistics
StdCanCoef	Standardized canonical coefficients
Threshold	Threshold value	PROPORTION=
TotSampleCov	Total sample covariances
Within	Approximate covariance estimate within clusters

Table 10.27: ODS Table Names Produced by the ANOVA Procedure
Table Name	Description	Option
DependentInfo	Simultaneously analyzed dependent variables	default when there are multiple dependent variables with different patterns of missing values
FitStatistics	R-Square, C.V., root MSE, and dependent mean
ModelANOVA	ANOVA for model terms
NObs	Number of observations
OverallANOVA	Overall ANOVA
ODS Tables Created by the CLASS Statement
ClassLevels	Classification variable levels
ODS Tables Created by the MANOVA Statement
MANOVATransform	Multivariate transformation matrix	M=
MultStat	Multivariate tests
Tests	Summary ANOVA for specified MANOVA H= effects	H=SUMMARY
ODS Tables Created by the MANOVA or REPEATED Statements
CanAnalysis	Canonical analysis	CANONICAL
CanCoef	Canonical coefficients	CANONICAL
CanStructure	Canonical structure	CANONICAL
CharStruct	Characteristic roots and vectors	MANOVA (not CANONICAL); REPEATED PRINTRV
ErrorSSCP	Error SSCP matrix	PRINTE
HypothesisSSCP	Hypothesis SSCP matrix	PRINTE; MANOVA M=
PartialCorr	Partial correlation matrix	PRINTE; REPEATED (CONTRAST, HELMERT, MEAN, POLYNOMIAL, or PROFILE)
ODS Tables Created by the MEANS Statement
Bartlett	Bartlett s homogeneity of variance test	HOVTEST=BARTLETT
CLDiffs	Multiple comparisons of pairwise differences	CLDIFF or DUNNETT or (Unequal cells and not LINES)
CLDiffsInfo	Information for multiple comparisons of pairwise differences	CLDIFF or DUNNETT or (Unequal cells and not LINES)
CLMeans	Multiple comparisons of means with confidence/comparison	CLM with (BON, GABRIEL, SCHEFFE, SIDAL. SMM, T, or LSD)
CLMeansInfo	Information for multiple comparisons of means with confidence/comparison interval	CLM
HOVFTest	Homogeneity of variance ANOVA	HOVTEST
MCLines	Multiple comparisons LINES output	LINES, ((DUNCAN or WALLER or SNK or REGWQ) and not (CLDIFF or CLM)), or (equal cells and not CLDIFF)
MCLinesInfo	Information for multiple comparison LINES output	LINES, ((DUNCAN, WALLER, SNK, or REGWQ) and not (CLDIFF or CLM)), or (equal cells and not CLDIFF
MCLinesRange	Ranges for multiple range MC tests	LINES, ((DUNCAN, WALLER, SNK, or REGWQ) and not (CLDIFF or CLM)), or (equal cells and not CLDIFF)
Means	Group means
Welch	Welch s ANOVA	WELCH
ODS Tables Created by the REPEATED Statement
Epsilons	Greenhouse-Geisser and Huynh-Feldt epsilons
RepTransform	Repeated transformation matrix	CONTRAST, HELMERT, MEAN, POLYNOMIAL, or PROFILE
RepeatedLevelInfo	Correspondence between dependents and repeated measures levels
Sphericity	Sphericity tests	PRINTE
ODS Tables Created by the TEST Statement
AltErrTests	ANOVA tests with error other than MSE	E=

Table 10.28: ODS Table Names Produced by the CALIS Procedure
Table Name	Description	Option
ODS Tables Created by the COSAN, FACTOR, LINEQS, and RAM Models
AddParms	Additional parameters in the PARAMETERS statement	PINITIAL or default
AsymStdRes	Asymptotically standardized residual matrix	RESIDUAL= or PRINT
AveAsymStdRes	Average absolute asymptotically standardized residuals	RESIDUAL= or PRINT
AveNormRes	Average absolute normalized residuals	RESIDUAL= or PRINT
AveRawRes	Average absolute raw residuals	RESIDUAL= or PRINT
AveVarStdRes	Average absolute variance standardized residuals	RESIDUAL= or PRINT
ContKurtosis	Contributions to kurtosis	KURTOSIS or PRINT
ConvergenceStatus	Convergence status	PSHORT
CorrParm	Correlations among parameter estimates	PCOVES and default
CovMat	Assorted cov matrices	PCOVES and default
DependParms	Dependent parameters (if specified by program statements)	PRIVEC and default
DistAsymStdRes	Distribution of asymptotically standardized residuals	RESIDUAL= or PRINT
DistNormRes	Distribution of normalized residuals	RESIDUAL= or PRINT
DistVarStdRes	Distribution of variance standardized residuals	RESIDUAL= or PRINT
Estimates	Vector of estimates	PRIVEC
Fit	Fit statistics	PSUMMARY
GenModInfo	General modeling information	PSIMPLE or default
Gradient	First partial derivatives (Gradient)	PRIVEC and default
InCorr	Input correlation matrix	PCORR or PALL
InCorrDet	Determinant of the input correlation matrix	PCORR or PALL
InCov	Input covariance matrix	PCORR or PALL
InCovDet	Determinant of the input covariance matrix	PCORR or PALL
Information	Information matrix	PCOVES and default
InitEstimates	Initial vector of parameter estimates	PINITIAL or default
InSymmetric	Input symmetric matrix (SYMATRIX data type)	PCORR or PALL
IterHist	Iteration history	PSHORT
IterStart	Iteration start	PSHORT
IterStop	Iteration stop	PSHORT
Jacobian	Jacobi column pattern	PJACPAT
Kurtosis	Kurtosis, with raw data input	KURTOSIS or PRINT
LagrangeBoundary	Lagrange, releasing active boundary constraints	MODIFICATION or PALL
LagrangeEquality	Lagrange, releasing equality constraints	MODIFICATION or PALL
ModelStatement	Model summary	PSHORT
ModIndices	Lagrange multiplier and Wald test statistics	MODIFICATION or PALL
NormRes	Normalized residual matrix	RESIDUAL= or PRINT
PredetElements	Predetermined elements	PREDET or PALL
PredModel	Predicted model matrix	PCORR or PALL
PredModelDet	Predicted model determinant	PCORR or PALL
ProblemDescription	Problem Description	PSHORT
RankAsymStdRes	Ranking of the largest asymptotically standardized residuals	RESIDUAL= or PRINT
RankLagrange	Ranking of the largest Lagrange indices	RESIDUAL= or PRINT
RankNormRes	Ranking of the largest normalized residuals	RESIDUAL= or PRINT
RankRawRes	Ranking of the largest raw residuals	RESIDUAL= or PRINT
RankVarStdRes	Ranking of the largest variance standardized residuals	RESIDUAL= or PRINT
RawRes	Raw residual matrix	RESIDUAL= or PRINT
SimpleStatistics	Simple statistics, with raw data input	SIMPLE or default
StdErrs	Vector of standard errors	PRIVEC and default
SumSqDif	Sum of squared differences of predetermined elements	PREDET or PALL
tValues	Vector of t values	PRIVEC and default
VarStdRes	Variance of standardized residual matrix	RESIDUAL= or PRINT
WaldTest	Wald test	MODIFICATION or PALL
Weights	Weight matrix	PWEIGHT or PALL
WeightsDet	Determinant of the weight matrix	PWEIGHT or PALL
ODS Tables Created by the FACTOR, LINEQS, and RAM Models
Determination	Coefficients of determination	PDETERM and default
SqMultCorr	Squared multiple correlations	PESTIM or PSHORT
ODS Tables Created by the COSAN and FACTOR Models
EstParms	Estimated parameter matrix	PESTIM or PSHORT
InitParms	Initial matrix of parameter estimates	PINITIAL or default
ODS Tables Created by the LINEQS and RAM Models
Indirect Effects	Indirect effects	TOTEFF or PRINT
InitParms	Initial matrix of parameter estimates	PRIMAT and default
LatentScoreCoef	Latent variable regression score coefficients	PLATCOV or PRINT
PredMomentLatent	Predicted latent variable moments	PLATCOV or PRINT
PredMomentManLat	Predicted manifest and latent variable moments	PLATCOV or PRINT
SetCovExog	Set covariance parameters for manifest exogenous variables	PINITIAL or default
Stability	Stability of reciprocal causation	PDETERM and default
StructEq	Variables in the structural equations	PDETERM and default
TotalEffects	Total effects	TOTEFF or PRINT
VarSelection	Manifest variables, if not all are used, selected for modeling
ODS Tables Created by the FACTOR Model
FactCorrExog	Correlations among factors	PESTIM or PSHORT
FactScoreCoef	Factor score regression coefficients	PESTIM or PSHORT
RotatedLoadings	Rotated loadings, with ROTATE= option in FACTOR statement	PESTIM or PSHORT
Rotation	Rotation matrix, with ROTATE= option in FACTOR statement	PESTIM or PSHORT
StdLoadings	Standardized factor loadings	PESTIM or PSHORT
ODS Tables Created by the LINEQS Model
CorrExog	Correlations among exogenous variables	PESTIM or PSHORT
EndogenousVar	Endogenous variables	PESTIM or PSHORT
EstCovExog	Estimated covariances among exogenous variables	PESTIM or PSHORT
EstLatentEq	Estimated latent variable equations	PESTIM or PSHORT
EstManifestEq	Estimated manifest variable equations	PESTIM or PSHORT
EstVarExog	Estimated variances of exogenous variables	PESTIM or PSHORT
ExogenousVar	List of exogenous variables	PESTIM or PSHORT
InCovExog	Input covariances among exogenous variables	PESTIM or PSHORT
InLatentEq	Input latent variable equations	PESTIM or PSHORT
InManifestEq	Input manifest variable equations	PESTIM or PSHORT
InVarExog	Input variances of exogenous variables	PESTIM or PSHORT
StdLatentEq	Standardized latent variable equations	PESTIM or PSHORT
StdManifestEq	Standardized manifest variable equations	PESTIM or PSHORT
ODS Tables Created by the RAM Model
InitRAMEstimates	Initial RAM estimates	PESTIM or PSHORT
RAMCorrExog	Correlations among exogenous variables	PESTIM or PSHORT
RAMEstimates	RAM final estimates	PESTIM or PSHORT
RAMStdEstimates	Standardized estimates	PESTIM or PSHORT

Table 10.29: ODS Table Names Produced by the CANCORR Procedure
Table Name	Description	Option
MultStat	Multivariate statistics
ODS Tables Created by PROC CANCORR
AvgRSquare	Average R-Squares (weighted and unweighted)	VDEP (or WDEP) or SMC (or ALL)
CanCorr	Canonical correlations
CanStructureVCan	Correlations between the VAR canonical variables and the VAR and WITH variables	default (unless SHORT)
CanStructureWCan	Correlations between the WITH canonical variables and the WITH and VAR variables	default (unless SHORT)
ConfidenceLimits	95% confidence limits for the regression coefficients	VDEP (or WDEP) or CLB (or ALL)
Corr	Correlations among the original variables	CORR (or ALL)
CorrRegCoefEst	Correlations among the regression coefficient estimates	VDEP (or WDEP) or CORRB (or ALL)
NObsNVar	Number of observations and variables	SIMPLE (or ALL)
ParCorr	Partial correlations	VDEP (or WDEP) or PCORR (or ALL)
ProbtRegCoef	Prob > \|t\| for the regression coefficients	VDEP (or WDEP) or PROBT (or ALL)
RawCanCoefV	Raw canonical coefficients for the VAR variables	default (unless SHORT)
RawCanCoefW	Raw canonical coefficients for the WITH variables	default (unless SHORT)
RawRegCoef	Raw regression coefficients	VDEP (orWDEP)orB(orALL)
Redundancy	Canonical redundancy analysis	REDUNDANCY (or ALL)
Regression	Squared multiple correlations and F tests	VDEP (or WDEP) or SMC (or ALL)
SemiParCorr	Semi-partial correlations	VDEP (or WDEP) or SPCORR (or ALL)
SimpleStatistics	Simple statistics	SIMPLE (or ALL)
SqMultCorr	Canonical redundancy analysis: squared multiple correlations	REDUNDANCY (or ALL)
SqParCorr	Squared partial correlations	VDEP (or WDEP) or SQPCORR (or ALL)
SqSemiParCorr	Squared semi-partial correlations	VDEP (or WDEP) or SQSPCORR (or ALL)
StdCanCoefV	Standardized canonical coefficients for the VAR variables	default (unless SHORT)
StdCanCoefW	Standardized canonical coefficients for the WITH variables	default (unless SHORT)
StdErrRawRegCoef	Standard errors of the raw regression coefficients	VDEP (or WDEP) or SEB (or ALL)
StdRegCoef	Standardized regression coefficients	VDEP (or WDEP) or STB (or ALL)
tValueRegCoef	t values for the regression coefficients	VDEP (or WDEP)orT (orALL)
ODS Tables Created by the PARTIAL Statement
CorrOnPartial	Partial correlations	CORR (or ALL)
RSquareRMSEOnPartial	R-Squares and RMSEs on PARTIAL	CORR (or ALL)
StdRegCoefOnPartial	Standardized regression coefficients on PARTIAL	CORR (or ALL)

Table 10.30: ODS Table Names Produced by the CANDISC Procedure
Table Name	Description	Option
ANOVA	Univariate statistics	ANOVA
AveRSquare	Average R-Square	ANOVA
BCorr	Between-class correlations	BCORR
BCov	Between-class covariances	BCOV
BSSCP	Between-class SSCP matrix	BSSCP
BStruc	Between canonical structure
CanCorr	Canonical correlations
CanonicalMeans	Class means on canonical variables
Counts	Number of observations, variables, classes, DF
CovDF	DF for covariance matrices, not printed	any *COV option
Dist	Squared distances	MAHALANOBIS
DistFValues	F statistics based on squared distances	MAHALANOBIS
DistProb	Probabilities for F statistics from squared distances	MAHALANOBIS
Levels	Class level information
MultStat	MANOVA
PCoef	Pooled standard canonical coefficients
PCorr	Pooled within-classcorrelations	PCORR
PCov	Pooled within-class covariances	PCOV
PSSCP	Pooled within-class SSCP matrix	PSSCP
PStdMeans	Pooled standardized class means	STDMEAN
PStruc	Pooled within canonical structure
RCoef	Raw canonical coefficients
SimpleStatistics	Simple statistics	SIMPLE
TCoef	Total-sample standard canonical coefficients
TCorr	Total-sample correlations	TCORR
TCov	Total-sample covariances	TCOV
TSSCP	Total-sample SSCP matrix	TSSCP
TSTDMeans	Total standardized class means	STDMEAN
TStruc	Total canonical structure
WCorr	Within-class correlations	WCORR
WCov	Within-class covariances	WCOV
WSSCP	Within-class SSCP matrices	WSSCP

Table 10.31: ODS Table Names Produced by the CATMOD Procedure
Table Name	Description	Option
ODS Tables Created by the MODEL Statement
ANOVA	Analysis of variance
ConvergenceStatus	Convergence status	ML
CorrB	Correlation matrix of the estimates	CORRB
CovB	Covariance matrix of the estimates	COVB
Estimates	Analysis of estimates	default, unless NOPARM
MaxLikelihood	Maximum likelihood analysis	ML
OneWayFreqs	One-way frequencies	ONEWAY
PopProfiles	Population profiles	default, unless NOPROFILE
PredictedFreqs	Predicted frequencies	PRED=FREQ
PredictedProbs	Predicted probabilities	PREDICT or PRED=PROB
PredictedValues	Predicted values	PREDICT or PRED=
ResponseCov	Response functions, covariance matrix	COV
ResponseDesign	Response functions, design matrix	WLS, unless NODESIGN
ResponseFreqs	Response frequencies	FREQ
ResponseProbs	Response probabilities	PROB
ResponseProfiles	Response profiles	default, unless NOPROFILE
XPX	X Inv(S)X matrix	XPX, for WLS
ODS Tables Created by the CONTRAST Statement
Contrasts	Contrasts
ContrastEstimates	Analysis of contrasts	ESTIMATE=
ODS Tables Created by the PROC Statement
DataSummary	Data summary
ODS Tables Created by the MODEL and LOGLIN Statements
ResponseMatrix	_RESPONSE_ matrix	unless NORESPONSE

Table 10.32: ODS Table Names Produced by the CLUSTER Procedure
Table Name	Description	Option
ODS Tables Created by the PROC Statement
ClusterHistory	Observations or clusters joined, frequencies and other cluster statistics
SimpleStatistics	Simple statistics, before or after trimming	SIMPLE
EigenvalueTable	Eigenvalues of the CORR or COV matrix

Table 10.33: ODS Table Names Produced by the CORRESP Procedure
Table Name	Description	Option
AdjInGreenacre	Greenacre inertia adjustment	GREENACRE
AdjInBenzecri	Benzecri inertia adjustment	BENZECRI
Binary	Binary table	OBSERVED or BINARY
BinaryPct	Binary table percents	OBSERVED or BINARY
Burt	Burt table	OBSERVED or MCA
BurtPct	Burt table percents	OBSERVED or MCA
CellChiSq	Contributions to Chi Square	CELLCHI2
CellChiSqPct	Contributions, percents	CELLCHI2
ColBest	Col best indicators
ColContr	Col contributions to inertia
ColCoors	Col coordinates
ColProfiles	Col profiles	CP
ColProfilesPct	Col profiles, percents	CP
ColQualMassIn	Col quality, mass, inertia
ColSqCos	Col squared cosines
DF	DF, Chi Square (not displayed)
Deviations	Observed ” expected frequencies	DEVIATIONS
DeviationsPct	Observed ” expected percentages	DEVIATIONS
Expected	Expected frequencies	EXPECTED
ExpectedPct	Expected percents	EXPECTED
Intertias	Inertia decomposition table
Observed	Observed frequencies	OBSERVED
ObservedPct	Observed percents	OBSERVED
RowBest	Row best indicators
RowContr	Row contributions to inertia
RowCoors	Row coordinates
RowProfiles	Row profiles	RP
RowProfilesPct	Row profiles, percents	RP
RowQualMassIn	Row quality, mass, inertia
RowSqCos	Row squared cosines
SupColCoors	Supp col coordinates
SupColProfiles	Sup col profiles	CP
SupColProfilesPct	Sup col profiles, percents	CP
SupColQuality	Supp col quality
SupCols	Supplementary col frequency	OBSERVED
SupColsPct	Supplementary col percents	OBSERVED
SupColSqCos	Supplementary col squared cosines
SupRows	Supplementary row frequencies	OBSERVED
SupRowCoors	Supplementary row coordinates
SupRowProfiles	Supplementary row profiles	RP
SupRowProfilesPct	Supplementary row profiles, percents	RP
SupRowQuality	Supplementary row quality
SupRowsPct	Supplementary row percents	OBSERVED
SupRowSqCos	Supplementary row square cosines

Table 10.34: ODS Table Names Produced by the DISCRIM Procedure
Table Name	Description	Option
ANOVA	Univariate statistics	ANOVA
AvePostCrossVal	Average posterior probabilities, cross validation	POSTERR and CROSSVALIDATE
AvePostResub	Average posterior probabilities, resubstitution	POSTERR
AvePostTestClass	Average posterior probabilities, test classification	POSTERR and TEST=
AveRSquare	Average R-Square	ANOVA
BCorr	Between-class correlations	BCORR
BCov	Between-class covariances	BCOV
BSSCP	Between-class SSCP matrix	BSSCP
BStruc	Between canonical structure	CANONICAL
CanCorr	Canonical correlations	CANONICAL
CanonicalMeans	Class means on canonical variables	CANONICAL
ChiSq	Chi-Square information	POOL=TEST
ClassifiedCrossVal	Number of observations and percent classified , cross validation	CROSSVALIDATE
ClassifiedResub	Number of observations and percent classified, resubstitution
ClassifiedTestClass	Number of observations and percent classified, test classification	TEST=
Counts	Number of observations, variables, classes, DF
CovDF	DF for covariance matrices, not displayed	any *COV option
Dist	Squared distances	MAHALONOBIS
DistFValues	F values based on squared distances	MAHALONOBIS
DistGeneralized	Generalized squared distances
DistProb	Probabilities for F values from squared distances	MAHALONOBIS
ErrorCrossVal	Error count estimates, cross validation	CROSSVALIDATE
ErrorResub	Error count estimates, resubstitution
ErrorTestClass	Error count estimates, test classification	TEST=
Levels	Class level information
LinearDiscFunc	Linear discriminant function	POOL=YES
LogDet	Log determinant of the covariance matrix
MultStat	MANOVA	MANOVA
PCoef	Pooled standard canonical coefficients	CANONICAL
PCorr	Pooled within-classcorrelations	PCORR
PCov	Pooled within-class covariances	PCOV
PSSCP	Pooled within-class SSCP matrix	PSSCP
PStdMeans	Pooled standardized class means	STDMEAN
PStruc	Pooled within canonical structure	CANONICAL
PostCrossVal	Posterior probabilities, cross validation	CROSSLIST or CROSSLISTERR
PostErrCrossVal	Posterior error estimates, cross validation	POSTERR and CROSSVALIDATE
PostErrResub	Posterior error estimates, resubstitution	POSTERR
PostErrTestClass	Posterior error estimates, test classification	POSTERR and TEST=
PostResub	Posterior probabilities, resubstitution	LIST or LISTERR
PostTestClass	Posterior probabilities, test classification	TESTLIST or TESTLISTERR
RCoef	Raw canonical coefficients	CANONICAL
SimpleStatistics	Simple statistics	SIMPLE
TCoef	Total-sample standard canonical coefficients	CANONICAL
TCorr	Total-sample correlations	TCORR
TCov	Total-sample covariances	TCOV
TSSCP	Total-sample SSCP matrix	TSSCP
TStdMeans	Total standardized class means	STDMEAN
TStruc	Total canonical structure	CANONICAL
WCorr	Within-class correlations	WCORR
WCov	Within-class covariances	WCOV
WSSCP	Within-class SSCP matrices	WSSCP

Table 10.35: ODS Table Names Produced by the FACTOR Procedure
Table Name	Description	Option
AlphaCoef	Coefficientalpha foreachfactor	METHOD=ALPHA
CanCorr	Squared canonical correlations	METHOD=ML
CondStdDev	Conditional standard deviations	SIMPLE w/PARTIAL
ConvergenceStatus	Convergence status	METHOD=PRINIT, =ALPHA, =ML, or =ULS
Corr	Correlations	CORR
Eigenvalues	Eigenvalues	default or SCREE
Eigenvectors	Eigenvectors	EIGENVECTORS
FactorWeightRotate	Factor weights for rotation	HKPOWER=
FactorPattern	Factor pattern
FactorStructure	Factor structure	ROTATE= any oblique rotation
FinalCommun	Final communalities	default
FinalCommunWgt	Final communalities with weights	METHOD=ML or METHOD=ALPHA
FitMeasures	Measures of fit	METHOD=ML
ImageCoef	Image coefficients	METHOD=IMAGE
ImageCov	Image covariance matrix	METHOD=IMAGE
ImageFactors	Image factor matrix	METHOD=IMAGE
InputFactorPattern	Input factor pattern	METHOD=PATTERN with PRINT or ALL
InputScoreCoef	Standardized input scoring coefficients	METHOD=SCORE with PRINT or ALL
InterFactorCorr	Inter-factor correlations	ROTATE=any oblique rotation
InvCorr	Inverse correlation matrix	ALL
IterHistory	Iteration history	METHOD=PRINIT, =ALPHA, =ML, or =ULS
MultipleCorr	Squared multiple correlations	METHOD=IMAGE or METHOD=HARRIS
NormObliqueTrans	Normalized oblique transformation matrix	ROTATE=any oblique rotation
ObliqueRotFactPat	Rotated factor pattern	ROTATE=any oblique rotation
ObliqueTrans	Oblique transformation matrix	HKPOWER=
OrthRotFactPat	Rotated factor pattern	ROTATE=any orthogonal rotation
OrthTrans	Orthogonal transformational matrix	ROTATE=any orthogonal rotation
ParCorrControlFactor	Partial correlations controlling factors	RESIDUAL
ParCorrControlVar	Partial correlations controlling other variables	MSA
PartialCorr	Partial correlations	MSA or CORR w/PARTIAL
PriorCommunalEst	Prior communality estimates	PRIORS =, METHOD=ML, or METHOD=ALPHA
ProcrustesTarget	Target matrix for Procrustean transformation	ROTATE=PROCRUSTES or ROTATE=PROMAX
ProcrustesTrans	Procrustean transformation matrix	ROTATE=PROCRUSTES or ROTATE=PROMAX
RMSOffDiagPartials	Root mean square off-diagonal partials	RESIDUAL
RMSOffDiagResids	Root mean square off-diagonal residuals	RESIDUAL
ReferenceAxisCorr	Reference axis correlations	ROTATE=any oblique rotation
ReferenceStructure	Reference structure	ROTATE=any oblique rotation
ResCorrUniqueDiag	Residual correlations with uniqueness on the diagonal	RESIDUAL
SamplingAdequacy	Kaiser s measure of sampling adequacy	MSA
SignifTests	Significance tests	METHOD=ML
SimpleStatistics	Simple statistics	SIMPLE
StdScoreCoef	Standardized scoring coefficients	SCORE
VarExplain	Variance explained
VarExplainWgt	Variance explained with weights	METHOD=ML or METHOD=ALPHA
VarFactorCorr	Squared multiple correlations of the variables with each factor	SCORE
VarWeightRotate	Variable weights for rotation	NORM=WEIGHT or ROTATE=

Table 10.36: ODS Table Names Produced by the FASTCLUS Procedure
Table Name	Description	Option
ODS Tables Created by the PROC Statement
ApproxExpOverAllRSq	Approximate expected overall R-Squared, single number
CCC	Cubic clustering criterion, single number
ClusterList	Cluster listing, obs, ID, and distances	LIST
ClusterSum	Cluster summary, cluster number, distances	PRINTALL
ClusterCenters	Cluster centers
ClusterDispersion	Cluster dispersion
ConvergenceStatus	Convergence status	PRINTALL
Criterion	Criterion based on final seeds , single number
DistBetweenClust	Distance between clusters
InitialSeeds	Initial seeds
IterHistory	Iteration history, various statistics for each iteration	PRINTALL
MinDist	Minimum distance between initial seeds, single number	PRINTALL
NumberOfBins	Number of bins
ObsOverAllRSquare	Observed overall R-Squared. single number	SUMMARY
PrelScaleEst	Preliminary L(1) scale estimate, single number	PRINTALL
PseudoFStat	Pseudo F statistic, single number
SimpleStatistics	Simple statistics for input variables
VariableStat	Statistics for variables within clusters

Table 10.37: ODS Table Names Produced by the GAM Procedure
Table Name	Description	Option
ODS Tables Created by the PROC Statement
ANODEV	Analysis of deviance table for smoothing variables
ClassSummary	Summary of class variables
InputSummary	Data summary
IterSummary	Iteration summary
FitSummary	Fit parameters and fit summary
ParameterEstimates	Parameter estimation for regression variables
ODS Tables Created by the MODEL Statement
Iteration	Iteration history table	ITPRINT

Table 10.38: ODS Table Names Produced by the GENMOD Procedure
Table Name	Description	Option
ODS Tables Created by the CLASS Statement
ClassLevels	Class variable levels
ODS Tables Created by the CONTRAST Statement
Contrasts	Tests of contrasts
ContrastCoef	Contrast coefficients	E
LinDep	Linearly dependent rows of contrasts
NonEst	Nonestimable rows of contrasts
ODS Tables Created by the MODEL Statement
ConvergenceStatus	Convergence status
CorrB	Parameter estimate correlation matrix	CORRB
CovB	Parameter estimate covariance matrix	COVB
IterLRCI	Iteration history for likelihood ratio confidence intervals	LRCI ITPRINT
IterParms	Iteration history for parameter estimates	ITPRINT
IterType3	Iteration history for Type 3 statistics	TYPE3 ITPRINT
LRCI	Likelihood ratio confidence intervals	LRCI ITPRINT
LagrangeStatistics	Lagrange statistics	NOINT or NOSCALE
LastGradHess	Last evaluation of the gradient and Hessian	ITPRINT
ModelInfo	Model information
Modelfit	Goodness-of-fit statistics
ObStats	Observation-wise statistics	OBSTATS, CL, PREDICTED, RESIDUALS, or XVARS
ParameterEstimates	Parameter estimates
ParmInfo	Parameter indices
ResponseProfiles	Frequency counts for multinomial models	DIST=MULTINOMIAL
Type1	Type 1 tests	TYPE1
Type3	Type 3 tests	TYPE3
ODS Tables Created by the ESTIMATE Statement
Estimates	Estimates of contrasts
EstimateCoef	Contrast coefficients	E
ODS Tables Created by the REPEATED Statement
GEEEmpPEst	GEE parameter estimates with empirical standard errors
GEELogORInfo	GEE log odds ratio model information	LOGOR=
GEEModInfo	GEE model information
GEEModPEst	GEE parameter estimates with model-based standard errors	MODELSE
GEENCorr	GEE model-based correlation matrix	MCORRB
GEENCov	GEE model-based covariance matrix	MCOVB
GEERCorr	GEE empirical correlation matrix	ECORRB
GEERCov	Gee empirical covariance matrix	ECOVB
GEEWCorr	GEE working correlation matrix	CORRW
ODS Tables Created by the MODEL CONTRAST Statement
IterContrasts	Iteration history for contrasts	ITPRINT
ODS Tables Created by the MODEL REPEATED Statement
IterParmsGEE	Iteration history for GEE parameter estimates	ITPRINT
LastGEEGrad	Last evaluation of the generalized gradient and Hessian	ITPRINT
ODS Tables Created by the LSMEANS Statement
LSMeanCoef	Coefficients for least squares means	E
LSMeanDiffs	Least squares means differences	DIFF
LSMeans	Least squares means

Table 10.39: ODS Table Names Produced by the GLM Procedure
Table Name	Description	Option
DependentInfo	Simultaneously analyzed dependent variables	default when there are multiple dependent variables with different patterns of missing values
FitStatistics	R-Square, C.V., root MSE, and dependent mean
MatrixRepresentation	X matrix element representation	as needed for other options
ModelANOVA	ANOVA for model terms
NObs	Number of observations
OverallANOVA	Overall ANOVA
ODS Tables Created by the CLASS Statement
ClassLevels	Classification variable levels
ODS Tables Created by the CONTRAST Statement
AltErrContrasts	ANOVA table for contrasts with alternative error	E=
ContrastCoef	L matrix for contrast	EST
Contrasts	ANOVA table for contrasts
ODS Tables Created by the ESTIMATE Statement
Estimates	Estimate statement result
ODS Tables Created by the LSMEANS Statement
Diff	PDiff matrix of least-squares means	PDIFF
LSMeanCL	Confidence interval for LS-means	CL
LSMeanCoef	Coefficients of least-squares means	E
LSMeanDiffCL	Confidence interval for LS-mean differences	PDIFF and CL
LSMeans	Least-squares means
SimDetails	Details of difference quantile simulation	ADJUST=SIMULATE(REPORT)
SimResults	Evaluation of difference quantile simulation	ADJUST=SIMULATE(REPORT)
SlicedANOVA	Sliced effect ANOVA table	SLICE
ODS Tables Created by the MEANS Statement
Bartlett	Bartlett s homogeneity of variance test	HOVTEST=BARTLETT
CLDiffs	Multiple comparisons of pairwise differences	CLDIFF, DUNNETT, or (Unequal cells and not LINES)
CLDiffsInfo	Information for multiple comparisons of pairwise differences	CLDIFF, DUNNETT, or (Unequal cells and not LINES)
CLMeans	Multiple comparisons of means with confidence/comparison interval	CLM
CLMeansInfo	Information for multiple comparison of means with confidence/comparison interval	CLM
HOVFTest	Homogeneity of variance ANOVA	HOVTEST
MCLines	Multiple comparisons LINES output	LINES, ((DUNCAN, WALLER, SNK, or REGWQ) and not (CLDIFF or CLM)), or (Equal cells and not CLDIFF)
MCLinesInfo	Information for multiple comparison LINES output	LINES, ((DUNCAN, WALLER, SNK, or REGWQ) and not (CLDIFF or CLM)), or (Equal cells and not CLDIFF)
MCLinesRange	Ranges for multiple range MC tests	LINES, ((DUNCAN, WALLER, SNK, or REGWQ) and not (CLDIFF or CLM)), or (Equal cells and not CLDIFF)
Means	Group means
Welch	Welch s ANOVA	WELCH
ODS Tables Created by the MODEL Statement
Aliasing	Type 1, 2, 3, 4 aliasing structure	(E1, E2, E3, or E4) and ALIASING
EstFunc	Type 1, 2, 3, 4 estimable functions	E1, E2, E3, or E4
GAliasing	General form of aliasing structure	E and ALIASING
GEstFunc	General form of estimable functions	E
InvXPX	Inv(X X) matrix	INVERSE
ParameterEstimates	Estimated linear model coefficients	SOLUTION
PredictedInfo	Predicted values info	PREDICTED, CLM, or CLI
PredictedValues	Predicted values	PREDICTED, CLM, or CLI
Tolerances	X X tolerances	TOLERANCE
XPX	X X matrix	XPX
ODS Tables Created by the MANOVA or REPEATED Statements
CanAnalysis	Canonical analysis	CANONICAL
CanCoef	Canonical coefficients	CANONICAL
CanStructure	Canonical structure	CANONICAL
ErrorSSCP	Error SSCP matrix	PRINTE
HypothesisSSCP	Hypothesis SSCP matrix	PRINTH
PartialCorr	Partial correlation matrix	PRINTE
ODS Tables Created by the MANOVA Statement
CharStruct	Characteristic roots and vectors not	CANONICAL
MANOVATransform	Multivariate transformation matrix	M=
MultStat	Multivariate tests
Tests	Summary ANOVA for specified MANOVA H= effects	H=SUMMARY
ODS Tables Created by the RANDOM Statement
ExpectedMeanSquares	Expected mean squares
QForm	Quadratic form for expected mean squares	Q
RandomModelANOVA	Random effect tests	TEST
ODS Tables Created by the REPEATED Statement
CharStruct	Characteristic roots and vectors	PRINTRV
Epsilons	Greenhouse-Geisser and Huynh-Feldt epsilons
RepeatedLevelInfo	Correspondence between dependents and repeated measures levels
RepeatedTransform	Repeated measures transformation matrix	PRINTM
Sphericity	Sphericity tests	PRINTE
ODS Tables Created by the TEST Statement
AltErrTests	ANOVA table for tests with alternative error	E=

Table 10.40: ODS Table Names Produced by the GLMMOD Procedure
Table Name	Description	Option
DependentInfo	Simultaneously analyzed dependent variables	default when there are multiple dependent variables
DesignPoints	Design matrix
NObs	Number of observations
Parameters	Parameters and associated column numbers
ODS Tables Created by the CLASS Statement
ClassLevels	Table of class levels

Table 10.41: ODS Table Names Produced by the INBREED Procedure
Table Name	Description	Option
ODS Tables Created by the GENDER Statement
AvgCovCoef	Averages of covariance coefficient matrix	COVAR and AVERAGE
AvgInbreedingCoef	Averages of inbreeding coefficient matrix	AVERAGE
ODS Tables Created by the MATINGS Statement
MatingCovCoef	Covariance coefficients of matings	COVAR
MatingInbreedingCoef	Inbreeding coefficients of matings
ODS Tables Created by the PROC Statement
CovarianceCoefficient	Covariance coefficient table	COVAR
InbreedingCoefficient	Inbreeding coefficient table
IndividualCovCoef	Inbreeding coefficients of individuals	IND and COVAR
IndividualInbreedingCoef	Inbreeding coefficients of individuals	IND
NumberOfObservations	Number of observations

Table 10.42: ODS Table Names Produced by the KDE Procedure
Table Name	Description
BivariateStatistics	Bivariate statistics
Controls	Control variables
Inputs	Input information
Levels	Levels of density estimate
Percentiles	Percentiles of data
Statistics	Basic statistics

Table 10.43: ODS Table Names Produced by the LATTICE Procedure
Table Name	Description
ANOVA	Analysis of variance
AdjTreatmentMeans	Adjusted treatment means
Statistics	Additional statistics

Table 10.44: ODS Table Names Produced by the LIFEREG Procedure
Table Name	Description	Option
ODS Tables Created by the CLASS Statement
ClassLevels	Class variable levels
ODS Tables Created by the MODEL Statement
ConvergenceStatus	Convergence status
CorrB	Parameter estimate correlation matrix	CORRB
CovB	Parameter estimate covariance matrix	COVB
IterHistory	Iteration history	ITPRINT
LagrangeStatistics	Lagrange statistics	NOINT or NOSCALE
LastGrad	Last evaluation of the gradient	ITPRINT
LastHess	Last evaluation of the Hessian	ITPRINT
ModelInfo	Model information
ParameterEstimates	Parameter estimates
ParmInfo	Parameter indices
Type3Analysis	Type 3 tests
ODS Tables Created by the PROBPLOT Statement
EMIterHistory	Iteration history for Turnbull algorithm	ITPRINTEM
ProbEstimates	Nonparametric CDF estimates	PPOUT
Turnbull	Probability estimates from Turnbull algorithm	ITPRINTEM

Table 10.45: ODS Table Names Produced by the LIFETEST Procedure
Table Name	Description	Option
ODS Tables Created by the PROC Statement
CensorPlot	Line-printer plot of censored observations	PLOT=(C, S, LS or LLS), METHOD=PL, and LINEPRINTER
CensoredSummary	Number of event and censored observations	METHOD=PL
DensityPlot	Plot of the density	PLOT=(D) and METHOD=LT
HazardPlot	Plot of the hazards function	PLOT=(H) and METHOD=LT
LifetableEstimates	Lifetable survival estimates	METHOD=LT
LogLogSurvivalPlot	Plot of the log of the negative log survivor function	PLOT=(LLS)
LogSurvivalPlot	Plot ofthe logsurvivor function	PLOT=(LS)
Means	Mean and standard error of survival times	METHOD=PL
ProductLimitEstimates	Product-limit survival estimates	METHOD=PL
Quartiles	Quartiles of the survival distribution	METHOD=PL
SurvivalPlot	Plot of the survivor function	PLOT=(S)
ODS Tables Created by the STRATA Statement
HomStats	Rank statistics for testing strata homogeneity
HomTests	Tests for strata homogeneity
LogHomCov	Covariance matrix for the log-rank statistics for strata homogeneity
WilHomCov	Covariance matrix for the Wilcoxon statistics for strata homogeneity
ODS Tables Created by the TEST Statement
LogForStepSeq	Forward stepwise sequence for the log-rank statistics for association
LogTestCov	Covariance matrix for log-rank statistics for association
LogUniChisq	Univariate Chi-Squares for log-rank statistic for association
WilForStepSeq	Forward stepwise sequence for the log-rank statistics for association
WilTestCov	Covariance matrix for log-rank statistics for association
WilUniChiSq	Univariate Chi-Squares for Wilcoxon statistic for association

Table 10.46: ODS Table Names Produced by the LOESS Procedure
Table Name	Description	Option
FitSummary	Specified fit parameters and fit summary
ScaleDetails	Extent and scaling of the independent variables
ODS Tables Created by the MODEL Statement
kdTree	Structure of kd tree used	DETAILS(kdTree)
ModelSummary	Summary of all models evaluated	DETAILS(ModelSummary)
OutputStatistics	Coordinates and fit results at input data points	DETAILS(OutputStatistics)
PredAtVertices	Coordinates and fitted values at kd tree vertices	DETAILS(PredAtVertices)
SmoothingCriterion	Criterion value and selected smoothing parameter	SELECT
ODS Tables Created by the SCORE Statement
ScoreResults	Coordinates and fit results at scoring points	PRINT

Table 10.47: ODS Table Names Produced by the LOGISTIC Procedure
Table Name	Description	Option
ODS Tables Created by the CONTRAST Statement
ContrastCoeff	L matrix from CONTRAST	E
ContrastEstimate	Estimates from CONTRAST	ESTIMATE=
ContrastTest	Wald test for CONTRAST
ODS Tables Created by the EXACT Statement
ExactOddsRatio	Exact odds ratio	ESTIMATE=ODDS or ESTIMATE=BOTH
ExactParmEst	Parameter estimates	ESTIMATE, ESTIMATE=PARM, or ESTIMATE=BOTH
ExactTests	Conditional exact tests
SuffStats	Sufficient statistics	OUTDIST=
ODS Tables Created by the MODEL Statement
Association	Association of predicted probabilities and observed responses
BestSubsets	Best subset selection	SELECTION=SCORE
ClassLevelInfo	CLASS variable levels and design variables	default (with CLASS variables)
Classification	Classification table	CTABLE
CLOddsPL	Profile likelihood confidence limits for odds ratios	CLODDS=PL
CLOddsWald	Wald s confidence limits for odds ratios	CLODDS=WALD
CLParmPL	Profile likelihood confidence limits for parameters	CLPARM=PL
CLParmWald	Wald s confidence limits for parameters	CLPARM=WALD
ConvergenceStatus	Convergence status
CorrB	Estimated correlation matrix of parameter estimators	CORRB
CovB	Estimated covariance matrix of parameter estimators	COVB
CumulativeModelTest	Test of the cumulative model assumption	(ordinal response)
EffectNotInModel	Test for effects not in model	SELECTION=S or F
FastElimination	Fast backward elimination	SELECTION=B, FAST
FitStatistics	Model fit statistics
GlobalScore	Global score test	NOFIT
GlobalTests	Test for global null hypothesis
GoodnessOfFit	Pearson and deviance goodness-of-fit tests	SCALE
IndexPlots	Batch capture of the index plots	IPLOTS
Influence	Regression diagnostics	INFLUENCE
IterHistory	Iteration history	ITPRINT
LackFitChiSq	Hosmer-Lemeshow Chi-Square test results	LACKFIT
LackFItPartition	Partition for the Hosmer-Lemeshow test	LACKFIT
LastGradient	Last evaluation of gradient	ITPRINT
LogLikeChange	Final change in the log likelihood	ITPRINT
ModelBuildingSummary	Summary of model building	SELECTION=B, F, or S
OddsRatios	Odds ratios
ParameterEstimates	Maximum likelihood estimates of model parameters
RSquare	R-Square	RSQUARE
ResidualChiSq	Residual Chi-Square	SELECTION=F or B
Type3	Type 3 tests of effects	default (with CLASS variables)
ODS Tables Created by the PROC Statement
ClassFreq	Frequency breakdown of CLASS variables	SIMPLE
ClassWgt	Weight breakdown of CLASS variables	SIMPLE
ModelInfo	Model information
ResponseProfile	Response profile
SimpleStatistics	Summary statistics for explanatory variables	SIMPLE
ODS Tables Created by the STRATA Statement
StrataSummary	Number of strata with specific response frequencies
StrataInfo	Event and non-event frequencies for each stratum	INFO
ODS Tables Created by the TEST Statement
TestPrint1	L[cov(b)]L and Lb-c	PRINT
TestPrint2	Ginv(L[cov(b)]L) and Ginv(L[cov(b)]L)(Lb-c)	PRINT
TestStmts	Linear hypothesis testing results
ODS Tables Created by the WEIGHT Statement
ClassWgt	Weight breakdown of CLASS variables	SIMPLE

Table 10.48: ODS Table Names Produced by the MDS Procedure
Table Name	Description	Option
ConvergenceStatus	Convergence status
DimensionCoef	Dimension coefficients	PCOEF w/COEF= not IDENTITY
FitMeasures	Measures of fit	PFIT
IterHistory	Iteration history
PConfig	Estimated coordinates of the objects in the configuration	PCONFIG
PData	Data matrices	PDATA
PInAvData	Initial sum of weights and weighted average of data matrices with INAV=DATA	PINAVDATA
PInEigval	Initial eigenvalues	PINEIGVAL
PInEigvec	Initial eigenvectors	PINEIGVEC
PInWeight	Initialization weights	PINWEIGHT
Transformations	Transformation parameters	PTRANS w/LEVEL=RATIO, INTERVAL, or LOGINTERVAL

Table 10.49: ODS Table Names Produced by the MI Procedure
Table Name	Description	Option
Corr	Pairwise correlations	SIMPLE
MissPattern	Missing data patterns
ModelInfo	Model information
ParameterEstimates	Parameter estimates
Univariate	Univariate statistics	SIMPLE
VarianceInfo	Between, within, and total variances
ODS Tables Created by the EM Statement
EMEstimates	EM (MLE) estimates
EMInitEstimates	EM initial estimates
EMIterHistory	EM (MLE) iteration history	ITPRINT
ODS Tables Created by the MCMC Statement
EMPostEstimates	EM (posterior mode) estimates	INITIAL=EM
EMPostIterHistory	EM (posterior mode) iteration history	INITIAL=EM (ITPRINT)
EMWLF	Worst linear function	WLF
MCMCInitEstimates	MCMC initial estimates	DISPLAYINIT
ODS Tables Created by the MONOTONE Statement
MonoDiscrim	Discriminant model group means	DISCRIM (/DETAILS)
MonoLogistic	Logistic model	LOGISTIC (/DETAILS)
MonoModel	Multiple monotone models
MonoPropensity	Propensity score model logistic function	PROPENSITY (/DETAILS)
MonoReg	Regression model	REG (/DETAILS)
MonoRegPPM	Predicted mean matching model	REGPMM (/DETAILS)
ODS Tables Created by the TRANSFORM Statement
Transform	Variable transformations

Table 10.50: ODS Table Names Produced by the MIANALYZE Procedure
Table Name	Description	Option
BCov	Between-imputation covariance matrix	BCOV
ModelInfo	Model information
MultStat	Multivariate inference	MULT
ParameterEstimates	Parameter estimates
TCov	Total covariance matrix	TCOV
VarianceInfo	Variance information
WCov	Within-imputation covariance matrix	WCOV
ODS Tables Created by the TEST Statement
TestBCov	Between-imputation covariance matrix for L ²	BCOV
TestMultStat	Multivariate inference for L ²	MULT
TestParameterEstimates	Parameter estimates for L ²
TestSpec	Test specification, L and c
TestTCov	Total covariance matrix for L ²	TCOV
TestVarianceInfo	Variance information for L ²
TestWCov	Within ”imputation covariance matrix for L ²	WCOV

Table 10.51: ODS Table Names Produced by the MODECLUS Procedure
Table Name	Description	Option
ODS Tables Created by the PROC Statement
BoundaryFreq	Boundary objects information	BOUNDARY (or ALL)
ClusterList	Cluster listing, cluster ID, frequency, density, etc.	LIST (or ALL)
ClusterStats	Cluster statistics
ClusterStats	Cluster statistics, significance test statistics	TEST or JOIN (or ALL)
ClusterSummary	Cluster summary
ClusterSummary	Cluster summary, crossvalidation criterion	CROSS or CROSSLIST (or ALL)
ClusterSummary	Cluster summary, clusters joined information	JOIN (or ALL)
CrossList	Cross- validated log density	CROSSLIST
ListLocal	Local dimensionality estimates	LOCAL
Neighbor	Nearest neighbor list	NEIGHBOR (or ALL)
SimpleStatistics	Simple statistics	SIMPLE (or ALL)
Trace	Trace of clustering algorithm (METHOD=6 only)	TRACE (or ALL) with METHOD=6
UnassignObjects	Information on unassigned objects	LIST (or ALL)

Table 10.52: ODS Table Names Produced by the MULTTEST Procedure
Table Name	Description	Option
Continuous	Continuous variable tabulations	TEST with MEAN
Contrasts	Contrast coefficients
Discrete	Discrete variable tabulations	TEST with CA, FT, PETO, or FISHER
ModelInfo	Model information
pValues	p-values from the tests

Table 10.53: ODS Table Names Produced by the NESTED Procedure
Table Name	Description
ANCOVA	Analysis of covariance
ANOVA	Analysis of variance
EMSCoef	Coefficients of expected mean squares
Statistics	Overall statistics for fit

Table 10.54: ODS Table Names Produced by the NLIN Procedure
Table Name	Description
ANOVA	Analysis of variance
ConvergenceStatus	Convergence status
CorrB	Correlation of the parameters
EstSummary	Summary of the estimation
IterHistory	Iteration output
MissingValues	Missing values generated by the program
ParameterEstimates	Parameter estimates
ODS Tables Created by the LIST Statement
ProgList	List of the compiled program
ODS Tables Created by the LISTCODE Statement
CodeList	List of program statements
ODS Tables Created by the LISTDEP Statement
CodeDependency	Variable cross reference
ODS Tables Created by the LISTDER Statement
FirstDerivatives	First derivative table

Table 10.55: ODS Table Names Produced by the NLMIXED Procedure
Table Name	Description	Option
AdditionalEstimates	Results from ESTIMATE statements	ESTIMATE
ConvergenceStatus	Convergence status
CorrMatAddEst	Correlation matrix of additional estimates	ECORR
CorrMatParmEst	Correlation matrix of parameter estimates	CORR
CovMatAddEst	Covariance matrix of additional estimates	ECOV
CovMatParmEst	Covariance matrix of parameter estimates	COV
DerAddEst	Derivatives of additional estimates	EDER
Dimensions	Dimensions of the problem
FitStatistics	Fit statistics
Hessian	Second derivative matrix	HESS
IterHistory	Iteration history
Parameters	Parameters
ParameterEstimates	Parameter estimates
Specifications	Model specifications
StartingHessian	Starting hessian matrix	START HESS
StartingValues	Starting values and gradient	START

Table 10.56: ODS Table Names Produced by the NPAR1WAY Procedure
Table Name	Description	Option
ODS Tables Created by the EXACT Statement
ABMC	Monte Carlo estimates for the Ansari-Bradley exact test	AB or MC
DataScoresMC	Monte Carlo estimates for the exact test based on data scores	SCORES=DATA or MC
KlotzMC	Monte Carlo estimates for the Klotz exact test	KLOTZ or MC
KolSmirExactTest	Kolmogorov-Smirnov exact test	KS
KruskalWallisMC	Monte Carlo estimates for the Kruskal-Wallis exact test	WILCOXON or MC
KSMC	Monte Carlo estimates for the Kolmogorov-Smirnov exact test	KS or MC
MedianMC	Monte Carlo estimates for the median exact test	MEDIAN or MC
MoodMC	Monte Carlo estimates for the Mood exact test	MOOD or MC
SavageMC	Monte Carlo estimates for the Savage exact test	SAVAGE or MC
STMC	Monte Carlo estimates for the Siegel-Tukey one-way analysis	ST or MC
VWMC	Monte Carlo estimates for the Van der Waerden exact test	VW or MC
WilcoxonMC	Monte Carlo estimates for the Wilcoxon two-sample exact test	WILCOXON or MC
ODS Tables Created by the PROC Statement
ANOVA	Analysis of variance	ANOVA
ABAnalysis	Ansari-Bradley one-way analysis	AB
ABScores	Ansari-Bradley scores	AB
ABTest	Ansari-Bradley two-sample test	AB
ClassMeans	Class means	ANOVA
CVMStats	Cramer-von Mises statistics	EDF
CVMTest	Cramer-von Mises test	EDF
DataScores	Data scores	SCORES=DATA
DataScoresAnalysis	Data scores one-way analysis	SCORES=DATA
DataScoresTest	Data scores two-sample test	SCORES=DATA
KlotzAnalysis	Klotz one-way analysis	KLOTZ
KlotzScores	Klotz scores	KLOTZ
KlotzTest	Klotz two-sample test	KLOTZ
KolSmir2Stats	Kolmogorov-Smirnov two-sample statistics	EDF
KolSmirStats	Kolmogorov-Smirnov statistics	EDF
KolSmirTest	Kolmogorov-Smirnov test	EDF
KruskalWallisTest	Kruskal-Wallis test	WILCOXON
KuiperStats	Kuiper two-sample statistics	EDF
KuiperTest	Kuiper test	EDF
MedianAnalysis	Median one-way analysis	MEDIAN
MedianScores	Median scores	MEDIAN
MedianTest	Median two-sample test	MEDIAN
MoodAnalysis	Mood one-way analysis	MOOD
MoodScores	Mood scores	MOOD
MoodTest	Mood two-sample test	MOOD
SavageAnalysis	Savage one-way analysis	SAVAGE
SavageScores	Savage scores	SAVAGE
SavageTest	Savage two-sample test	SAVAGE
STAnalysis	Siegel-Tukey one-way analysis	ST
STScores	Siegel-Tukey scores	ST
STTest	Siegel-Tukey two-sample test	ST
VWAnalysis	Van der Waerden one-way analysis	VW
VWScores	Van der Waerden scores	VW
VWTest	Van der Waerden two-sample test	VW
WilcoxonScores	Wilcoxon scores	WILCOXON
WilcoxonTest	Wilcoxon two-sample test	WILCOXON

Table 10.57: ODS Table Names Produced by the ORTHOREG Procedure
Table Name	Description
ANOVA	Analysis of variance
FitStatistics	Overall statistics for fit
ParameterEstimates	Parameter estimates
ODS Tables Created by the CLASS Statement
Levels	Table of class levels

Table 10.58: ODS Table Names Produced by the PPHREG Procedure
Table Name	Description	Option
ODS Tables Created by the MODEL Statement
BestSubsets	Best subset selection	SELECTION=SCORE
CensoredSummary	Summary of event and censored observations
ConvergenceStatus	Convergence status
CorrB	Estimated correlation matrix of parameter estimators	CORRB
CovB	Estimated covariance matrix of parameter estimators	COVB
FitStatistics	Model fit statistics
GlobalScore	Global Chi-Square test	NOFIT
GlobalTests	Tests of the global null hypothesis
IterHistory	Iteration history	ITPRINT
LastGradient	Last evaluation of gradient	ITPRINT
ModelBuildingSummary	Summary of model building	SELECTION=B, F, or S
ParameterEstimates	Maximum likelihood estimates of model parameters
ResidualChiSq	Residual Chi-Square	SELECTION=F or B
VariablesNotInModel	Analysis of variables not in the model	SELECTION=F or S
ODS Tables Created by the PROC Statement
ModelInfo	Model information
SimpleStatistics	Summary statistics for explanatory variables	SIMPLE
ODS Tables Created by the TEST Statement
TestAverage	Average effect for test	AVERAGE
TestCoeff	Coefficients for linear hypothesis	E
TestPrint1	L[cov(b)]L and Lb-c	PRINT
TestPrint2	Ginv(L[cov(b)]L) and Ginv(L[cov(b)]L)(Lb-c)	PRINT
TestStmts	Linear hypotheses testing results

Table 10.59: ODS Table Names Produced by the PLAN Procedure
Table Name	Description
Plan	Computed plan
ODS Tables Created by the FACTOR and TREATMENT Statements
PFInfo	Plot factor information
TFInfo	Treatment factor information
ODS Tables Created by the FACTOR and no TREATMENT Statements
FInfo	General factor information

Table 10.60: ODS Table Names Produced by the PLS Procedure
Table Name	Description	Option
ODS Tables Created by the MODEL Statement
CenScaleParms	Parameter estimates for centered and scaled data	SOLUTION
ParameterEstimates	Parameter estimates for raw data	SOLUTION
ODS Tables Created by the PROC Statement
CVResults	Results of cross validation	CV
CodedCoef	Coded coefficients	DETAILS
PercentVariation	Variation accounted for by each factor
ResidualSummary	Residual summary from cross validation	CV
XEffectCenScale	Centering and scaling informationforpredictoreffects	CENSCALE
XLoadings	Loadings for independents	DETAILS
XVariableCenScale	Centering and scaling information for predictor effects	CENSCALE and VARSCALE
XWeights	Weights for independents	DETAILS
YVariableCenScale	Centering and scaling information for responses	CENSCALE
YWeights	Weights for dependents	DETAILS

Table 10.61: ODS Table Names Produced by the PRINCOMP Procedure
Table Name	Description	Option
Corr	Correlation matrix	default unless COV is specified
Cov	Covariance matrix	default if COV is specified
Eigenvalues	Eigenvalues
Eigenvectors	Eigenvectors
NObsNVar	Number of observations, variables, and (partial) variables
SimpleStatistics	Simple statistics
TotalVariance	Total variance	COV
ODS Tables Created by the PARTIAL Statement
ParCorr	Partial correlation matrix
ParCov	Uncorrected partial covariance matrix	COV
RegCoef	Regression coefficients	COV
RSquareRMSE	Regression statistics: R-Squares and RMSEs
StdRegCoef	Standardized regression coefficients

Table 10.62: ODS Table Names Produced by the PRINQUAL Procedure
Table Name	Description	Option
ConvergenceStatus	Convergence status
Footnotes	Iteration history footnotes
ODS Tables Created by the PROC Statement
MAC	MAC iteration history	METHOD=MAC
MGV	MGV iteration history	METHOD=MGV
MTV	MTV iteration history	METHOD=MTV

Table 10.63: ODS Table Names Produced by the PROBIT Procedure
Table Name	Description	Option
ODS Tables Created by the CLASS Statement
ClassLevels	Class variable levels
ODS Tables Created by the MODEL Statement
ConvergenceStatus	Convergence status
CorrB	Parameter estimate correlation matrix	CORRB
CovB	Parameter estimate covariance matrix	COVB
CovTolerance	Covariance matrix for location and scale
GoodnessOfFit	Goodness of fit tests	LACKFIT
IterHistory	Iteration history	ITPRINT
LagrangeStatistics	Lagrange statistics	NOINT
LastGrad	Last evaluation of the gradient	ITPRINT
LastHess	Last evaluation of the Hessian	ITPRINT
LogProbitAnalysis	Probit analysis for log dose	INVERSECL
ModelInfo	Model information
MuSigma	Location and scale
ParameterEstimates	Parameter estimates
ParmInfo	Parameter indices
ProbitAnalysis	Probit analysis for linear dose	INVERSECL
ResponseLevels	Response-covariate profile	LACKFIT
ResponseProfiles	Counts for ordinal data
Type3Analysis	Type 3 tests

Table 10.64: ODS Table Names Produced by the REG Procedure
Table Name	Description	Option
ODS Tables Created by the MODEL Statement
ACovEst	Consistent covariance of estimates matrix	ALL or ACOV
ANOVA	Model ANOVA table
CollinDiag	Collinearity diagnostics table	COLLIN
CollinDiagNoInt	Collinearity diagnostics for no intercept model	COLLINOINT
ConditionBounds	Bounds on condition number	(SELECTION=BACKWARD, FORWARD, STEPWISE, MAXR, or MINR) and DETAILS
CorrB	Correlation of estimates	CORRB
CovB	Covariance of estimates	COVB
CrossProducts	Bordered model X X matrix	ALL or XPX
DWStatistic	Durbin-Watson statistic	ALL or DW
DependenceEquations	Linear dependence equations
EntryStatistics	Entry statistics for selection methods	(SELECTION=BACKWARD, FORWARD, STEPWISE, MAXR, or MINR) and DETAILS
FitStatistics	Model fit statistics
InvXPX	Bordered X X inverse matrix	I
OutputStatistics	Output statistics table	ALL, CLI, CLM, INFLUENCE, P, or R
ParameterEstimates	Model parameter estimates
RemovalStatistics	Removal statistics for selection methods	(SELECTION=BACKWARD, STEPWISE, MAXR, or MINR) and DETAILS
ResidualStatistics	Residual statistics and PRESS statistic	ALL, CLI, CLM, INFLUENCE, P, or R
SelParmEst	Parameter estimates for selection methods	SELECTION=BACKWARD, FORWARD, STEPWISE, MAXR, or MINR
SelectionSummary	Selection summary for forward, backward, and stepwise methods	SELECTION=BACKWARD, FORWARD, or STEPWISE
SeqParmEst	Sequential parameter estimates	SEQB
SpecTest	White s heteroscedasticity test	ALL or SPEC
SubsetSelSummary	Selection summary for R-Square, adj-RSq, and Cp methods	SELECTION=RSQUARE, ADJRSQ, or CP
ODS Tables Created by the MTEST Statement
CanCorr	Canonical correlations for hypothesis combinations	CANPRINT
Eigenvalues	MTest eigenvalues	CANPRINT
Eigenvectors	MTest eigenvectors	CANPRINT
ErrorPlusHypothesis MTest error plus hypothesis	matrix H+E	PRINT
ErrorSSCP	MTest error matrix E	PRINT
HypothesisSSCP	MTest hypothesis matrix	PRINT
InvMTestCov	Inv(L Ginv(X X)L) and Inv(Lb-c)	DETAILS
MTestCov	L Ginv(X X) L and Lb-c	DETAILS
MTransform	MTest matrix M, across dependents	DETAILS
MultStat	Multivariate test statistics
ODS Tables Created by the PROC Statement
Corr	Correlation matrix for analysis variables	ALL or CORR
SimpleStatistics	Simple statistics for analysis variables	ALL or SIMPLE
USSCP	Uncorrected SSCP matrix for analysis variables	ALL or USSCP
ODS Tables Created by the TEST Statement
ACovTestANOVA	Test ANOVA using ACOV estimates	ACOV (MODEL statement)
InvTestCov	Inv(L Ginv(X X)L) and Inv(Lb-c)	PRINT
TestANOVA	Test ANOVA table
TestCov	L Ginv(X X) L and Lb-c	PRINT

Table 10.65: ODS Table Names Produced by the ROBUSTREG Procedure
Table Name	Description	Option
ODS Tables Created by the CLASS Statement
ClassLevels	Class variable levels
ODS Tables Created by the MODEL Statement
CorrB	Parameter estimate correlation matrix	CORRB
CovB	Parameter estimate covariance matrix	COVB
Diagnostics	Outlier diagnostics	DIAGNOSTICS
DiagSummary	Summary of the outlier diagnostics
GoodFit	R2, deviance, AIC, and BIC
ModelInfo	Model information
ParameterEstimates	Parameter estimates
ParmInfo	Parameter indices
SummaryStatistics	Summary statistics for model variables
ODS Tables Created by the PROC Statement
BestEstimates	Best final estimates for LTS	SUBANALYSIS
BestSubEstimates	Best estimates for each subgroup	SUBANALYSIS
BiasTest	Bias test for MM estimation	BIASTEST
CStep	C-Step for LTS fitting	SUBANALYSIS
Groups	Groups for LTS fitting	SUBANALYSIS
InitLTSProfile	Profile for initial LTS estimate	METHOD
InitSProfile	Profile for initial S estimate	METHOD
LTSEstimates	LTS parameter estimates	METHOD
LTSLocationScale	Location and scale for LTS	METHOD
LTSProfile	Profile for LTS estimate	METHOD
LTSRsquare	R2 for LTS estimate	METHOD
MMProfile	Profile for MM estimate	METHOD
ParameterEstimatesF	Final weighted LS estimates	FWLS
SProfile	Profile for S estimate	METHOD
ODS Tables Created by the TEST Statement
ParameterEstimatesR	Reduced parameter estimates
TestsProfile	Results for tests

Table 10.66: ODS Table Names Produced by the RSREG Procedure
Table Name	Description
Coding	Coding coefficients for the independent variables
ErrorANOVA	Error analysis of variance
FactorANOVA	Factor analysis of variance
FitStatistics	Overall statistics for fit
ModelANOVA	Model analysis of variance
ParameterEstimates	Estimated linear parameters
Spectral	Spectral analysis
StationaryPoint	Stationary point of response surface
ODS Tables Created by the RIDGE Statement
Ridge	Ridge analysis for optimum response

Table 10.67: ODS Table Names Produced by the STDIZE Procedure
Table Name	Description	Option
Statistics	Location and scale measures	PSTAT

Table 10.68: ODS Table Names Produced by the STEPDISC Procedure
Table Name	Description	Option
BCorr	Between-class correlations	BCORR
BCov	Between-class covariances	BCOV
BSSCP	Between-class SSCP matrix	BSSCP
Counts	Number of observations, variables, classes, and DF
CovDF	DF for covariance matrices, not printed	any *COV option
Levels	Class level information
Messages	Entry/removal messages
Multivariate	Multivariate statistics
PCorr	Pooled within-classcorrelations	PCORR
PCov	Pooled within-class covariances	PCOV
PSSCP	Pooled within-class SSCP matrix	PSSCP
PStdMeans	Pooled standardized class means	STDMEAN
SimpleStatistics	Simple statistics	SIMPLE
Steps	Stepwise selection entry/ removal
Summary	Stepwise selection summary
TCorr	Total-sample correlations	TCORR
TCov	Total-sample covariances	TCOV
TSSCP	Total-sample SSCP matrix	TSSCP
TStdMeans	Total standardized class means	STDMEAN
Variables	Variable lists
WCorr	Within-class correlations	WCORR
WCov	Within-class covariances	WCOV
WSSCP	Within-class SSCP matrices	WSSCP

Table 10.69: ODS Table Names Produced by the SURVEYMEANS Procedure
Table Name	Description	Option
ODS Tables Created by the CLASS Statement
ClassVarInfo	Class level information
ODS Tables Created by the DOMAIN Statement
Domain	Statistics in domains
ODS Tables Created by the PROC Statement
Statistics	Statistics
Summary	Data summary
ODS Tables Created by the RATIO Statement
Ratio	Statistics for ratios
ODS Tables Created by the STRATA Statement
StrataInfo	Stratum information	LIST

Table 10.70: ODS Table Names Produced by the SURVEYREG Procedure
Table Name	Description	Option
ODS Tables Created by the CLASS Statement
ClassVarInfo	Class level information
ODS Tables Created by the CLUSTER Statement
DesignSummary	Design summary
ODS Tables Created by the CONTRAST Statement
ContrastCoef	Coefficients of contrast	E
Contrasts	Analysis of contrasts
ODS Tables Created by the ESTIMATE Statement
EstimateCoef	Coefficients of estimate	E
Estimates	Analysis of estimable functions
ODS Tables Created by the MODEL Statement
ANOVA	ANOVA for dependent variable	ANOVA
CovB	Covariance of estimated regression coefficients	COVB
DataSummary	Data summary
Effects	Tests of model effects
FitStatistics	Fit statistics
InvXPX	Inverse matrix of X X	INV
ParameterEstimates	Estimated regression coefficients
XPX	X X matrix	XPX
ODS Tables Created by the STRATA Statement
DesignSummary	Data summary
StrataInfo	Stratum information	LIST

Table 10.71: ODS Table Names Produced by the SURVEYSELECT Procedure
Table Name	Description
ODS Tables Created by the PROC Statement
Method	Sample selection method
Summary	Sample selection summary

Table 10.72: ODS Table Names Produced by the TPHREG Procedure
Table Name	Description	Option
ODS Tables Created by the CONTRAST Statement
ContrastCoeff	L matrix for contrasts	E
ContrastEstimate	Individual contrast estimates	ESTIMATE=
ContrastTest	Wald test for contrasts
ODS Tables Created by the MODEL Statement
BestSubsets	Best subset selection	SELECTION=SCORE
CensoredSummary	Summary of event and censored observations
ClassLevelInfo	CLASS variable levels and design variables	default (with CLASS variables)
ConvergenceStatus	Convergence status
CorrB	Estimated correlation matrix of parameter estimates	CORRB
CovB	Estimated covariance matrix of parameter estimators	COVB
EffectsToEnter	Eligible effects for entry to model	SELECTION=F or S
EffectsToRemove	Eligible effects for removal from model	SELECTION=B or S
FitStatistics	Model fit statistics
GlobalScore	Global Chi-Square test	NOFIT
GlobalTests	Tests of the global null hypothesis
IterHistory	Iteration history	ITPRINT
LastGradient	Last evaluation of gradient	ITPRINT
ModelBuildingSummary	Summary of model building	SELECTION=B, F, or S
ParameterEstimates	Maximum likelihood estimates of model parameters
ResidualChiSq	Residual Chi-Square	SELECTION=F or B
Type3	Type 3 tests of effects	default (with CLASS variables)
ODS Tables Created by the PROC Statement
ClassLevelFreq	Frequency breakdown of CLASS variables	SIMPLE (with CLASS variables)
ModelInfo	Model information
SimpleStatistics	Summary statistics for interval explanatory variables	SIMPLE
ODS Tables Created by the TEST Statement
TestAverage	Average effect for test	AVERAGE
TestCoeff	Coefficients for linear hypothesis	E
TestPrint1	L[cov(b)]L and Lb-c	PRINT
TestPrint2	Ginv(L[cov(b)]L) and Ginv(L[cov(b)]L)(Lb-c)	PRINT
TestStmts	Linear hypothesis test results
ODS Tables Created by the WEIGHT Statement
ClassWgt	Weight breakdown of CLASS variables	SIMPLE (with CLASS variables)

Table 10.73: ODS Table Names Produced by the TPSPLINE Procedure
Table Name	Description	Option
ODS Tables Created by the MODEL Statement
GCVFunction	GCV table	LOGNLAMBDA or LAMBDA
ODS Tables Created by the PROC Statement
DataSummary	Data summary
FitStatistics	Model fit statistics
FitSummary	Fit parameters and fit summary

Table 10.74: ODS Table Names Produced by the TRANSREG Procedure
Table Name	Description	Option
ConvergenceStatus	Convergence status
Equation	Linear dependency equation	less-than -full-rank model
Footnotes	Iteration history footnotes
ODS Tables Created by the MODEL Statement
BoxCox	Box-Cox transformation results	BOXCOX
SplineCoef	Spline coefficients	SPLINE or MSPLINE
ODS Tables Created by the MODEL and PROC Statements
NObs	ANOVA	TEST or SS2
ClassLevels	ANOVA	TEST or SS2
ANOVA	ANOVA	TEST or SS2
LiberalANOVA	ANOVA	TEST or SS2
ConservANOVA	ANOVA	TEST or SS2
FitStatistics	Fit statistics like R-Square	TEST or SS2
LiberalFitStatistics	Fit statistics	TEST or SS2
ConservFitStatistics	Fit statistics	TEST or SS2
MVANOVA	Multivariate ANOVA	TEST or SS2
LiberalMVANOVA	Multivariate ANOVA	TEST or SS2
ConservANOVA	Multivariate ANOVA	TEST or SS2
Coef	Regression results	SS2
LiberalCoef	Regression results	SS2
ConservCoef	Regression results	SS2
MVCoef	Multivariate regression results	SS2
LiberalMVCoef	Multivariate regression results	SS2
ConservMVCoef	Multivariate regression results	SS2
Utilities	Conjoint analysis utilities	UTILITY
LiberalUtilities	Conjoint analysis utilities	UTILITY
ConservUtilities	Conjoint analysis utilities	UTILITY
Details	Model details	DETAIL
Univariate	Univariate iteration history	METHOD=UNIVARIATE
MORALS	MORALS iteration history	METHOD=MORALS
CANALS	CANALS iteration history	METHOD=CANALS
Redundancy	Redundancy iteration history	METHOD=REDUNDANCY
TestIterations	Hypothesis test iterations iteration history	SS2

Table 10.75: ODS Table Names Produced by the TREE Procedure
Table Name	Description	Option
ODS Tables Created by the PROC Statement
Tree	Line-printer plot of the tree	LINEPRINTER
TreeListing	Line-printer listing of all nodes in the tree	LIST

Table 10.76: ODS Table Names Produced by the TTEST Procedure
Table Name	Description
Statistics	Univariate summary statistics
TTests	t -tests
ODS Tables Created by the CLASS Statement
Equality	Tests for equality of variance

Table 10.77: ODS Table Names Produced by the VARCLUS Procedure
Table Name	Description	Option
ClusterQuality	Cluster quality
ClusterStructure	Cluster structure
ClusterSummary	Cluster summary
ConvergenceStatus	Convergence status
Corr	Correlations	CORR
DataOptSummary	Data and options summary table
InterClusterCorr	Inter-cluster correlations
IterHistory	Iteration history	TRACE
RSquare	Cluster R-Square
SimpleStatistics	Simple statistics	SIMPLE
StdScoreCoef	Standardized scoring coefficients

Table 10.78: ODS Table Names Produced by the VARCOMP Procedure
Table Name	Description	Option
ClassLevels	Class level information
ConvergenceStatus	Convergence status
Estimates	Variance component estimates (one variable)
Estimates n	Variance component estimates (multiple variables)
NObs	Number of observations
ODS Tables Created by the METHOD Statement
ANOVA	Type 1 analysis of variance	TYPE1
AsyCov	Asymptotic covariance matrix of estimates	ML or REML
DepVar	Dependent variable (one variable)	TYPE1, REML, or ML
DepVar n	Dependent variable n (multiple variables)	TYPE1, REML, or ML
DependentInfo	Dependent variable information (multiple variables)	MIVQUE0
IterHistory	Iteration history	ML or REML
SCCP	Sum of squares matrix (one variable)	MIVQUE0
SCCP n	Sum of squares matrix (multiple variable)	MIVQUE0

ODS Table Names and the SAS/ETS Procedures that Produce Them

The following table lists the output object table names which SAS/ETS procedures produce. You must license SAS/ETS software in order to produce these output objects. The table provides the name of each table, a description of what the table contains, and the option, if any, that creates the output object table. For more information about SAS/ ETS procedures, see

Table 10.79: ODS Table Names Produced by the ARIMA Procedure
Table Name	Description	Option
ODS Tables Created by the IDENTIFY Statement
DescStats	Descriptive statistics
InputDescStats	Input descriptive statistics
CorrGraph	Correlations graph
StationarityTest	Stationarity tests	STATIONARITY
TentativeOrders	Tentative order selections	MINIC, ESACF, or SCAN
PACFGraph	Partial autocorrelations graph
IACFGraph	Inverse autocorrelations graph
ChiSqAuto	Chi-Square statistics table for autocorrelation
ChiSqCross	Chi-Square statistics table for cross-correlations	CROSSCORR=
MINIC	Minimum information criterion	MINIC
ESACF	Extended sample autocorrelation function	ESACF
ESACFPValues	ESACF probability values	ESACF
SCAN	Squared canonical correlation estimates	SCAN
SCANValues	SCAN Chi-Square[1] probability values
ODS Tables Created by the ESTIMATE Statement
FitStatistics	Fit statistics
ARPolynomial	Filter equations
MAPolynomial	Filter equations
NumPolynomial	Filter equations
DenPolynomial	Filter equations
ParameterEstimates	Parameter estimates
ChiSqAuto	Chi-Square statistics table for autocorrelation
ChiSqCross	Chi-Square statistics table for cross-correlations
InitialAREstimates	Initial autoregressive parameter estimates
InitialMAEstimates	Initial moving average parameter estimates
PrelimEstimates	Preliminary estimation
IterHistory	Conditional least squares estimation	METHOD=CLS
OptSummary	ARIMA estimation optimization	PRINTALL
ModelDescription	Model description
InputDescription	Input description
ObjectiveGrid	Objective function grid matrix	GRID
CorrB	Correlations of the estimates
ODS Tables Created by the OUTLIER Statement
OutlierDetails	Detected outliers
ODS Tables Created by the FORECAST Statement
Forecasts	Fit statistics

Table 10.80: ODS Table Names Produced by the AUTOREG Procedure
Table Name	Description	Option
ODS Tables Created by the MODEL Statement
FitSummary	Summary of regression
SummaryDepVarCen	Summary of regression (centered dependent variable)	CENTER
SummaryNoIntercept	Summary of regression (no intercept)	NOINT
YWIterSSE	Yule-Walker iteration sum of squared error	METHOD=ITYW
PreMSE	Preliminary MSEs	NLAG=
Dependent	Dependent variable
DependenceEquations	Linear dependence equation
ARCHTest	Q and LM tests for ARCH disturbances	ARCHTEST
ChowTest	Chow test and predictive chow test	CHOW= or PCHOW=
Godfrey	Godfrey s serial correlation test	GODFREY or GODFREY=
PhilPerron	Phillips-Perron unit root test	STATIONARITY=, (PHILLIPS<=()>), (no regressor)
PhilOul	Phillips-Ouliaris cointegration test	STATIONARITY=, (PHILLIPS<=()>), (has regressor)
ResetTest	Ramsey s RESET test	RESET
ARParameterEstimates	Estimates of autoregressive parameters	NLAG=
CorrGraph	Estimates of au tocorrelations	NLAG=
BackStep	Backward elimination of autoregressive terms	BACKSTEP
ExpAutocorr	Expected autocorrelations	NLAG=
IterHistory	Iteration history	ITPRINT
ParameterEstimates	Parameter estimates
ParameterEstimatesGivenAR	Parameter estimates assuming AR parameters are given	NLAG=
PartialAutoCorr	Partial autocorrelation	PARTIAL
CovB	Covariance of parameter estimates	COVB
CorrB	Correlation of parameter estimates	CORRB
CholeskyFactor	Cholesky root of gamma	ALL
Coefficients	Coefficients for first NLAG observations	COEF
GammaInverse	Gamma inverse	GINV
ConvergenceStatus	Convergence status table
DWTestProb	Durbin-Watson statistics	DW=
ODS Tables Created by the RESTRICT Statement
Restrict	Restriction table
ODS Tables Created by the TEST Statement
FTest	F test
WaldTest	Wald test	TYPE=WALD

Table 10.81: ODS Table Names Produced by the ENTROPY Procedure
Table Name	Description
ConvCrit	Convergence criteria for estimation
ConvergenceStatus	Convergence status
DatasetOptions	Data sets used
MinSummary	Number of parameters, estimation kind
ObsUsed	Observations read, used, and missing
ParameterEstimates	Parameter estimates
ResidSummary	Summary of the SSE, MSE for the equations
TestResults	Test statement table

Table 10.82: ODS Table Names Produced by the LOAN Procedure
Table Name	Description	Option
ODS Tables Created by the PROC LOAN, FIXED, ARM, BALLOON, and BUYDOWN Statements
Repayment	Loan repayment schedule	SCHEDULE
ODS Tables Created by the FIXED, ARM, BALLOON, and BUYDOWN Statements
LoanSummary	Loan summary
RateList	Rates and payments
PrepayList	Prepayments and periods	PREPAYMENTS=
ODS Tables Created by the BALLOON Statement
BalloonList	Balloon payments and periods
ODS Tables Created by the COMPARE Statement
Comparison	Loan comparison report

Table 10.83: ODS Table Names Produced by the MDC Procedure
Table Name	Description	Option
ODS Tables Created by the MODEL Statement
FitSummary	Summary of nonlinear estimation
ResponseProfile	Response profile
GoodnessOfFit	Pseudo-R ² measures
ParameterEstimates	Parameter estimates
LinConSol	Linearly independent active linear constraints
CovB	Covariance of parameter estimates	COVB
CorrB	Correlation of parameter estimates	CORRB

Table 10.84: ODS Table Names Produced by the MODEL Procedure
Table Name	Description	Option
ODS Tables Created by the FIT Statement
AugGMMCovariance	Cross products matrix	GMM
ChowTest	Structural change test	CHOW=
CollinDiagnostics	Collinearity diagnostics
ConfInterval	Profile likelihood confidence intervals	PRL=
ConvCrit	Convergence criteria for estimation
ConvergenceStatus	Convergence status
CorrB	Correlations of parameters	COVB or CORRB
CorrResiduals	Correlations of residuals	CORRS or COVS
CovB	Covariance of parameters	COVB or CORRB
CovResiduals	Covariance of residuals	CORRS or COVS
Crossproducts	Cross products matrix	ITALL or ITPRINT
DatasetOptions	Data sets used
DetResidCov	Determinant of the residuals	DETAILS
DWTest	Durbin-Watson test	DW=
Equations	List of equations to estimate
EstSummaryMiss	Model summary statistics for PAIRWISE	MISSING=
EstSummaryStats	Objective, objective * N
GMMCovariance	Cross products matrix	GMM
Godfrey	Godfrey s serial correlation test	GF=
HausmanTest	Hausman s test table	HAUSMAN
HeteroTest	Heteroscedasticity test tables	BREUSCH or PAGEN
InvXPXMat	X X inverse for system	I
IterInfo	Iteration printing	ITALL or ITPRINT
LagLength	Model lag length
MinSummary	Number of parameters, estimation kind
MissingValues	Missing values generated by the program
ModSummary	List of all categorized values
ModVars	List of model variables and parameters
NormalityTest	Normality test table	NORMAL
ObsSummary	Identifies observations with errors
ObsUsed	Observations read, used, and missing	default
ParameterEstimates	Parameter estimates
ParmChange	Parameter change vector
ResidSummary	Summary of the SSE, MSE for the equations
SizeInfo	Storage requirement for estimation	DETAILS
TermEstimates	Nonlinear OLS and ITOLS estimates	OLS or ITOLS
TestResults	Test statement table
WgtVar	The name of the weight variable
XPXMat	X X for system	XPX
ODS Tables Created by the SOLVE Statement
DatasetOptions	Data sets used
DescriptiveStatistics	Descriptive statistics	STATS
FitStatistics	Fit statistics for simulation	STATS
LagLength	Model lag length
ModSummary	List of all categorized variables
ObsSummary	Simulation trace output	SOLVEPRINT
ObsUsed	Observations resa, used, and missing
SimulationSummary	Number of variables solved for
SolutionVarList	Solution variable lists
TheilRelStats	Theil relative change error statistics	THEIL
TheilStats	Theil forecast error statistics	THEIL
ODS Tables Created by the FIT and SOLVE Statements
AdjacencyMatrix	Adjacency graph	GRAPH
BlockAnalysis	Block analysis	BLOCK
CodeDependency	Variable cross reference	LISTDEP
CodeList	List of programs statements	LISTCODE
CrossReference	Cross reference listing for program
DepStructure	Dependency structure for the system	BLOCK
DerList	Derivative variables	LISTDER
InterIntg	Integration iteration output	INTGPRINT
MemUsage	Memory usage statistics	MEMORYUSE
ParmReadIn	Parameter estimates read in	ESTDATA=
ProgList	List of compiled program data
RangeInfo	RANGEstatementspecification
SortAdjacencyMatrix	Sorted adjacency graph	GRAPH
TransitiveClosure	Transitive closure graph	GRAPH

Table 10.85: ODS Table Names Produced by the PDLREG Procedure
Table Name	Description	Option
ODS Tables Created by the MODEL Statement
ARParameterEstimates	Estimates of autoregressive parameters	NLAG=
CholeskyFactor	Cholesky root of gamma
Coefficients	Coefficients for first NLAG observations	NLAG=
ConvergenceStatus	Convergence status table
CorrB	Correlation of parameter estimates	CORRB
CorrGraph	Estimates of autocorrelations	NLAG=
CovB	Covariance of parameter estimates	COVB
DependenceEquations	Linear dependence equation
Dependent	Dependent variable
DWTest	Durbin-Watson statistics	DW=
ExpAutocorr	Expected autocorrelations	NLAG=
FitSummary	Summary of regression
GammaInverse	Gamma inverse
IterHistory	Iteration history	ITPRINT
LagDist	Lag distribution	ALL
ParameterEstimates	Parameter estimates
ParameterEstimatesGivenAR	Parameter estimates assuming AR parameters are given	NLAG=
PartialAutoCorr	Partial autocorrelation	PARTIAL
PreMSE	Preliminary MSE	NLAG=
XPXIMatrix	Inverse X X matrix	XPX
XPXMatrix	X X matrix	XPX
YWIterSSE	Yule-Walker iteration sum of squared error	METHOD=ITYW
ODS Tables Created by the RESTRICT Statement
Restrict	Restriction table

Table 10.86: ODS Table Names Produced by the SIMLIN Procedure
Table Name	Description	Option
Endogenous	Structural coefficients for endogenous variables
LaggedEndogenous	Structural coefficients for lagged endogenous variables
Exogenous Structural	Coefficients for exogenous variables
InverseCoeff	Inverse coefficient matrix for endogenous variables
RedFormLagEndo	Reduced form for lagged endogenous variables
RedFormExog	Reduced form for exogenous variables
InterimMult	Interim multipliers	INTERIM=option
TotalMult	Total multipliers	TOTAL=option
FitStatistics	Fit statistics

Table 10.87: ODS Table Names Produced by the SPECTRA Procedure
Table Name	Description	Option
WhiteNoiseTest	White noise test	WHITETEST
Kappa	Fishers kappa	WHITETEST
Bartlett	Bartletts Kolmogorov-Smirnov statistic	WHITETEST

Table 10.88: ODS Table Names Produced by the STATESPACE Procedure
Table Name	Description	Option
NObs	Number of observations
Summary	Simple summary statistics table
InfoCriterion	Information criterion table
CovLags	Covariance matrices of input series	PRINTOUT=LONG
CorrLags	Correlation matrices of input series	PRINTOUT=LONG
PartialAR	Partial autoregressive matrices	PRINTOUT=LONG
YWEstimates	Yule-Walker estimates for minimum AIC
CovResiduals	Covariance of residuals	PRINTOUT=LONG
CorrResiduals	Residual correlations from AR models	PRINTOUT=LONG
StateVector	State vector table
CorrGraph	Schematic representation of correlations
TransitionMatrix	Transition matrix
InputMatrix	Input matrix
VarInnov	Variance matrix for the innovation
CovB	Covariance of parameter estimates	COVB
CorrB	Correlation of parameter estimates	COVB
CanCorr	Canonical correlation analysis	CANCORR
IterHistory	Iterative fitting table	ITPRINT
ParameterEstimates	Parameter estimates table
Forecasts	Forecasts table	PRINT
ConvergenceStatus	Convergence status table

Table 10.89: ODS Table Names Produced by the SYSLIN Procedure
Table Name	Description	Option
ANOVA	Summary of the SSE, MSE for the equations
AugXPXMat	Model crossproducts	XPX
AutoCorrStat	Autocorrelation statistics
ConvCrit	Convergence criteria for estimation
ConvergenceStatus	Convergence status
CorrB	Correlations of parameters	CORRB
CorrResiduals	Correlations of residuals	CORRS
CovB	Covariance of parameters	COVB
CovResiduals	Covariance of residuals	COVS
Endomat	Endogenous variables
Equations	List of equations to estimates
ExogMat	Exogenous variables
FitStatistics	Statistics of fit
InvCorrResiduals	Inverse correlations of residuals	CORRS
InvCovResiduals	Inverse covariance of residuals	COVS
InvEndoMat	Inverse endogenous variables
InvXPX	X X inverse for system	I
IterHistory	Iteration printing	ITALL or ITPRINT
MissingValues	Missing values generated by the program
ModelVars	Name and label for the model
ParameterEstimates	Parameter estimates
RedMat	Reduced form	REDUCED
SimpleStatistics	Descriptive statistics	SIMPLE
SSCP	Model crossproducts
TestResults	Test for overidentifying restrictions
Weight	Weighted model statistics
YPY	Y Y matrices	USSCP2

Table 10.90: ODS Table Names Produced by the TSCSREG Procedure
Table Name	Description	Option
ODS Tables Created by the MODEL Statement
ModelDescription	Model description
FitStatistics	Fit statistics
FixedEffectsTest	F test for no fixed tests
ParameterEstimates	Parameter estimates
CovB	Covariance of parameter estimates
CorrB	Correlations of parameter estimates
VarianceComponents	Variance component estimates
RandomEffectsTest	Hausman test for random effects
AR1Estimates	First order autoregressive parameter estimates
EstimatedPhiMatrix	Estimated phi matrix	PARKS
EstimatedAutocovariances	Estimates of autocovariances	PARKS
ODS Tables Created by the TEST Statement
TestResults	Test results

Table 10.91: ODS Table Names Produced by the TIMESERIES Procedure
Table Name	Description
ODS Tables Created by the PRINT=DECOMP Option
SeasonalDecomposition	Seasonal decomposition
ODS Tables Created by the PRINT=DESCSTATS Option
DescStats	Descriptive statistics
ODS Tables Created by the PRINT=SEASONS Option
SeasonStatistics	Season statistics
ODS Tables Created by the PRINT=TRENDS Option
TrendStatistics	Trend statistics

Table 10.92: ODS Table Names Produced by the VARMAX Procedure
Table Name	Description	Option
ODS Tables Created by the MODEL Statement
AccumImpulse	Accumulated impulse response matrices	IMPULSE=(ACCUM) or IMPULSE=(ALL)
AccumImpulsX	Accumulated transfer function matrices	IMPULSX=(ACCUM) or IMPULSX=(ALL)
Alpha	± coefficients	JOHANSEN=
AlphaInECM	± coefficients	ECM=
AlphaOnDrift	± coefficients on restriction of a deterministic term	JOHANSEN=
AlphaBetaInECM	= ±² coefficients	ECM=
ArchCoef	ARCH coefficients	GARCH=
ARCoef	AR coefficients	P= or DYNAMIC with P=
ARRoots	Roots of AR characteristic polynomial	ROOTS
Beta	² coefficients	JOHANSEN=
BetaInECM	² coefficients	ECM=
BetaOnDrift	² coefficients on restriction of a deterministic term	JOHANSEN=
Constant	Constant estimates	w/o NOINT
CorrB	Correlations of parameter estimates	CORRB
CorrResiduals	Cross-correlations of residuals
CorrResidualsGraph	Schematic representation of residual cross-correlations
CorrGraph	Schematic representation of sample cross-correlations	CORRX or CORRY
CorrXLags	Cross-correlation matrices of independent series	CORRX
CorrYLags	Cross-correlation matrices of dependent series	CORRY
CovB	Covariance of parameter estimates	COVB
CovInnov	Covariance matrix for the innovation
CovPredError	Covariance matrices of the prediction error	COVPE
CovResiduals	Cross-covariance matrices of residuals
CovXLags	Cross-covariance matrices of independent series	COVX
CovYLags	Cross-correlations matrices of dependent series	COVY
DecompCovPredError	Decomposition of the prediction error covariance	DECOMPOSE
DFTest	Dickey-Fuller tests	DFTEST
DriftHypo	Hypothesis of different deterministic terms in cointegration rank test	JOHANSEN=
DrifyHypoTest	Test hypothesis of different deterministic terms in cointegration rank test	JOHANSEN=
EigenvalueI2	Eigenvalues in integrated order 2	JOHANSEN= (IORDER=2)
Eta	· coefficients	JOHANSEN= (IORDER=2)
GARCHParameterEstimates	GARCH parameter estimates table	GARCH=
GARCHParameterGraph	Schematic representation of the garch parameters
GARCHRoots	Roots of GARCH characteristic polynomial	GARCH=
GARCHCoef	GARCH coefficients	GARCH=
GARCHConstant	GARCH constant estimates	GARCH=
InfiniteARRepresent	Infinite order AR representation	IARR
InfoCriterion	Information criterion
LinearTrend	Linear trend estimates	TREND=
MACoef	MA coefficients	Q=
MARoots	Roots of MA characteristic polynomial	Q=
MaxTest	Cointegration rank test using the maximum eigenvalue	JOHANSEN= (TYPE=MAX)
MaxTestOnDrift	Cointegration rank test using the maximum eigenvalue on restriction of a deterministic term	JOHANSEN= (TYPE=MAX)
ModelType	Type of model
NObs	Number of observations
OrthoImpulse	Orthogonalized impulse response matrices	IMPULSE=(ORTH) or IMPULSE=(ALL)
ParameterEstimates	Parameter estimates table
ParameterGraph	Schematic representation of the parameters
PartialAR	Partial autoregression matrices	PARCOEF
PartialARGraph	Schematic representation of partial autoregression	PARCOEF
PartialCanCorr	Partial canonical correlation analysis	PCANCORR
PartialCorr	Partial cross-correlation matrices	PCORR
PartialCorrGraph	Schematic representation of partial cross correlations	PCORR
PortmanteauTest	Chi-Square test table for residual cross-correlations
ProportionDecomp	Proportions of prediction error covariance decomposition	DECOMPOSE
RankTestI2	Cointegration rank test in integrated order 2	JOHANSEN= (IORDER=2)
QuadTrend	Quadratic trend estimates	TREND=QUAD
SConstant	Seasonal constant estimates	NSEASON=
SimpleImpulse	Impulse response matrices	IMPULSE, IMPULSE=SIMPLE, or IMPULSE=(ALL)
SimpleImpulsX	Impulse response matrices in transfer function	IMPULSX, IMPULSX=(SIMPLE), or IMPULSX=(ALL)
Summary	Simple summary statistics
SWTest	Common trends test	SW or SW=
TentativeOrders	Tentative order selection	MINIC or MINIC=
TraceTest	Cointegration rank test using the trace	JOHANSEN= (TYPE=TRACE)
TraceTestOnDrift	Cointegration rank test using the trace on restriction of a deterministic term	JOHANSEN= (TYPE=TRACE)
UnivarDiagnostAR	Check the AR disturbance for the residuals
UnivarDiagnostCheck	Univariate model diagnostic checks
UnivarDiagnostTest	Check the ARCH disturbance and normality for the residuals
Xi	coefficient matrix	JOHANSEN= (IORDER=2)
XLagCoef	Dependent coefficients	XLAG=
YWEstimates	Yule-Walker estimates	YW
ByVariable	Prints by variable	PRINTFORM=
ODS Tables Created by the COINTEG Statement
AlphaInECM	± coefficients
AlphaBetaInECM	= ±² coefficients
BetaInECM	± coefficients
AlphaOnTest	± coefficients under restriction	H= or J=
BetaOnTest	± coefficients under restriction	H= or J=
RestrictMatrix	Restriction matrix for or ²	H= or J=
RestrictTest	Hypothesis testing of or ²	H= or J=
WeakExogeneity	Testing weak exogeneity of each dependent variable with respect to beta	EXOGENEITY
ODS Tables Created by the CASUAL Statement
Causality	Granger-Causality test
ODS Tables Created by the RESTRICT Statement
Restrict	Restriction table
ODS Tables Created by the TEST Statement
Test	Wald test
ODS Tables Created by the OUTPUT Statement
Forecasts	Forecasts table w/o	NOPRINT

Table 10.93: ODS Table Names Produced by the X11 Procedure
Table Name	Description	Option
ODS Tables Created by the MONTHLY and QUARTERLYStatements
Preface	X11 seasonal adjustment program information giving credits, dates, etc.	Always printed unless NOPRINT
A1	Table A1: OriginalSeries
A2	Table A2: Prior monthly
A3	Table A3: Original series adjusted for prior monthly factors
A4	Table A4: Prior trading day adjustment factors with and without length of month adjustments
A5	Table A5: Original series adjusted for priors
B1	Table B16: Original series or original series adjusted for priors
B2	Table B2: Trend cycle ” centered nn-term moving average
B3	Table B3: Unmodified SI ratios
B4	Table B4: Replacement values for extreme SI ratios
B5	Table B5: Seasonal factors
B6	Table B6: Seasonally adjusted series
B7	Table B7: Trend cycle ” Henderson curve
B8	Table B8: Unmodified SI ratios
B9	Table B9: Replacement values for extreme SI ratios
B10	Table B10: Seasonal factors
B11	Table B11: Seasonally adjusted series
B13	Table B13: Irregular series
B15	Table B15: Preliminary trading day regression
B16	Table B16: Trading day adjustment factors derived from regression
B17	Table B17: Preliminary weights for irregular components
B18	Table B18: Trading day adjustment factors from combined weights
B19	Table B19: Original series adjusted for preliminary combined TD weights
C1	Table C1: Original series adjusted for preliminary weights
C2	Table C2: Trend cycle ” centered nn-term moving average
C4	Table C4: Modified SI ratios
C5	Table C5: Seasonal factors
C6	Table C6: Seasonally adjusted factors
C7	Table C7: Trend cycle ” Henderson curve
C9	Table C9: Modified CI ratios
C10	Table C10: Seasonal factors
C11	Table C11: Seasonally adjusted series
C13	Table C13: Irregular series
C15	Table C15: Final trading day regression
C16	Table C16: Trading day adjustment factors derived from regression
C17	Table C17: Final weights for irregular component
C18	Table C18: Trading day adjustment factors from combined weights
C19	Table C19: Original series adjusted for final combined TD weights
D1	Table D1: Original series adjusted for final weights on nn-term moving average
D4	Table D4: Modified SI ratios
D5	Table D5: Seasonal factors
D6	Table D6: Seasonally adjusted series
D7	Table D7: Trend cycle ” Henderson curve
D8	Table D8: Final unmodified SI ratios
D10	Table D10: Final season factors
D11	Table D11: Final seasonally adjusted series
D12	Table D12: Final trend cycle ” Henderson curve
D13	Table D13: Final irregular series
E1	Table E1: Original series modified for extremes
E2	Table E2: Modified seasonally adjusted series
E3	Table E3: Modified irregular series
E5	Table E5: Month-to-month changes in original series
E6	Table E6: Month-to-month changes in final seasonally adjusted series
F1	TableF1: MCD movingaverage
A13	Table A13: ARIMA forecasts	ARIMA statement
A14	Table A14: ARIMA backcasts	ARIMA statement
A15	Table A15: ARIMA extrapolation	ARIMA statement
B14	Table B14: Irregular values excluded from trading day regression
C14	Table C14: Irregular values excluded from trading day regression
D9	Table D9: Final replacement values
PriorDailyWgts	Adjusted prior daily weights
TDR_0	Final/preliminary trading day regression, part 1	MONTHLY only, TDREGR=ADJUST, TEST
TDR_1	Final/preliminary trading day regression, part 2	MONTHLY only, TDREGR=ADJUST, TEST
StandErrors	Standard errors of trading day adjustment factors	MONTHLY only, TDREGR=ADJUST, TEST
D9A	Year-to-year change in irregular and seasonal components and moving seasonality ratio
StableSeasTest	Stable seasonality test	MONTHLY only
StableSeasFTest	Stable seasonality test	MONTHLY only
f2a	F2 summary measures, part 1
f2b	F2 summary measures, part 2
f2c	F2 summary measures, part 3
f2d	I/C ratio for monthly/quarterly span
f2f	Average percent change with regard to sign and standard over span
E4	Differences or ratios of annual totals, original and adjusted series
ChartG1	Chart G1
ChartG2	Chart G2
ODS Tables Created by the ARIMA Statement
CriteriaSummary	Criteria summary	ARIMA statement
ConvergeSummary	Convergence summary
ArimaEst	ARIMA estimation results, part 1
ArimaEst2	ARIMA estimation results, part 2
Model_Summary	Model summary
Ljung_BoxQ	Table of Ljung-Box Q statistics
A13	Table A13: ARIMA forecasts
A14	Table A14: ARIMA backcasts
A15	Table A15: ARIMA extrapolation
ODS Tables Created by the SSPAN Statement
SPR0A_1	S 0.A sliding spans analysis, number, and length of spans
SpanDates	S 0.A sliding spans analysis: dates of spans
SPR0B	S 0.B summary of F-tests for stable and moving seasonality
SPR1_1	S 1.A range analysis of seasonal factors
SPR1_b	S 1.B summary of range measures
SPRXA	2XA.1 breakdown of differences by month or quarter
SPRXB_2	S X.B histogram of flagged observation
SPRXA_2	S X.A.2 breakdowns of differences by year
MpdStats	S X.C: Statistics for maximum percentage differences
S_X_A_3	S 2.X.3 breakdown summary of flagged observation
SPR7_X	S 7.X sliding spans analysis	PRINTALL

Table 10.94: ODS Table Names Produced by the X12 Procedure
Table Name	Description
A1	Original series
A2	Prior-adjustment factors
RegParameterEstimates	Regression model parameter estimates
ACF	Autocorrelation factors
PACF	Partial autorrelation factors
ARMAIterationTolerances	Exact ARMA likelihood estimation iteration tolerances
IterHistory	ARMA iteration history
ARMAIterationSummary	Exact ARMA likelihood estimation iteration summary
RegressorGroupChiSq	Chi-Squared tests for groups of regressors
ARMAParameterEstimates	Exact ARMA maximum likelihood estimation
AvgFcstErr	Average absolute percentage error in within(out) sample fore(back)casts
Roots	(Non)seasonal (AR)MA roots
MLESummary	Estimation summary
ForecastCL	Forecasts, standard errors, and confidence limits
MV1	Original series adjusted for missing value regressors
A6	RegARIMA trading day component
A8	RegARIMA combined outlier component
A8AO	RegARIMA AO outlier component
A8LS	RegARIMA level change outlier component
A8TC	RegARIMA temporary change outlier component
B1	Prior adjusted or original series
C17	Final weight for irregular components
C20	Final extreme value adjusted factors
D1	Modified original data, D iteration
D7	Preliminary trend cycle, D iteration
D8	Final unmodified S-I ratios
D8A	Seasonality tests
D9	Final replacement values for extreme S-I ratios
D9A	Moving seasonality ratio
D10	Final seasonal factors
D10D	Final seasonal difference
D11	Final seasonally adjusted series
D12	Final trend cycle
D13	Final irregular series
D16	Combined adjustment factors
D16B	Final adjustment differences
D18	Combined calendar adjustment factors
E4	Ratios of annual totals
E5	Percent changes in original series
E6	Percent changes in final seasonally adjusted series
E7	Differences in final trend cycle
F2A-I	Summary measures
F3	Quality assessment statistics
F4	Day of the week trading day component factors
G	Spectral analysis