Comparing datasets

Compare Datasets compares the active dataset to another dataset in the current session or an external file in IBM® SPSS® Statistics format.

To compare datasets

  1. Open a data file and make sure it is the active dataset. (You can make a dataset the active dataset by clicking on the Data Editor window for that dataset.)
  2. From the menus choose:

    Data > Compare Datasets

  3. Select the open dataset or IBM SPSS Statistics data file that you want to compare to the active dataset.
  4. Select one or more fields (variables) that you want to compare.

Optionally, you can:

  • Match cases (records) based on one or more case ID values.
  • Compare data dictionary properties (field and value labels, user-missing values, measurement level, etc).
  • Create a flag field in the active dataset that identifies mismatched cases.
  • Create new datasets that contain only matched cases or only mismatched cases.