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.

For more information, see VARIABLE LEVEL.

LABEL

Descriptive variable label.

For more information, see VARIABLE LABELS.

VALUELABELS

Descriptive value labels.

For more information, see VALUE LABELS.

COLUMNS

Column width in Data view of the Data Editor.

For more information, see VARIABLE WIDTH.

MISSING

Defined user-missing values.

For more information, see MISSING VALUES.

ALIGN

Alignment in Data view of the Data Editor.

For more information, see VARIABLE ALIGNMENT.

ROLE

Variable role.

For more information, see VARIABLE ROLE.

ATTRIBUTES

User-defined custom variable attributes.

For more information, see VARIABLE ATTRIBUTE.

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.

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