Merging individual and child dataset

Lilly Tee

Join Date: May 2022

Posts: 37
#1

Merging individual and child dataset

09 Aug 2023, 13:43

Hi, I currently have child and individual datasets. I want to merge both datasets to create child-level data. My goal is to be able to identify the children and parents within the household and create new variables matching the children with the characteristics of their parents, such as gender, education, income and so on. Below are the dataex of each data set.
Individual:
input long(pidp g_hidp) byte(g_pno g_sex) int g_age byte(g_nchunder16 g_nch5to15 g_nch10to15 g_nch10 g_jobstat) long parent1_pid byte(parent1_pno parent1_sex) long parent2_pid byte(parent2_pno parent2_sex g_hhsize g_nkids)
68008847 68040812 1 2 57 0 0 0 0 2 -8 0 -8 -8 0 -8 1 0
68061288 68047612 2 2 29 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68009527 68047612 1 1 38 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68010887 68054412 1 2 51 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68017687 68081612 1 2 36 2 2 1 0 2 -8 0 -8 -8 0 -8 3 2
68157166 68115612 2 1 30 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68029931 68122412 2 1 46 1 1 1 0 2 -8 0 -8 -8 0 -8 4 1
68176882 68136012 2 2 28 1 1 0 0 2 -8 0 -8 -8 0 -8 3 1
68032647 68136012 1 1 30 1 1 0 0 2 -8 0 -8 -8 0 -8 3 1
68142890 68142812 2 2 35 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68035367 68142812 1 1 34 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68037407 68156412 1 2 46 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68041487 68170012 1 2 45 2 2 2 0 2 -8 0 -8 -8 0 -8 4 2
68041491 68170012 2 1 42 2 2 2 0 2 -8 0 -8 -8 0 -8 4 2
68042171 68176812 2 2 44 1 1 0 0 2 -8 0 -8 -8 0 -8 3 1
68042167 68176812 1 1 45 1 1 0 0 2 -8 0 -8 -8 0 -8 3 1
68043527 68183612 1 1 61 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68044207 68190412 1 2 39 3 3 1 1 2 -8 0 -8 -8 0 -8 5 3
68045567 68204012 1 2 53 0 0 0 0 2 -8 0 -8 -8 0 -8 3 0
68045571 68204012 2 1 55 0 0 0 0 2 -8 0 -8 -8 0 -8 3 0
68046927 68217612 1 2 42 2 2 2 0 2 -8 0 -8 -8 0 -8 3 2
68049647 68238012 1 1 57 0 0 0 0 2 -8 0 -8 -8 0 -8 3 0
68049651 68238012 2 2 55 0 0 0 0 2 -8 0 -8 -8 0 -8 3 0
68051007 68251612 1 1 54 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68051011 68251612 2 2 47 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68056447 68265212 1 1 52 2 2 2 0 2 -8 0 -8 -8 0 -8 4 2
68060531 68292412 2 2 42 1 1 0 0 2 -8 0 -8 -8 0 -8 3 1
68060527 68292412 1 1 41 1 1 0 0 2 -8 0 -8 -8 0 -8 3 1
68063251 68306012 2 1 50 1 1 1 0 2 -8 0 -8 -8 0 -8 3 1
68063247 68306012 1 2 48 1 1 1 0 2 -8 0 -8 -8 0 -8 3 1
68063927 68312812 1 2 45 1 1 1 0 2 -8 0 -8 -8 0 -8 3 1
68063931 68312812 2 1 47 1 1 1 0 2 -8 0 -8 -8 0 -8 3 1
68065971 68326412 2 2 56 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68066647 68333212 1 2 28 2 2 0 0 2 -8 0 -8 -8 0 -8 4 2
68068007 68340012 1 1 48 0 0 0 0 2 -8 0 -8 -8 0 -8 4 0
68068011 68340012 2 2 48 0 0 0 0 2 -8 0 -8 -8 0 -8 4 0
68071407 68353612 1 1 26 0 0 0 0 2 -8 0 -8 -8 0 -8 1 0
68442808 68435212 3 2 51 0 0 0 0 2 -8 0 -8 -8 0 -8 4 0
68105407 68476012 1 2 48 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68111531 68489612 2 1 34 1 1 0 0 2 -8 0 -8 -8 0 -8 3 1
68111527 68489612 1 2 34 1 1 0 0 2 -8 0 -8 -8 0 -8 3 1
68112207 68496412 1 1 31 2 1 0 0 2 -8 0 -8 -8 0 -8 4 2
68116287 68503212 1 2 32 2 2 1 0 2 -8 0 -8 -8 0 -8 4 2
68120371 68523612 1 1 64 0 0 0 0 2 -8 0 -8 -8 0 -8 1 0
68121047 68530412 1 2 43 0 0 0 0 2 -8 0 -8 -8 0 -8 4 1
68121727 68537212 1 2 62 0 0 0 0 2 -8 0 -8 -8 0 -8 1 0
68122407 68544012 1 2 52 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68125127 68557612 1 2 49 0 0 0 0 2 -8 0 -8 -8 0 -8 3 0
68131927 68571212 1 1 60 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68131931 68571212 2 2 57 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68132607 68578012 1 1 45 0 0 0 0 2 -8 0 -8 -8 0 -8 3 0
68138051 68591612 2 2 61 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68141447 68605212 1 2 54 1 1 1 0 2 -8 0 -8 -8 0 -8 4 2
68144851 68625612 2 2 39 1 1 1 1 2 -8 0 -8 -8 0 -8 3 1
68144847 68625612 1 1 47 1 1 1 1 2 -8 0 -8 -8 0 -8 3 1
68150967 68639212 1 1 53 0 0 0 0 2 -8 0 -8 -8 0 -8 3 0
68150971 68639212 2 2 56 0 0 0 0 2 -8 0 -8 -8 0 -8 3 0
68155051 68659612 2 1 63 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68155047 68659612 1 2 58 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68155731 68680012 1 2 46 0 0 0 0 2 -8 0 -8 -8 0 -8 1 0
68157767 68693612 1 2 50 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68159131 68700412 2 2 35 1 1 1 1 2 -8 0 -8 -8 0 -8 3 1
68159127 68700412 1 1 41 1 1 1 1 2 -8 0 -8 -8 0 -8 3 1
68924886 68707212 2 2 32 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68163887 68707212 1 1 30 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68166607 68720812 1 2 60 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68167967 68727612 1 2 37 2 2 1 0 2 -8 0 -8 -8 0 -8 4 2
68167971 68727612 2 1 37 2 2 1 0 2 -8 0 -8 -8 0 -8 4 2
68173411 68734412 2 1 55 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68173407 68734412 1 2 58 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68180887 68782012 1 2 45 3 3 1 0 2 -8 0 -8 -8 0 -8 5 3
68180891 68782012 2 1 43 3 3 1 0 2 -8 0 -8 -8 0 -8 5 3
68184967 68802412 1 1 41 2 1 0 0 2 -8 0 -8 -8 0 -8 4 2
68185647 68809212 1 2 53 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68187691 68816012 2 2 56 0 0 0 0 2 -8 0 -8 -8 0 -8 3 0
68187687 68816012 1 1 60 0 0 0 0 2 -8 0 -8 -8 0 -8 3 0
68188367 68822812 1 2 46 0 0 0 0 2 -8 0 -8 -8 0 -8 3 0
68191771 68843212 1 2 43 2 2 1 0 2 -8 0 -8 -8 0 -8 3 2
68195851 68870412 2 2 41 0 0 0 0 2 -8 0 -8 -8 0 -8 3 0
68195847 68870412 1 1 46 0 0 0 0 2 -8 0 -8 -8 0 -8 3 0
68197207 68877212 1 1 45 2 2 2 0 2 -8 0 -8 -8 0 -8 5 2
68197211 68877212 2 2 41 2 2 2 0 2 -8 0 -8 -8 0 -8 5 2
68197887 68884012 1 2 54 0 0 0 0 2 -8 0 -8 -8 0 -8 3 0
68197891 68897612 1 1 25 0 0 0 0 2 -8 0 -8 -8 0 -8 1 0
68202647 68904412 1 2 40 1 0 0 0 1 -8 0 -8 -8 0 -8 3 1
69237684 68904412 2 1 39 1 0 0 0 2 -8 0 -8 -8 0 -8 3 1
68213531 68938412 2 1 45 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68213527 68938412 1 2 37 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68214207 68945212 1 1 56 0 0 0 0 2 -8 0 -8 -8 0 -8 1 0
68214891 68952012 2 2 42 2 1 0 0 2 -8 0 -8 -8 0 -8 4 2
68216247 68958812 1 2 41 2 1 0 0 2 -8 0 -8 -8 0 -8 4 2
68216251 68958812 2 1 40 2 1 0 0 2 -8 0 -8 -8 0 -8 4 2
68219647 68972412 1 2 45 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68223727 68992812 1 1 49 2 1 0 0 2 -8 0 -8 -8 0 -8 4 2
68226451 69013212 2 1 44 2 2 1 0 2 -8 0 -8 -8 0 -8 4 2
68227807 69020012 1 1 54 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
69020090 69020012 2 2 53 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68230527 69040412 1 2 48 1 1 1 0 2 -8 0 -8 -8 0 -8 4 1
68238011 69067612 2 2 58 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
69326086 69074412 2 2 56 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
end
label values g_pno g_pno
label values g_sex g_sex
label def g_sex 1 "male", modify
label def g_sex 2 "female", modify
label values g_age g_age
label values g_nchunder16 g_nchunder16
label values g_nch5to15 g_nch5to15
label values g_nch10to15 g_nch10to15
label values g_nch10 g_nch10
label values g_jobstat g_jobstat
label def g_jbstat 1 "Self employed", modify
label def g_jbstat 2 "Paid employment(ft/pt)", modify
label values parent1_pid g_pns1pid
label def g_pns1pid -8 "inapplicable", modify
label values parent1_pno g_pns1pno
label def g_pns1pno 0 "not in hh", modify
label values parent1_sex g_pns1sex
label def g_pns1sex -8 "inapplicable", modify
label values parent2_pid g_pns2pid
label def g_pns2pid -8 "inapplicable", modify
label values parent2_pno g_pns2pno
label def g_pns2pno 0 "not in hh", modify
label values parent2_sex g_pns2sex
label def g_pns2sex -8 "inapplicable", modify
label values g_hhsize g_hhsize
label values g_nkids g_nkids
label def g_nkids_dv 0 "none", modify
[/CODE]

