*** Datasets must be sorted on key variables prior to merging. ***

For Inner Join: Perform any of the Outer Joins and remove rows with missing values

Open 1to1 left.sav                         Open 1to1 right.sav 

Go to 1to1 left.sav → Data → Merge Files → Add Variables

A keyed table (also called lookup file) has two basic characteristics:

1. A keyed table has to have unique cases based on the key variable(s).
2. A keyed table doesn't contribute cases to the merged file. It contributes variables only.

Remove rows with missing values: Data → Select Cases

The NMISS function in the Missing category will count the number of missing values in a row, and if the number is not zero, the case will be deleted, as indicated by the radio button selection in the screenshot above.

--- The End ---