Support #1343

Creating a family group for profile of parents

Added by Katie Quy almost 4 years ago. Updated almost 3 years ago.

Start date:
% Done:



I am currently working on a project looking at work and care in families in East London. As part of the project, we would like to create a profile of parents in the UK. Specifically, we are interested in characteristics of two-parent households which include a co-resident child aged 0-4.

So far I have merged hhresp and indresp datasets for wave i and selected respondents who have indicated they are living with a spouse (i_livesp_dv) or cohabiting (i_cohab_dv). I have also selected both i_nch02_dv (children aged 0-2 in hh) i_nch34_dv (children aged 3-4 in hh). I am fairly sure this is not the most elegant way to go about this, and I am not sure that this approach will provide the sample I am looking for. It is missing, for example, data on ethnicity.
Might you be able to help, please?

Files (1.94 KB) Alita Nandi, 05/27/2020 07:55 AM

Updated by Annette Pasotti almost 4 years ago

  • Status changed from New to In Progress
  • Assignee set to Alita Nandi
  • % Done changed from 0 to 10
  • Private changed from Yes to No

Many thanks for your enquiry. The Understanding Society team is looking into it and we will get back to you as soon as we can.

We aim to respond to simple queries within 48 hours and more complex issues within 7 working days. While we will aim to keep to this response times due to the current coronavirus (COVID-19) related situation it may take us longer to respond.

Best wishes,



Updated by Alita Nandi almost 4 years ago

  • Status changed from In Progress to Feedback
  • Assignee changed from Alita Nandi to Katie Quy
  • % Done changed from 10 to 50


While using the variables i_nch02_dv and i_nch34_dv will help you identify households with children in this age group, these will not help you identify who their parents are. But you could combine this with the i_hhtype_dv to get your sample. This is a quick solution but it is not very precise as i_nch* variables do not say whose children they are.

A more precise option is to use the file i_indall to identify children aged 0-2 (i_age_dv) and then get the pidp of their co-resident parents (i_mnpid i_fnpid). Then using that you can identify households where there are two parents with children 0-2 years old. This will require some restructing of the data, please let us know if you need help with this.

Best wishes,


Updated by Katie Quy almost 4 years ago

Thank you for you response! The second, more precise, option sounds exactly what I am looking for. I would be grateful for any help you could give with restructuring data to achieve this.
Best wishes,


Updated by Alita Nandi over 3 years ago

Hi Katie,

I am attaching a syntax file that attaches co-resident parents information. See if this works for you. If not, let us know. We will be uploading this to our syntax page for other users, so any feedback you provide will help us improve it.

Best wishes,


Updated by Katie Quy over 3 years ago

Hi Alita,
Unfortunately not (I accept this may be me though!) Is this syntax suitable for use with SPSS? I'm getting error messages for all command names.
best wishes,


Updated by Alita Nandi over 3 years ago

Hi Katie,

Sorry I should have specified that this is a Stata syntax file. So, it will not work with SPSS.

Best wishes,


Updated by Katie Quy over 3 years ago

Ah I see. Is there an equivalent syntax available for SPSS?
Best wishes,


Updated by Alita Nandi over 3 years ago

Sorry Katie, there isn't one as yet.


Updated by Katie Quy over 3 years ago

Ok, thanks anyway
best wishes,


Updated by Understanding Society User Support Team almost 3 years ago

  • Status changed from Feedback to Resolved
  • Assignee deleted (Katie Quy)
  • % Done changed from 60 to 100

Also available in: Atom PDF