Child:
input long(pidp g_hidp) byte(g_pno g_sex g_age g_health) long parent1_pid byte(parent1_pno parent1_sex) long parent2_pid byte(parent2_pno parent2_sex g_country)
68029939 68122412 4 1 11 2 68029927 1 2 68029931 2 1 1
68041495 68170012 3 1 14 1 68041487 1 2 68041491 2 1 1
68041499 68170012 4 2 12 2 68041487 1 2 68041491 2 1 1
68044215 68190412 3 1 10 1 68044207 1 2 68044211 2 1 1
68046935 68217612 2 2 15 2 68046927 1 2 -8 0 -8 1
68046939 68217612 3 1 11 5 68046927 1 2 -8 0 -8 1
68056459 68265212 4 2 15 1 68056447 1 1 68056451 2 2 1
68056463 68265212 5 2 11 1 68056447 1 1 68056451 2 2 1
68063255 68306012 3 1 15 1 68063247 1 2 68063251 2 1 1
68063935 68312812 3 1 11 2 68063927 1 2 68063931 2 1 1
68086375 68394412 2 2 11 3 68086371 1 2 68414968 3 1 1
68116295 68503212 3 1 13 4 68116287 1 2 68116291 2 1 1
68121059 68530412 4 2 15 3 68121047 1 2 68121051 2 1 1
68142139 68618812 4 1 15 7 68142127 1 2 68142131 2 1 1
68142143 68618812 5 1 11 3 68142127 1 2 68142131 2 1 1
68144855 68625612 3 2 10 2 68144847 1 1 68144851 2 2 1
68159135 68700412 3 2 10 1 68159127 1 1 68159131 2 2 1
68180895 68782012 3 2 15 2 68180887 1 2 68180891 2 1 1
68191775 68843212 2 1 12 3 68191771 1 2 -8 0 -8 1
68197219 68877212 4 2 14 1 68197207 1 1 68197211 2 2 1
68197223 68877212 5 1 13 1 68197207 1 1 68197211 2 2 1
68224415 69006412 4 2 11 3 68224407 1 1 -8 0 -8 1
68226455 69013212 3 2 12 3 68226447 1 2 68226451 2 1 1
68228503 69026812 5 1 11 2 68228487 1 1 68228491 2 2 1
68230539 69040412 4 1 11 3 68230527 1 2 -8 0 -8 1
68231227 69047212 4 2 15 1 68231207 1 2 68231211 2 1 1
68244819 69101612 2 1 11 3 68244807 1 2 -8 0 -8 3
68247539 69108412 4 1 10 3 68247527 1 2 68247531 2 1 1
68265219 69156012 4 2 10 5 68265207 1 2 68265211 2 1 1
68295139 69292012 4 2 10 3 68295127 1 1 68295131 2 2 1
68344771 69564012 2 2 10 2 68344767 1 2 -8 0 -8 1
68351575 69591212 3 2 11 3 68351567 1 2 68351571 2 1 1
68367899 69652412 4 1 13 5 68367887 1 1 68367891 2 2 1
68378115 69686412 8 2 15 2 68378095 3 1 68378099 4 2 1
68412095 69788412 3 2 15 2 68412087 1 2 68412091 2 1 1
68427055 69829212 2 1 10 4 68427047 1 2 -8 0 -8 1
68431135 69842812 3 1 10 3 68431127 1 2 -8 0 -8 1
68531095 70176012 2 1 12 4 68531087 1 2 -8 0 -8 1
68548095 70237212 3 1 14 1 68548087 1 2 68548091 2 1 1
68548099 70237212 4 2 14 3 68548087 1 2 68548091 2 1 1
68561015 70271212 3 1 13 2 68561007 1 2 68561011 2 1 1
68580735 70373212 3 2 11 2 68580727 1 1 68580731 2 2 1
68615419 70529612 4 1 15 2 68615407 1 1 68615411 2 2 1
68624255 70577212 3 1 13 3 68624247 1 1 68624251 2 2 1
68624259 70577212 4 1 10 3 68624247 1 1 68624251 2 2 1
68680015 70828812 3 1 13 2 68680007 1 2 68680011 2 1 1
68704491 70910412 2 1 15 3 68704487 1 2 -8 0 -8 1
68707215 70930812 3 1 14 4 68707207 1 1 68707211 2 2 1
68707219 70930812 4 2 11 4 68707207 1 1 68707211 2 2 1
68740539 71032812 4 2 14 6 68740527 1 1 68740531 2 2 1
68794259 71277612 4 1 14 2 68794247 1 2 68794251 2 1 1
68813979 71338812 4 1 14 1 68813967 1 2 68813971 2 1 1
68813983 71338812 5 1 12 2 68813967 1 2 68813971 2 1 1
68813987 71338812 6 2 11 1 68813967 1 2 68813971 2 1 1
68841175 71400012 2 2 13 2 68841167 1 2 -8 0 -8 1
68867695 71434012 3 1 14 1 68867687 1 2 -8 0 -8 1
68895575 71481612 3 2 10 2 68895571 2 2 -8 0 -8 1
68901695 71488412 3 2 11 2 68901687 1 2 68901691 2 1 1
68903735 71495212 3 2 15 4 68903727 1 2 68903731 2 1 1
68903739 71495212 4 2 10 4 68903727 1 2 68903731 2 1 1
68963575 71712812 3 1 10 1 68963567 1 2 68963571 2 1 1
68964259 71719612 4 1 14 1 68964247 1 1 68964251 2 2 1
68964263 71719612 5 1 14 1 68964247 1 1 68964251 2 2 1
68993503 71821612 5 1 14 3 68993487 1 2 68993491 2 1 1
68993507 71821612 6 2 13 5 68993487 1 2 68993491 2 1 1
69029535 71910012 3 1 12 2 69029527 1 2 -8 0 -8 1
69051291 71984812 2 1 14 2 69051287 1 1 -8 0 -8 1
69053335 71991612 3 2 11 2 69053327 1 1 69053331 2 2 1
69070343 72080012 3 1 11 5 69070331 1 1 69070351 5 2 1
69074419 72134412 4 2 14 2 69074407 1 1 69074411 2 2 1
69075095 72141212 3 2 11 1 69075087 1 1 69075091 2 2 1
69078495 72154812 3 1 15 1 69078487 1 2 69078491 2 1 1
69078499 72154812 4 2 12 2 69078487 1 2 69078491 2 1 1
69083255 72195612 3 2 12 2 69083247 1 1 69083251 2 2 1
69105015 72256812 3 2 14 2 69105007 1 1 69105011 2 2 1
69105019 72256812 4 1 11 5 69105007 1 1 69105011 2 2 1
69111135 72270412 3 2 13 2 69111127 1 1 69111131 2 2 1
69132223 72358812 3 1 15 3 69132207 1 1 69132211 2 2 1
69134935 72372412 3 1 15 3 69134927 1 1 69134931 2 2 1
69134939 72372412 4 2 13 2 69134927 1 1 69134931 2 2 1
69135619 72379212 3 2 15 2 69135607 1 2 69135611 2 1 1
69135623 72379212 4 2 13 2 69135607 1 2 69135611 2 1 1
69146495 72447212 3 1 15 3 69146487 1 2 69146491 2 1 1
69183897 74378412 4 1 12 1 69183885 1 2 69183889 2 1 1
69262775 72862012 3 1 13 2 69262767 1 2 69262771 2 1 3
69298135 72970812 3 2 10 2 69298127 1 2 69298131 2 1 3
69302215 72977612 3 1 13 3 69302207 1 2 69302211 2 1 3
69305621 74398812 4 1 12 2 69305605 1 2 69305609 2 1 1
69307655 73018412 2 1 12 -9 69307647 1 2 73576888 5 1 3
69307659 73018412 3 2 10 3 69307647 1 2 73576888 5 1 3
69325335 73072812 3 2 12 1 69325327 1 1 69325331 2 2 3
69325339 73072812 4 1 11 2 69325327 1 1 69325331 2 2 3
69389255 73127212 2 2 10 2 69389247 1 2 73698648 4 1 1
69431415 73202012 3 2 12 2 69431407 1 1 69431411 2 2 1
69431419 73202012 4 2 11 2 69431407 1 1 69431411 2 2 1
69440951 73208812 6 1 14 2 69440927 1 2 -8 0 -8 1
69451135 73222412 3 1 10 4 69451127 1 1 69451131 2 2 1
69544293 74521212 3 1 15 2 69544285 1 1 69544289 2 2 1
69544297 74521212 4 2 14 2 69544285 1 1 69544289 2 2 1
69603453 74555212 3 1 13 4 69603445 1 1 69603449 2 2 1
end
label values g_pno g_pno
label values g_sex g_sex
label def g_sex 1 "male", modify
label def g_sex 2 "female", modify
label values g_age g_age
label values g_health g_health
label def g_health -9 "missing", modify
label def g_health 1 "1", modify
label def g_health 2 "2", modify
label def g_health 3 "3", modify
label def g_health 4 "4", modify
label def g_health 5 "5", modify
label def g_health 6 "6", modify
label def g_health 7 "7", modify
label values parent1_pid parent1_pid
label values parent1_pno parent1_pno
label values parent1_sex parent1_sex
label def parent1_sex 1 "male", modify
label def parent1_sex 2 "female", modify
label values parent2_pid parent2_pid
label def parent2_pid -8 "inapplicable", modify
label values parent2_pno parent2_pno
label def parent2_pno 0 "not in hh", modify
label values parent2_sex parent2_sex
label def parent2_sex -8 "inapplicable", modify
label def parent2_sex 1 "male", modify
label def parent2_sex 2 "female", modify
label values g_country g_country
label def g_country 1 "England", modify
label def g_country 3 "Scotland", modify
[/CODE]

