Table Options

BOX=value

BOX={<label=value> <STYLE=<style-element-name>[style-attribute-name=style-attribute-value<… style-attribute-name=style-attribute-value>]>}

specifies text and a style element for the empty box above the row titles.

Value can be one of the following:

_PAGE_

writes the page-dimension text in the box. If the page-dimension text does not fit, then it is placed in its default position above the box, and the box remains empty.

'string'

writes the quoted string in the box. Any string that does not fit in the box is truncated.

variable

writes the name (or label, if the variable has one) of a variable in the box. Any name or label that does not fit in the box is truncated.

For details about the arguments of the STYLE= option and how it is used, see STYLE= in the PROC TABULATE statement.

Examples:Creating Multipage Tables

Specifying Style Elements for ODS Output

CONDENSE

prints as many complete logical pages as possible on a single printed page or, if possible, prints multiple pages of tables that are too wide to fit on a page one below the other on a single page, instead of on separate pages. A logical page is all the rows and columns that fall within one of the following:

• a page-dimension category (with no BY-group processing)
• a BY group with no page dimension
• a page-dimension category within a single BY group

Restriction:CONDENSE has no effect on the pages that are generated by the BY statement. The first table for a BY group always begins on a new page.

Example:Creating Multipage Tables

CONTENTS=link-name

enables you to name the link in the HTML table of contents that points to the ODS output of the table that is produced by using the TABLE statement.

Note: CONTENTS= affects only the contents file of ODS HTML output. It has no effect on the actual TABULATE procedure reports.

FORMAT_PRECEDENCE=PAGE|ROW|COLUMN|COL

specifies whether the format that is specified for the page dimension (PAGE), row dimension (ROW), or column dimension (COLUMN or COL) is applied to the contents of the table cells.

Default:COLUMN

FUZZ=number

supplies a numeric value against which analysis variable values and table cell values other than frequency counts are compared to eliminate trivial values (absolute values less than the FUZZ= value) from computation and printing. A number whose absolute value is less than the FUZZ= value is treated as zero in computations and printing. The default value is the smallest representable floating-point number on the computer that you are using.

INDENT=number-of-spaces

specifies the number of spaces to indent nested row headings, and suppresses the row headings for class variables.

Restriction:In the HTML, RTF, and Printer destinations, the INDENT= option suppresses the row headings for class variables but does not indent nested row headings.

Tip:When there are no crossings in the row dimension, there is nothing to indent, so the value of number-of-spaces has no effect. However, in such cases INDENT= still suppresses the row headings for class variables.

See:Indenting Row Headings and Eliminating Horizontal Separators (with crossings) Creating Multipage Tables (without crossings)

MISSTEXT='text'

MISSTEXT={<label='text'> <STYLE=<style-element-name> [style-attribute-name=style-attribute-value <... style-attribute-name=style-attribute-value>]>}

supplies up to 256 characters of text to print and specifies a style element for table cells that contain missing values. For details about the arguments of the STYLE= option and how it is used, see STYLE= in the PROC TABULATE statement.

Interaction:A style element that is specified in a dimension expression overrides a style element that is specified in the MISSTEXT= option for any given cells.

Examples:Providing Text for Cells That Contain Missing Values

Specifying Style Elements for ODS Output

NOCELLMERGE

specifies that data cells are not merged with other data cells in the table.

Note: The NOCELLMERGE option works with the ODS formatted destinations. These include the ODS MARKUP family, ODS RTF, and the ODS PRINTER family destinations.

Restriction:The NOCELLMERGE does not work with the traditional monospace output.

Interactions:If you specify ROW=FLOAT or INDENT=0, PROC TABULATE produces single unmerged data rows. The NOCELLMERGE option is then ignored because there are no rows that need to be merged.

If the NOCELLMERGE option is in effect, the style of the empty data cells will be the default style of the data cell. The style of the empty data cells might not be the same style as the style of the formatted data cells.

Example:NOCELLMERGE Option

NOCONTINUED

suppresses the continuation message, continued, that is displayed at the bottom of tables that span multiple pages. The text is rendered with the AFTERCAPTION style element.

Note: Because HTML browsers do not break pages, NOCONTINUED has no effect on the HTML destination.

PRINTMISS

prints all values that occur for a class variable each time headings for that variable are printed, even if there are no data for some of the cells that these headings create. Consequently, PRINTMISS creates row and column headings that are the same for all logical pages of the table, within a single BY group.

Default:If you omit PRINTMISS, then PROC TABULATE suppresses a row or column for which there are no data, unless you use the CLASSDATA= option in the PROC TABULATE statement.

Restriction:If an entire logical page contains only missing values, then that page does not print regardless of the PRINTMISS option.

See:CLASSDATA=SAS-data-set

