Understanding Society User Support: Issueshttps://iserredex.essex.ac.uk/support/https://iserredex.essex.ac.uk/support/support/favicon.ico?15995719382019-09-09T18:52:50ZUnderstanding Society User Support
Redmine Understanding Society User Support - Support #1241 (Resolved): Problem merging inderesp with chil...https://iserredex.essex.ac.uk/support/issues/12412019-09-09T18:52:50ZMarina Fernandez Reino
<p>Hi,</p>
<p>My objective is to construct a dataset that includes all household members, including children aged 0 to 15. I want to examine certain youth outcomes in migrant families. In order to do that, I need to know the country of birth of the natural/adoptive/step mother and natural/adoptive/step father living in the same household as the child. Note that, in this case, I am just going to focus on the co-resident parent(s) regardless of whether they are the natural parents of the child. I am aware that one of the natural parents of child might not reside with the child.</p>
<p>I'm going to to detail the steps I followed so it is easier to understand the problem I have at the moment.</p>
<p>- Firstly I've merged the child and youth dataset. I saved all the variables of interest with capital letters except h_hidp and h_pno.<br />- Secondly, I’ve created couple-level variables in the indresp data file. These variables summarise the country of birth combinations of the partners within a couple, e.g. couples where both partners are UK born. I’ve also generated a variable identifying the country of birth of single adults. <br />- Thirdly, I’ve merged the new indresp dataset with the indall dataset. <br />- Fourthly, I’ve merged the resulting file from above with the children and youth dataset merged in step 1.</p>
<p>The resulting file includes all household members. I’ve generated a couple of variables to identify who is the responsible adult of children aged 0 to 15, so I know if the responsible adult is the mother other family member. The code reads as follows:</p>
<blockquote>
<p>gen motherguardian=1 if (H_ADRESP15_DV==H_MNSPNO) & H_ADRESP15_DV!=. // Adoptive/Natural/Step mother is the responsible adult<br />gen fatherguardian=1 if (H_ADRESP15_DV==H_FNSPNO) & H_ADRESP15_DV!=. // Adoptive/Natural/Step father is the responsible adult<br />gen grandpguardian=1 if ((H_ADRESP15_DV==H_GRFPNO) | (H_ADRESP15_DV==H_GRMPNO)) & H_ADRESP15_DV!=. // Grandparent is the responsible adult<br />gen parentguardian=1 if motherguardian==1 | fatherguardian==1<br />label var parentguardian "Guardian is nat/step/adopt parent"</p>
</blockquote>
<blockquote>
<p>gen guardian=1 if motherguardian==1 | fatherguardian==1<br />replace guardian=2 if grandpguardian==1<br />replace guardian=4 if H_ADRESP15_DV==-8 | H_ADRESP15_DV==-9<br />replace guardian=3 if H_ADRESP15_DV>=1 & H_ADRESP15_DV<=12 & guardian==.<br />lab define guardian ///<br />1 "resp.adult is mother or father" ///<br />2 " resp.adult is grandparent" ///<br />3 " resp.adult who is not parent/grandparent" ///<br />4 " resp.adult missing", replace<br />lab val guardian guardian</p>
</blockquote>
<p>Then I want to identify the country of birth of children’s responsible adults as well as their partners. I’ve already generated this variable in indresp, so I have this information. The problem I have is that there are some households with 2+ children where there is more than 1 responsible adult for those children. I’ve included below a fictitious example of such household <strong>(file attached)</strong>. In this household there are 2 children (h_pno 4 and 5). Each children has different parents and hence different responsible adults. The mother of chidren 4 is UK born and her partner is also UK born. The mother of children 5 is Indian born and she is single. <br /> <br />I want to use a dataset only with children, but I need to have information about the country of birth of co-resdient parents and their couples in such dataset. The problem is that I don’t know how to attach the co-resident parents’ country of birth to each child when there are more than 1 responsible adults in the household (like in the example below) . This is mainly because the variable h_childpno in indresp is missing instead of indicating the pno of the child. This is actually surprising because I thought that h_childpno in indresp should take the value of the child the adult is responsible for.</p>