Controlling Pivot Tables by Name

Most IBM® SPSS® Statistics procedures produce several types of pivot tables in their output. For example, the Regression procedure produces an ANOVA table, a Coefficients table, and other tables. Pivot tables produced by IBM SPSS Statistics procedures have internal names that you can use to display specific pivot tables produced by a procedure. For example, if you want to display only the Regression ANOVA table, you can do that on the Batch Facility command line by specifying the table's name after the -keep switch.

You can control which of a procedure's pivot tables appear in the output with the following switches and the appropriate table name(s):

Table 1. Switches for pivot table names
Switch Description
-keep table name(s) Produces the procedure pivot tables that are named after the switch.
-drop table name(s) Does not produce the pivot tables that are named after the switch.

Note: Output requested with the OUTPUT SAVE command honors these switches.

You can use the IBM SPSS Statistics client user interface to find table names:

  1. Use the IBM SPSS Statistics client user interface to produce the output of interest.
  2. In the output window outline pane, right click on the outline pane entry for the table.
  3. From the context menu choose Copy OMS Command Identifier.
  4. Paste the copied OMS command identifier into any text editor (or a syntax window).
  5. Right-click the outline pane entry again and choose Copy OMS Table Subtype.
  6. Paste the copied OMS table subtype after the OMS command identifier. At this point, you have something that looks like this:

    'Command Identifier' 'Subtype Name'

  7. Between the command identifier and the subtype name, insert _Table_.
  8. Remove the single quotes and any spaces in the identifier and subtype names.

The final result is the unique table name, which has the general form:

CommandIdentifier_Table_SubtypeName