OUTPUT subcommand (COMPARE DATASETS command)

You can use the optional OUTPUT command to produce a table that compares dictionary information between the two files and control the display of the case-by-case comparison table.

VARPROPERTIES=NONE | ALL | MEASURE LABEL VALUELABELS COLUMNS MISSING ALIGN ROLE ATTRIBUTES WIDTH. Produces a table that compares the specified data dictionary properties for each variable in the two datasets. The default is NONE.

• MEASURE. Measurement level. See the topic VARIABLE LEVEL for more information.
• LABEL. Descriptive variable label. See the topic VARIABLE LABELS for more information.
• VALUELABELS. Descriptive value labels. See the topic VALUE LABELS for more information.
• COLUMNS. Column width in Data view of the Data Editor. See the topic VARIABLE WIDTH for more information.
• MISSING. Defined user-missing values. See the topic MISSING VALUES for more information.
• ALIGN. Alignment in Data view of the Data Editor. See the topic VARIABLE ALIGNMENT for more information.
• ROLE. Variable role. See the topic VARIABLE ROLE for more information.
• ATTRIBUTES. User-defined custom variable attributes. See the topic VARIABLE ATTRIBUTE for more information.
• WIDTH. For numeric variables, the maximum number of characters displayed (digits plus formatting characters, such as currency symbols, grouping symbols, and decimal indicator). For string variables, the maximum number of bytes allowed.

CASETABLE=YES|NO. Produces a case-by-case comparison table that contains mismatch details. For each case and each variable, the table displays the values that are different in the two files. The default is YES. Use the optional TABLELIMIT keyword to limit the table to the first n cases with mismatches. The default is 100. TABLELIMIT=NONE will display all mismatches.

Example

/OUTPUT
  VARPROPERTIES=MEASURE WIDTH
  CASETABLE=YES TABLELIMIT=500