User Guide

616
Chapter 45
Output labels. Output label options (Edit menu, Options, Output Labels tab) control
the display of variable and data value information in pivot tables. You can display
variable na
mes and/or defined variable labels, actual data values and/or defined value
labels. Descriptive variable and value labels often make it easier to interpret your
results; however, long labels can be awkward in some tables.
Column widt
h.
Pivot table options (Edit menu, Options, Pivot Table tab) control the
default TableLook and the automatic adjustment of column widths in pivot tables.
 Labels only adjusts the column width to the width of the column label. This
produces m
ore compact tables, but data values wider than the label will not be
displayed (asterisks indicate values too wide to be displayed).
 Labels and data adjusts the column width to whichever is larger, the column
label or the largest data value. This produces wider tables, but it ensures that
all value
s will be displayed.
Producti
on jobs use the current TableLook and Options settings in effect. You can
set the TableLook and Options settings before running your production job, or you
can use
SET commands in your syntax files to control them. Using SET commands
in syntax
files enables you to use multiple TableLooks and Options settings in the
same job.
Creatin
g a Custom Default TableLook
E Activa
te a pivot table (double-click anywhere in the table).
E From th
e menus choose:
Format
TableLook...
E
Select a TableLook from the list and click Edit Look.
E Adjust the table properties for the attributes that you want.
E Click Save Look or Save As to save the TableLook and click OK.
E From the menus choose:
Edit
Options...