Editing a table definition using the Table Syntax pane

In the Design tab, the table definition appears in graphical format. You may have noticed that as you create a table in this tab, the full table definition is displayed in the Table Syntax pane at the bottom of the screen.

For example, if you create the tables described in Adding and nesting variables, the Table Syntax pane displays:

age * gender + interview

for the first table, and:

age * interview > gender

for the second table.

This is useful, for example, when you want to copy and paste the table definition into another table, or into a script in another application. You can also edit the table definition directly in this pane once you become familiar with the syntax, and you can even use this pane to create a table definition from scratch.

Displaying the Table Syntax pane if it is not visible

From the menu, choose

The pane appears at the bottom of the screen. You can resize it and move it around the IBM® SPSS® Data Collection Survey Reporter window as required.

Editing the table syntax

Place the cursor in the Table Syntax pane and type in the table definition.

To validate and apply the syntax, choose the Apply button. If the syntax is valid, the Design pane is automatically updated to show the table structure. If it is not valid, an error is displayed.

If you make a mistake while editing the syntax, choose the Cancel button to return to the previously applied syntax.

See the topic Table Specification Syntax for more information.

You can use any expression that is supported by the IBM® SPSS® Data Collection Data Model, including the functions in the IBM SPSS Data Collection Function Library. See the Function List for details of the functions available.

See also the Expression Evaluation and Data Collection Function Library topics in the IBM® SPSS® Data Collection Scripting section of the IBM® SPSS® Data Collection Developer Library for further information on syntax.