Support #977

Merging a_child with a_indresp

Added by Jesse Shipp about 2 years ago. Updated almost 2 years ago.

Data analysis
Target version:
Start date:
Due date:
% Done:


Estimated time:



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


#1 Updated by Gundi Knies about 2 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.

#2 Updated by Jesse Shipp about 2 years ago

Hi Gundi,

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

Best wishes,


#3 Updated by Stephanie Auty about 2 years ago

  • Private changed from Yes to No

#4 Updated by Stephanie Auty almost 2 years ago

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

Also available in: Atom PDF