Some of the variable's name
pidp - person idenitfier
hidp - hh identifier
pno - person number in household
nchunder16 g_nch5to15 g_nch10to15 g_nch10 - these are the age bands of children
hhsize - household size
job stat - job status
Tags: None

Clyde Schechter

Join Date: Apr 2014
Posts: 30164

09 Aug 2023, 15:53

This data is highly reminiscent of data you posted in recent threads. The key difference here is that in the children's data set there is no indication of the pno for the parent, so the links that worked in earlier threads will not work here. But the pidp variable links to the parent*_pid variables, which makes the task possible.

Code:

clear*
input long(pidp g_hidp) byte(g_pno g_sex) int g_age byte(g_nchunder16 g_nch5to15 g_nch10to15 g_nch10 g_jobstat) long parent1_pid byte(parent1_pno parent1_sex) long parent2_pid byte(parent2_pno parent2_sex g_hhsize g_nkids)
68008847 68040812 1 2 57 0 0 0 0 2 -8 0 -8 -8 0 -8 1 0
68061288 68047612 2 2 29 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68009527 68047612 1 1 38 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68010887 68054412 1 2 51 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68017687 68081612 1 2 36 2 2 1 0 2 -8 0 -8 -8 0 -8 3 2
68157166 68115612 2 1 30 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68029931 68122412 2 1 46 1 1 1 0 2 -8 0 -8 -8 0 -8 4 1
68176882 68136012 2 2 28 1 1 0 0 2 -8 0 -8 -8 0 -8 3 1
68032647 68136012 1 1 30 1 1 0 0 2 -8 0 -8 -8 0 -8 3 1
68142890 68142812 2 2 35 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68035367 68142812 1 1 34 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68037407 68156412 1 2 46 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68041487 68170012 1 2 45 2 2 2 0 2 -8 0 -8 -8 0 -8 4 2
68041491 68170012 2 1 42 2 2 2 0 2 -8 0 -8 -8 0 -8 4 2
68042171 68176812 2 2 44 1 1 0 0 2 -8 0 -8 -8 0 -8 3 1
68042167 68176812 1 1 45 1 1 0 0 2 -8 0 -8 -8 0 -8 3 1
68043527 68183612 1 1 61 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68044207 68190412 1 2 39 3 3 1 1 2 -8 0 -8 -8 0 -8 5 3
68045567 68204012 1 2 53 0 0 0 0 2 -8 0 -8 -8 0 -8 3 0
68045571 68204012 2 1 55 0 0 0 0 2 -8 0 -8 -8 0 -8 3 0
68046927 68217612 1 2 42 2 2 2 0 2 -8 0 -8 -8 0 -8 3 2
68049647 68238012 1 1 57 0 0 0 0 2 -8 0 -8 -8 0 -8 3 0
68049651 68238012 2 2 55 0 0 0 0 2 -8 0 -8 -8 0 -8 3 0
68051007 68251612 1 1 54 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68051011 68251612 2 2 47 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68056447 68265212 1 1 52 2 2 2 0 2 -8 0 -8 -8 0 -8 4 2
68060531 68292412 2 2 42 1 1 0 0 2 -8 0 -8 -8 0 -8 3 1
68060527 68292412 1 1 41 1 1 0 0 2 -8 0 -8 -8 0 -8 3 1
68063251 68306012 2 1 50 1 1 1 0 2 -8 0 -8 -8 0 -8 3 1
68063247 68306012 1 2 48 1 1 1 0 2 -8 0 -8 -8 0 -8 3 1
68063927 68312812 1 2 45 1 1 1 0 2 -8 0 -8 -8 0 -8 3 1
68063931 68312812 2 1 47 1 1 1 0 2 -8 0 -8 -8 0 -8 3 1
68065971 68326412 2 2 56 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68066647 68333212 1 2 28 2 2 0 0 2 -8 0 -8 -8 0 -8 4 2
68068007 68340012 1 1 48 0 0 0 0 2 -8 0 -8 -8 0 -8 4 0
68068011 68340012 2 2 48 0 0 0 0 2 -8 0 -8 -8 0 -8 4 0
68071407 68353612 1 1 26 0 0 0 0 2 -8 0 -8 -8 0 -8 1 0
68442808 68435212 3 2 51 0 0 0 0 2 -8 0 -8 -8 0 -8 4 0
68105407 68476012 1 2 48 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68111531 68489612 2 1 34 1 1 0 0 2 -8 0 -8 -8 0 -8 3 1
68111527 68489612 1 2 34 1 1 0 0 2 -8 0 -8 -8 0 -8 3 1
68112207 68496412 1 1 31 2 1 0 0 2 -8 0 -8 -8 0 -8 4 2
68116287 68503212 1 2 32 2 2 1 0 2 -8 0 -8 -8 0 -8 4 2
68120371 68523612 1 1 64 0 0 0 0 2 -8 0 -8 -8 0 -8 1 0
68121047 68530412 1 2 43 0 0 0 0 2 -8 0 -8 -8 0 -8 4 1
68121727 68537212 1 2 62 0 0 0 0 2 -8 0 -8 -8 0 -8 1 0
68122407 68544012 1 2 52 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68125127 68557612 1 2 49 0 0 0 0 2 -8 0 -8 -8 0 -8 3 0
68131927 68571212 1 1 60 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68131931 68571212 2 2 57 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68132607 68578012 1 1 45 0 0 0 0 2 -8 0 -8 -8 0 -8 3 0
68138051 68591612 2 2 61 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68141447 68605212 1 2 54 1 1 1 0 2 -8 0 -8 -8 0 -8 4 2
68144851 68625612 2 2 39 1 1 1 1 2 -8 0 -8 -8 0 -8 3 1
68144847 68625612 1 1 47 1 1 1 1 2 -8 0 -8 -8 0 -8 3 1
68150967 68639212 1 1 53 0 0 0 0 2 -8 0 -8 -8 0 -8 3 0
68150971 68639212 2 2 56 0 0 0 0 2 -8 0 -8 -8 0 -8 3 0
68155051 68659612 2 1 63 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68155047 68659612 1 2 58 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68155731 68680012 1 2 46 0 0 0 0 2 -8 0 -8 -8 0 -8 1 0
68157767 68693612 1 2 50 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68159131 68700412 2 2 35 1 1 1 1 2 -8 0 -8 -8 0 -8 3 1
68159127 68700412 1 1 41 1 1 1 1 2 -8 0 -8 -8 0 -8 3 1
68924886 68707212 2 2 32 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68163887 68707212 1 1 30 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68166607 68720812 1 2 60 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68167967 68727612 1 2 37 2 2 1 0 2 -8 0 -8 -8 0 -8 4 2
68167971 68727612 2 1 37 2 2 1 0 2 -8 0 -8 -8 0 -8 4 2
68173411 68734412 2 1 55 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68173407 68734412 1 2 58 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68180887 68782012 1 2 45 3 3 1 0 2 -8 0 -8 -8 0 -8 5 3
68180891 68782012 2 1 43 3 3 1 0 2 -8 0 -8 -8 0 -8 5 3
68184967 68802412 1 1 41 2 1 0 0 2 -8 0 -8 -8 0 -8 4 2
68185647 68809212 1 2 53 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68187691 68816012 2 2 56 0 0 0 0 2 -8 0 -8 -8 0 -8 3 0
68187687 68816012 1 1 60 0 0 0 0 2 -8 0 -8 -8 0 -8 3 0
68188367 68822812 1 2 46 0 0 0 0 2 -8 0 -8 -8 0 -8 3 0
68191771 68843212 1 2 43 2 2 1 0 2 -8 0 -8 -8 0 -8 3 2
68195851 68870412 2 2 41 0 0 0 0 2 -8 0 -8 -8 0 -8 3 0
68195847 68870412 1 1 46 0 0 0 0 2 -8 0 -8 -8 0 -8 3 0
68197207 68877212 1 1 45 2 2 2 0 2 -8 0 -8 -8 0 -8 5 2
68197211 68877212 2 2 41 2 2 2 0 2 -8 0 -8 -8 0 -8 5 2
68197887 68884012 1 2 54 0 0 0 0 2 -8 0 -8 -8 0 -8 3 0
68197891 68897612 1 1 25 0 0 0 0 2 -8 0 -8 -8 0 -8 1 0
68202647 68904412 1 2 40 1 0 0 0 1 -8 0 -8 -8 0 -8 3 1
69237684 68904412 2 1 39 1 0 0 0 2 -8 0 -8 -8 0 -8 3 1
68213531 68938412 2 1 45 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68213527 68938412 1 2 37 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68214207 68945212 1 1 56 0 0 0 0 2 -8 0 -8 -8 0 -8 1 0
68214891 68952012 2 2 42 2 1 0 0 2 -8 0 -8 -8 0 -8 4 2
68216247 68958812 1 2 41 2 1 0 0 2 -8 0 -8 -8 0 -8 4 2
68216251 68958812 2 1 40 2 1 0 0 2 -8 0 -8 -8 0 -8 4 2
68219647 68972412 1 2 45 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68223727 68992812 1 1 49 2 1 0 0 2 -8 0 -8 -8 0 -8 4 2
68226451 69013212 2 1 44 2 2 1 0 2 -8 0 -8 -8 0 -8 4 2
68227807 69020012 1 1 54 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
69020090 69020012 2 2 53 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
68230527 69040412 1 2 48 1 1 1 0 2 -8 0 -8 -8 0 -8 4 1
68238011 69067612 2 2 58 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
69326086 69074412 2 2 56 0 0 0 0 2 -8 0 -8 -8 0 -8 2 0
end
label values g_pno g_pno
label values g_sex g_sex
label def g_sex 1 "male", modify
label def g_sex 2 "female", modify
label values g_age g_age
label values g_nchunder16 g_nchunder16
label values g_nch5to15 g_nch5to15
label values g_nch10to15 g_nch10to15
label values g_nch10 g_nch10
label values g_jobstat g_jobstat
label def g_jbstat 1 "Self employed", modify
label def g_jbstat 2 "Paid employment(ft/pt)", modify
label values parent1_pid g_pns1pid
label def g_pns1pid -8 "inapplicable", modify
label values parent1_pno g_pns1pno
label def g_pns1pno 0 "not in hh", modify
label values parent1_sex g_pns1sex
label def g_pns1sex -8 "inapplicable", modify
label values parent2_pid g_pns2pid
label def g_pns2pid -8 "inapplicable", modify
label values parent2_pno g_pns2pno
label def g_pns2pno 0 "not in hh", modify
label values parent2_sex g_pns2sex
label def g_pns2sex -8 "inapplicable", modify
label values g_hhsize g_hhsize
label values g_nkids g_nkids
label def g_nkids_dv 0 "none", modify

