|
Size: 1126
Comment:
|
Size: 1266
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 43: | Line 43: |
| The `UPDATE` command is queued as a pending transformation. | Execution of the `UPDATE` command is deferred until the active dataset is read, or until one of the [[SPSS/Execute|EXECUTE]], [[SPSS/FileIO|SAVE]], or [[SPSS/SortCases|SORT CASES]] commands are used. |
SPSS Update
The UPDATE command overwrites values in a dataset with non-missing values from another dataset.
Contents
Usage
update file=foo /file=bar /by KEYVARS.
The master file is modified in-place. Rows and columns originating from a transaction file are appended.
The key variables must be defined with the same format (including length for string variables) in each dataset. Cases must be uniquely identified by the key variables in each dataset.
Each dataset must be presorted by the key variables.
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
Data Model
The UPDATE command reads all datasets and data files named on /FILE subcommands.
Execution of the UPDATE command is deferred until the active dataset is read, or until one of the EXECUTE, SAVE, or SORT CASES commands are used.