Support #1005
openParents-children dyads
100%
Description
Dear all,
I would like to know your advise about the following issue:
I need to create dyads for each parents-children relationsship (thus, in one row information of father and children 1, in another mother and children 1, in another father and children 2, and so on and so forth).
Basically, from
a_hidp a_pno pidp a_sex a_dvage a_hgbiom a_hgbiof
1 1 68652807 female 48 0 0
1 2 68652811 male 46 0 0
1 3 68652815 female 17 1 2
1 4 68652819 male 20 1 2
to
a_hidp a_pno a_hgbiom a_sex a_dvage Mother_sex Mother_age Father_sex Father _age
1 3 1 female 17 female 48 . .
1 3 2 female 17 . . male 46
1 4 1 male 20 female 48 . .
1 4 2 male 20 . . male 46
I tried to adapt the procedure descripted in the example 7 (how to match the information of partners), but it did not work because Stata says "variables a_hidp a_pno do not uniquely identify observations in the master data"
I suspect that this is due to the fact that there is not a 1-to-1 correspondance between a_pno and a_hgbiom (a father\mother can have several children, differently from the relationsip 1 partner-to-1 partner).
Do you have any clue about how to do this task?
Thanks a lot in advance for your support.
Best, G.
Files
Updated by Giorgio Piccitto over 6 years ago
Sorry, I attach the two tables (the first what we have, the second what we want) because they came up not well-aligned.
Thanks again, best, G.
Updated by Stephanie Auty over 6 years ago
- Status changed from New to In Progress
- Assignee set to Stephanie Auty
- % 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.
Best wishes,
Stephanie Auty - Understanding Society User Support Officer
Updated by Stephanie Auty over 6 years ago
- Status changed from In Progress to Feedback
- Assignee changed from Stephanie Auty to Giorgio Piccitto
- % Done changed from 10 to 70
Dear Giorgio,
To solve this problem, you can split the file into male and female respondents. Then use the male file to merge children to fathers (in a 1:m or m:1 merge, depending on which is the 'using' file) and use the female file to merge children to mothers. You can then append these files to create the file you want to use.
There is some syntax available at the bottom of this page under syntax/code, a file named linking_parents_information by Alita Nandi, which may help: https://discover.ukdataservice.ac.uk/catalogue/?sn=6614&type=Data%20catalogue#close
Best wishes,
Stephanie Auty - Understanding Society User Support Officer
Updated by Stephanie Auty over 6 years ago
- Status changed from Feedback to Resolved
- % Done changed from 70 to 100