Merging datasets - no unique ID for individuals, only for households
Posted in the SPSS Forum
#1 Mar 3, 2013
My thesis data has over 1000 households from a 70 page survey with multiple datasets. It is quite large so I cannot do this in Excel.
I am trying to merge the datasets (by variable). However, I am having difficultly, because my data has unique identifiers for households... but in every household there are different people numbered in order... such as 1, 2, 3, 4. The household number appears on all the datasets (sometimes only once and sometimes multiple times depending how many individuals per household answered that part of the survey).
I don't think I should create a random ID for the individuals (before merging) because I would have to do this in multiple datasets and they would not match and merge properly.
Is it possible to create a unique identifier for the individuals, ideally tied to the household number? So if the household ID is 11222 and the individual ID is 5, it would be nice if there was a new variable listed as 11222_5.
Is there a better method to combine these datasets?
Any help is much appreciated!
Add your comments below
|entering data- percentage frequencies-chi squar...||Wed||Elaheh||1|
|Help with ANOVA||Nov 22||Khill1980||1|
|Help us testing the latest IBM SPSS Standard Ve... (Oct '15)||Nov 7||jilljill||2|
|SPSS founder claims ownership of company name; ... (Dec '07)||Nov 7||jilljill||12|
|Frequency of combinations possible||Nov 6||Aponte||1|
|Cluster Histogram-How to Have 2 category on x axis||Oct '16||spss101||1|
|Making a transposed dataset the active one with...||Oct '16||Triple Burner||1|
Find what you want!
Search SPSS Forum Now
Copyright © 2016 Topix LLC