Understanding Society User Support

Hello,

The individuals in the files j_child are hh members 0-15 year olds. Those in j_indresp are adult respondents who are 16+ year olds. So, if you try to merge these two files there will be no matched cases. Are you trying to merge children's information with that of their parents?

Best wishes,
Understanding Society User Support Team

Hello Rehana,

You are correct merging by j_hidp and j_rapno8 is the right approach. In the j_child file, the variable j_pno already exists, so you should rename it to something else, like pno_bf. Alternatively, you could rename the j_pno variable in indresp to j_rapno8.

You can also use the Pregnancy and Early Childhood (PEACH) data file (xwavepeach), which is a single cross-wave file that compiles key data reported by parents for all children under 10, along with information on pregnancy and parenting styles, from all waves of the main survey. The information is provided at the child level using the child’s identifier, ensuring each row is uniquely identifiable. Additionally, the pidp identifier of the parent or caregiver who provided the information is included to facilitate linking to family circumstances.

If you only want data from Wave 10, you should filter by wave_newborn = 10 and merge pidp_newbornmother with pidp from indresp. You just need to rename pidp in indresp to match the PEACH identifier (pidp_newbornmother).

You can find more information about the PEACH data here.
https://www.understandingsociety.ac.uk/documentation/peach/

I hope this information is helpful.

Best wishes,
Roberto Cavazos
Understanding Society User Support Team