Merging datasets - no unique ID for i...

Merging datasets - no unique ID for individuals, only for households

Posted in the SPSS Forum


Atlanta, GA

#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!

Tell me when this thread is updated:

Subscribe Now Add to my Tracker

Add your comments below

Characters left: 4000

Please note by submitting this form you acknowledge that you have read the Terms of Service and the comment you are posting is in compliance with such terms. Be polite. Inappropriate posts may be removed by the moderator. Send us your feedback.

SPSS Discussions

Title Updated Last By Comments
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
News 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
More from around the web