Skip to Main Content

Quantitative Analysis Guide: Merging Data Sets

Resources and support for statistical and numerical data analysis

Joining Datasets


This table illustrates basic types of joining of flat data sets containing common key variables.

Merges and Joins examples

Concatenating (merging without keys)

Concatenating

Adding Rows (without pairing)

Adding Rows without pairing

Adding Rows (with pairing)

Adding Rows with pairing


This type of merge is not available through SPSS menu dialogs.


This type of merge is not available through SPSS menu dialogs.


This type of merge is not available through SPSS menu dialogs.


This type of merge is not available through SPSS menu dialogs.


This type of merge is not available through SPSS menu dialogs.


This type of merge is not available through SPSS menu dialogs.