I have a survey with repeat groups. I did not know data was stored in different sheets. I tried exporting the file as one sheet into SPSS, but I had lots of problems. Could someone help how to merge repeat group data before exporting to SPSS?
I would recommend to
- Import the master and the repeat files separatly
- Import the SPSS label files etc.
- Do (normal) adaptions in SPSS, e.g. type, measurement level
- After both data files are ready, join them in SPSS. This is a standard SPSS feature, well described in the documentation.
Finally, you will have and keep 3 .sav SPSS data sets: Master, Repeats and the Join.
In Analysis, working with the (unjoined) Master is sometimes preferable, depending on the question.