I am trying to merge 2 datafiles which both contain valuable information in SPSS.
The big one has 4000 persons in it, and a couple of variables. amongst them, 40 places of birth.
I want to add the small database which contains 40 places of birth. The data has to be linked to every place of birth.
If I try to run "merge files" I get an outcome, but only for 1 case per place of birth there is an outcome provided. How can i results for all the case and places of birth?
Hi Sander, I can not answer your question directly because I don't know SPSS. I would guess that you are doing something wrong. Shooting form the hip, I would say that it is a parameter or setting, or you are trying to merge the wrong way around (the resulting table should have 4000 rows, not 40).
If you can not get it to work at all, then use a relational database like Access or FileMaker (personally, I prefer the latter because it is easier to use), because what you are trying to do is typically what relational databases are made for.
- Badges
- Science topic
- Similar topics
- Biological Science
- Kinesiology
- Running