SPSS Update File

Usage

To overwrite values in a master file with non-null values in transaction files, try:

update file=LEFT
  /file=TRANSACTION
  /by KEYVARLIST.

The final dataset contains all rows and variables from all datasets. Rows and variables originating from a transaction file are appended.

File

Each /FILE subcommand takes one of:

• a star (*) indicating the active data set

• the name of a data set
• a filename or file handle

The master dataset is always modified in-place by the update.

By

The /BY subcommand specified how cases can be uniquely identified. The KEYVARLIST can be one ore more variables.

The folowing are required of key variables:

• They must be defined and have the same format in each file (including length for string variables)
• They must uniquely identify a case in each file
• Each file must be pre-sorted by them

CategoryRicottone