Differences between revisions 4 and 5
Revision 4 as of 2023-06-09 20:29:17
Size: 943
Comment:
Revision 5 as of 2023-06-11 21:09:12
Size: 1126
Comment:
Deletions are marked like this. Additions are marked like this.
Line 39: Line 39:
== Data Model ==

The `UPDATE` command reads all datasets and data files named on `/FILE` subcommands.

The `UPDATE` command is queued as a pending transformation.

----


SPSS Update

The UPDATE command overwrites values in a dataset with non-missing values from another dataset.


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.

The UPDATE command is queued as a pending transformation.


See also

PSPP manual for UPDATE


CategoryRicottone

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