COLUMNS Subcommand (OMS command)

You can use the COLUMNS subcommand to specify the dimension elements that should appear in the columns. All other dimension elements appear in the rows.

• This subcommand applies only to tables that would be displayed as pivot tables in the Viewer and is ignored without warning if the OMS command does not include any tables.
• With DESTINATION FORMAT = SAV, columns become variables in the data file. If you specify multiple dimension elements on the COLUMNS subcommand, then variable names will be constructed by combining nested element and column labels. See the topic Routing Output to SAV Files (OMS command) for more information.
• The COLUMNS subcommand has no effect on pivot tables displayed in the Viewer.
• If you specify multiple dimension elements, they are nested in the columns in the order in which they are listed on the COLUMNS subcommand. For example: COLUMNS DIMNAMES=['Variables' 'Statistics'] will nest statistics within variables in the columns.
• If a table doesn't contain any of the dimension elements listed, then all dimension elements for that table will appear in the rows.