Data – SPSS – Merge files (Add Cases)

For example you have created two exact the same projects – one for country1 and one for country2.
And now you need to merge the two data files together to have 1 complete data file.
We also make one extra variable so we can distinquish the countries in the total data file.

1. Open SPSS
2. Open file 1 and file 2
3. Add a variable in both files, call this countrycode

   

   In the dataview just add 1 (for file1) and 2 (for file2) in countrycode for each respondent

   

4. The variable ID is unique, make sure to sort the ID ascending in both sav files

   

5. We want to add the data from file2 into file1
6. Make sure to do the following in file1 (not in file2!)
   • Data – > Merge – > Add cases

     

   • Select data file 2 and Click on OK
7. Data file 1 contains all data now from file 1 and file 2, save the file now to a new data file