Support #977

Merging a_child with a_indresp

Added by Jesse Shipp over 5 years ago. Updated about 1 month ago.

Data management
Start date:
% Done:




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.

Best wishes,
Jesse Shipp


Updated by Gundi Knies over 5 years 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

Hi Jesse,
please take a look at my response to -- 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.


Updated by Jesse Shipp over 5 years ago

Hi Gundi,

That post has explained the mechanics of what I need to do precisely, thank you!

Best wishes,



Updated by Stephanie Auty over 5 years ago

  • Private changed from Yes to No

Updated by Stephanie Auty about 5 years ago

  • Status changed from Feedback to Resolved
  • % Done changed from 70 to 100

Updated by Understanding Society User Support Team about 1 month ago

  • Category changed from Data analysis to Data management

Also available in: Atom PDF