Support #1343: Creating a family group for profile of parents - Understanding Society User Support

Support #1343

Creating a family group for profile of parents

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

Status:

Resolved

Priority:

Normal

Assignee:

Category:

Start date:

05/12/2020

% Done:

100%

Description

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

parents_children_matching.do (1.94 KB) parents_children_matching.do

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,

Annette

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

Hello,

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,
Alita

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,
Katie

Updated by Alita Nandi almost 4 years ago

File parents_children_matching.do parents_children_matching.do added
% Done changed from 50 to 60

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,
Alita

Updated by Katie Quy almost 4 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,
Katie