Table Specification Syntax

This section provides full details of the table specification syntax. In most cases, you can create tables without needing to understand the syntax, but for particularly complex tables, you can enter or edit the syntax directly, in the Table Syntax pane, the Filter Syntax pane or the Script pane in the New Variable, Edit Variable, or Edit Table Variable dialog boxes. You can also type expressions directly in the Edit Derived Category dialog box and the Create New Variable Based On dialog box.

Detailed documentation on how to write scripts to generate tables is provided in the Data Collection Developer Library (DDL)

Note on terminology

In this section, the terminology used is based on that in the Table Object Model. The following table relates a number of Table Object Model words and phrases to the equivalent features in the IBM® SPSS® Data Collection Survey Reporter user interface.

Table Object ModelSurvey Reporter
AxisThe side or top of a table
Axis expressionEdits made to a variable
ElementA category in a variable, or one of the other items that can appear in a variable such as a mean, subtotal, etc.
Special elementTerm used specifically to refer to the non-categorical items in a variable, such as a mean, subtotal, etc.
ConcatenationAdding multiple variables to the side or top of a table one after the other, without nesting.