Differences between revisions 1 and 2
⇤ ← Revision 1 as of 2023-01-13 23:16:15 →
Size: 1019
Editor: DominicRicottone
Comment:
← Revision 2 as of 2023-06-09 20:09:09 → ⇥
Size: 1061
Editor: DominicRicottone
Comment:
Deletions are marked like this. Additions are marked like this.
Line 1: Line 1:
## page was renamed from SPSS/UpdateFile

SPSS Update File

Contents

  1. SPSS Update File
    1. Usage
      1. File
      2. By

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

SPSS/Update (last edited 2024-01-02 17:07:57 by DominicRicottone)