User Guide

668
Chapter 47
Table Pivots
For pivot table output, you can specify the dimension element(s) that should appear in
the columns. All other dimension elements appear in the rows. For SPSS data file
format, tab
le columns become variables, and rows become cases.
 If you spec
ify multiple dimension elements for the columns, they are nested in the
columns in the order in which they are listed. For SPSS data file format, variable
namesareconstructedbynestedcolumn elements. For more information, see
“Variable
Names in OMS-Generated Data Files” on p. 680.
 If a table
doesn’t contain any of the dimension elements listed, then all dimension
elements for that table will appear in the rows.
 Table pivots specified here have no effect on tables displayed in the Viewer.
Each dimension of a table—row, column, layer—may contain zero or more elements.
For exampl
e, a simple two-dimensional crosstabulation contains a single row
dimension element and a single column dimension element, each of which contains
one of the variables used in the table. You can use either positional arguments or
dimensio
n element “names” to specify the dimension elements that you want to
put in the column dimension.
List of positions. The general form of a positional argument is a letter indicating the
default position of the element—C for column, R for row, or L for layer—followed by
apositi
ve integer indicating the default position within that dimension. For example,
R1 would indicate the outermost row dimension element.
 To specify multiple elements from multiple dimensions, separate each dimension
with a sp
ace. For example: R1 C2.
 The dim
ension letter followed by ALL indicates all elements in that dimension in
their default order. For example, CALL is the same as the default behavior, using
all column elements in their default order to create columns.
 CALL RALL LALL (or RALL CALL LALL, and so on) will put all dimension
elemen
ts in the columns. For SPSS data file format, this creates one row/case per
table in the data file.