Example:Providing Headings for All Categories

ROW=spacing

specifies whether all title elements in a row crossing are allotted space even when they are blank. The possible values for spacing are as follows:

CONSTANT

allots space to all row titles even if the title has been blanked out. (For example, N=' '.)

Alias:CONST

FLOAT

divides the row title space equally among the nonblank row titles in the crossing.

Default:CONSTANT

Example:Eliminating Row Headings

RTSPACE=number

specifies the number of print positions to allot to all of the headings in the row dimension, including spaces that are used to print outlining characters for the row headings. PROC TABULATE divides this space equally among all levels of row headings.

Alias:RTS=

Default:one-fourth of the value of the SAS system option LINESIZE=

Restriction:The RTSPACE= option affects only the traditional SAS monospace output destination.

Interaction:By default, PROC TABULATE allots space to row titles that are blank. Use ROW=FLOAT in the TABLE statement to divide the space among only nonblank titles.

See:For more examples of controlling the space for row titles, see PROC TABULATE by Example, Second Edition.

Example:Creating a Basic Two-Dimensional Table

STYLE=<style-element-name> [style-attribute-name=style-attribute-value<… style-attribute-name=style-attribute-value>]

specifies a style element to use for parts of the table other than table cells. See STYLE= in the PROC TABULATE statement for information about the style element arguments.

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

The following table shows the attributes that you can set or change with the STYLE= option in the TABLE statement. Most of these attributes apply to parts of the table other than cells (for example, table borders and the lines between columns and rows). Attributes that you apply in the PROC TABULATE statement and in other locations in the PROC TABULATE step apply to cells within the table. Note that not all attributes are valid in all destinations. See Style Attributes Tables in SAS Output Delivery System: User's Guide for information about these style attributes, their valid values, and their applicable destinations.

Style Attributes for PROC REPORT and PROC TABULATE

Attribute	PROC REPORT STATEMENT: REPORT Area	PROC REPORT Areas: CALLDEF, COLUMN, HEADER, LINES, SUMMARY	PROC TABULATE STATEMENT: TABLE	PROC TABULATE STATEMENTS: VAR, CLASS, BOXOpt, CLASSLEV, KEYWORD
ASIS=	X	X		X
BACKGOUNDCOLOR=	X	X	X	X
BACKGOUNDIMAGE=	X	X	X	X
BORDERBOTTOMCOLOR=	X	X		X
BORDERBOTTOMSTYLE=	X	X	X	X
BORDERBOTTOMWIDTH=	X	X	X	X
BORDERCOLOR=	X	X		X
BORDERCOLORDARK=	X	X	X	X
BORDERCOLORLIGHT=	X	X	X	X
BORDERTOPCOLOR=	X	X		X
BORDERTOPSTYLE=	X	X	X	X
BORDERTOPWIDTH=	X	X	X	X
BORDERWIDTH=	X	X	X	X
CELLPADDING=	X		X
CELLSPACING=	X		X
CELLWIDTH=	X	X	X	X
CLASS=	X	X	X	X
COLOR=	X	X	X
FLYOVER=	X	X		X
FONT=	X	X	X	X
FONTFAMILY=	X	X	X	X
FONTSIZE=	X	X	X	X
FONTSTYLE=	X	X	X	X
FONTWEIGHT=	X	X	X	X
FONTWIDTH=	X	X	X	X
FRAME=	X		X
HEIGHT=	X	X		X
HREFTARGET=		X		X
HTMLSTYLE=	X	X	X	X
NOBREAKSPACE=	X	X		X
OUTPUTWIDTH=	X	X	X	X
POSTHTML=	X	X	X	X
POSTIMAGE=	X	X	X	X
POSTTEXT=	X	X	X	X
PREHTML=	X	X	X	X
PREIMAGE=	X	X	X	X
PRETEXT=	X	X	X	X
PROTECTSPECIALCHARS=		X		X
RULES=	X		X
TAGATTR=	X	X		X
TEXTALIGN=	X	X	X	X
URL=		X		X
VERTICALALIGN=		X		X
WIDTH=	X	X	X	X

Note: The list of attributes that you can set or change with the STYLE= option in the TABLE statement differs from the list of attributes of the PROC TABULATE statement.

Alias:S=

Restriction:This option affects only the HTML, RTF, and Printer destinations.

Tip:To override a style element specification that is made as an option in the TABLE statement, specify STYLE= in a dimension expression of the TABLE statement.

Example:Specifying Style Elements for ODS Output

STYLE_PRECEDENCE=PAGE|ROW|COLUMN|COL

specifies whether the style that is specified for the page dimension (PAGE), row dimension (ROW), or column dimension (COLUMN or COL) is applied to the contents of the table cells.

Default:COLUMN

Example:Style Precedence