frame create children
frame change children
input long(pidp g_hidp) byte(g_pno g_sex g_age g_health) long parent1_pid byte(parent1_pno parent1_sex) long parent2_pid byte(parent2_pno parent2_sex g_country)
68029939 68122412 4 1 11 2 68029927 1 2 68029931 2 1 1
68041495 68170012 3 1 14 1 68041487 1 2 68041491 2 1 1
68041499 68170012 4 2 12 2 68041487 1 2 68041491 2 1 1
68044215 68190412 3 1 10 1 68044207 1 2 68044211 2 1 1
68046935 68217612 2 2 15 2 68046927 1 2 -8 0 -8 1
68046939 68217612 3 1 11 5 68046927 1 2 -8 0 -8 1
68056459 68265212 4 2 15 1 68056447 1 1 68056451 2 2 1
68056463 68265212 5 2 11 1 68056447 1 1 68056451 2 2 1
68063255 68306012 3 1 15 1 68063247 1 2 68063251 2 1 1
68063935 68312812 3 1 11 2 68063927 1 2 68063931 2 1 1
68086375 68394412 2 2 11 3 68086371 1 2 68414968 3 1 1
68116295 68503212 3 1 13 4 68116287 1 2 68116291 2 1 1
68121059 68530412 4 2 15 3 68121047 1 2 68121051 2 1 1
68142139 68618812 4 1 15 7 68142127 1 2 68142131 2 1 1
68142143 68618812 5 1 11 3 68142127 1 2 68142131 2 1 1
68144855 68625612 3 2 10 2 68144847 1 1 68144851 2 2 1
68159135 68700412 3 2 10 1 68159127 1 1 68159131 2 2 1
68180895 68782012 3 2 15 2 68180887 1 2 68180891 2 1 1
68191775 68843212 2 1 12 3 68191771 1 2 -8 0 -8 1
68197219 68877212 4 2 14 1 68197207 1 1 68197211 2 2 1
68197223 68877212 5 1 13 1 68197207 1 1 68197211 2 2 1
68224415 69006412 4 2 11 3 68224407 1 1 -8 0 -8 1
68226455 69013212 3 2 12 3 68226447 1 2 68226451 2 1 1
68228503 69026812 5 1 11 2 68228487 1 1 68228491 2 2 1
68230539 69040412 4 1 11 3 68230527 1 2 -8 0 -8 1
68231227 69047212 4 2 15 1 68231207 1 2 68231211 2 1 1
68244819 69101612 2 1 11 3 68244807 1 2 -8 0 -8 3
68247539 69108412 4 1 10 3 68247527 1 2 68247531 2 1 1
68265219 69156012 4 2 10 5 68265207 1 2 68265211 2 1 1
68295139 69292012 4 2 10 3 68295127 1 1 68295131 2 2 1
68344771 69564012 2 2 10 2 68344767 1 2 -8 0 -8 1
68351575 69591212 3 2 11 3 68351567 1 2 68351571 2 1 1
68367899 69652412 4 1 13 5 68367887 1 1 68367891 2 2 1
68378115 69686412 8 2 15 2 68378095 3 1 68378099 4 2 1
68412095 69788412 3 2 15 2 68412087 1 2 68412091 2 1 1
68427055 69829212 2 1 10 4 68427047 1 2 -8 0 -8 1
68431135 69842812 3 1 10 3 68431127 1 2 -8 0 -8 1
68531095 70176012 2 1 12 4 68531087 1 2 -8 0 -8 1
68548095 70237212 3 1 14 1 68548087 1 2 68548091 2 1 1
68548099 70237212 4 2 14 3 68548087 1 2 68548091 2 1 1
68561015 70271212 3 1 13 2 68561007 1 2 68561011 2 1 1
68580735 70373212 3 2 11 2 68580727 1 1 68580731 2 2 1
68615419 70529612 4 1 15 2 68615407 1 1 68615411 2 2 1
68624255 70577212 3 1 13 3 68624247 1 1 68624251 2 2 1
68624259 70577212 4 1 10 3 68624247 1 1 68624251 2 2 1
68680015 70828812 3 1 13 2 68680007 1 2 68680011 2 1 1
68704491 70910412 2 1 15 3 68704487 1 2 -8 0 -8 1
68707215 70930812 3 1 14 4 68707207 1 1 68707211 2 2 1
68707219 70930812 4 2 11 4 68707207 1 1 68707211 2 2 1
68740539 71032812 4 2 14 6 68740527 1 1 68740531 2 2 1
68794259 71277612 4 1 14 2 68794247 1 2 68794251 2 1 1
68813979 71338812 4 1 14 1 68813967 1 2 68813971 2 1 1
68813983 71338812 5 1 12 2 68813967 1 2 68813971 2 1 1
68813987 71338812 6 2 11 1 68813967 1 2 68813971 2 1 1
68841175 71400012 2 2 13 2 68841167 1 2 -8 0 -8 1
68867695 71434012 3 1 14 1 68867687 1 2 -8 0 -8 1
68895575 71481612 3 2 10 2 68895571 2 2 -8 0 -8 1
68901695 71488412 3 2 11 2 68901687 1 2 68901691 2 1 1
68903735 71495212 3 2 15 4 68903727 1 2 68903731 2 1 1
68903739 71495212 4 2 10 4 68903727 1 2 68903731 2 1 1
68963575 71712812 3 1 10 1 68963567 1 2 68963571 2 1 1
68964259 71719612 4 1 14 1 68964247 1 1 68964251 2 2 1
68964263 71719612 5 1 14 1 68964247 1 1 68964251 2 2 1
68993503 71821612 5 1 14 3 68993487 1 2 68993491 2 1 1
68993507 71821612 6 2 13 5 68993487 1 2 68993491 2 1 1
69029535 71910012 3 1 12 2 69029527 1 2 -8 0 -8 1
69051291 71984812 2 1 14 2 69051287 1 1 -8 0 -8 1
69053335 71991612 3 2 11 2 69053327 1 1 69053331 2 2 1
69070343 72080012 3 1 11 5 69070331 1 1 69070351 5 2 1
69074419 72134412 4 2 14 2 69074407 1 1 69074411 2 2 1
69075095 72141212 3 2 11 1 69075087 1 1 69075091 2 2 1
69078495 72154812 3 1 15 1 69078487 1 2 69078491 2 1 1
69078499 72154812 4 2 12 2 69078487 1 2 69078491 2 1 1
69083255 72195612 3 2 12 2 69083247 1 1 69083251 2 2 1
69105015 72256812 3 2 14 2 69105007 1 1 69105011 2 2 1
69105019 72256812 4 1 11 5 69105007 1 1 69105011 2 2 1
69111135 72270412 3 2 13 2 69111127 1 1 69111131 2 2 1
69132223 72358812 3 1 15 3 69132207 1 1 69132211 2 2 1
69134935 72372412 3 1 15 3 69134927 1 1 69134931 2 2 1
69134939 72372412 4 2 13 2 69134927 1 1 69134931 2 2 1
69135619 72379212 3 2 15 2 69135607 1 2 69135611 2 1 1
69135623 72379212 4 2 13 2 69135607 1 2 69135611 2 1 1
69146495 72447212 3 1 15 3 69146487 1 2 69146491 2 1 1
69183897 74378412 4 1 12 1 69183885 1 2 69183889 2 1 1
69262775 72862012 3 1 13 2 69262767 1 2 69262771 2 1 3
69298135 72970812 3 2 10 2 69298127 1 2 69298131 2 1 3
69302215 72977612 3 1 13 3 69302207 1 2 69302211 2 1 3
69305621 74398812 4 1 12 2 69305605 1 2 69305609 2 1 1
69307655 73018412 2 1 12 -9 69307647 1 2 73576888 5 1 3
69307659 73018412 3 2 10 3 69307647 1 2 73576888 5 1 3
69325335 73072812 3 2 12 1 69325327 1 1 69325331 2 2 3
69325339 73072812 4 1 11 2 69325327 1 1 69325331 2 2 3
69389255 73127212 2 2 10 2 69389247 1 2 73698648 4 1 1
69431415 73202012 3 2 12 2 69431407 1 1 69431411 2 2 1
69431419 73202012 4 2 11 2 69431407 1 1 69431411 2 2 1
69440951 73208812 6 1 14 2 69440927 1 2 -8 0 -8 1
69451135 73222412 3 1 10 4 69451127 1 1 69451131 2 2 1
69544293 74521212 3 1 15 2 69544285 1 1 69544289 2 2 1
69544297 74521212 4 2 14 2 69544285 1 1 69544289 2 2 1
69603453 74555212 3 1 13 4 69603445 1 1 69603449 2 2 1
end
label values g_pno g_pno
label values g_sex g_sex
label def g_sex 1 "male", modify
label def g_sex 2 "female", modify
label values g_age g_age
label values g_health g_health
label def g_health -9 "missing", modify
label def g_health 1 "1", modify
label def g_health 2 "2", modify
label def g_health 3 "3", modify
label def g_health 4 "4", modify
label def g_health 5 "5", modify
label def g_health 6 "6", modify
label def g_health 7 "7", modify
label values parent1_pid parent1_pid
label values parent1_pno parent1_pno
label values parent1_sex parent1_sex
label def parent1_sex 1 "male", modify
label def parent1_sex 2 "female", modify
label values parent2_pid parent2_pid
label def parent2_pid -8 "inapplicable", modify
label values parent2_pno parent2_pno
label def parent2_pno 0 "not in hh", modify
label values parent2_sex parent2_sex
label def parent2_sex -8 "inapplicable", modify
label def parent2_sex 1 "male", modify
label def parent2_sex 2 "female", modify
label values g_country g_country
label def g_country 1 "England", modify
label def g_country 3 "Scotland", modify

frlink m:1 g_hidp parent1_pid, frame(default g_hidp pidp)
frget g_pno g_sex g_age g_nch* g_hhsize g_nkids, from(default) prefix(p1_)
drop default
frlink m:1 g_hidp parent2_pid, frame(default g_hidp pidp)
frget g_pno g_sex g_age g_nch* g_hhsize g_nkids, from(default) prefix(p2_)
drop default

Notes:
1. In the example data, very few of the children find matches to parents in the individual data set. In fact, most of the households in the children data set example are not found at all in the individuals data set. Presumably in the full data sets this problem will not arise.
2. Of course, you would not input the data from -dataex- in your real situation, and all of the -dataex- stuff in the proposed code will just be replaced by commands to -use- the corresponding data sets.
3. In the resultilng data set, all of the variables brought in from the individuals data set that refer to parent1 are now prefixed with p1_. Analogously for parent2, with prefix p2_.

Announcement

Merging individual and child dataset

Comment