Merging a_child with a_indresp
I'm Jesse, a PhD researcher based at the University of Southampton currently using USoc as part of a mixed-methods study. I use SPSS as my software programme.
I've been trying to merge the a_child dataset with the a_indresp data-set so that I can look at how childcare provision varies by ethnic group. I'm particularly interested in looking at grandparents who may provide care. I've tried to pair the data-sets by using pipd, but for some reason they don't match up i.e. the pipd numbers for the cases in a_child are not in the a_indrep set. The hidp do match, but due to multiple entries per house I'm unable to link the data-sets. Any help or advice would be very much appreciated.
My SPSS skills are somewhat basic, so I may be going wrong somewhere on the technical side. Apologies if this is an easy fix and many thanks for any support.
#1 Updated by Gundi Knies over 1 year ago
- Category set to Data analysis
- Status changed from New to Feedback
- Assignee set to Jesse Shipp
- Target version set to X M
- % Done changed from 0 to 70
please take a look at my response to https://iserswww.essex.ac.uk/support/issues/971 -- it explains how you can merge information from the child record with information adults in the household have provided. You'll need to adapt the method a little but the principle is the same. Pointers to the grandparents in the household are provided in the child records.