Hi, I am using an individual survey and I am examining the impact of international remittances on child schooling. The survey interviews all members of the household. I first kept only observations 6 to 17 years old since this is my sample. The observations include variables called fedu (which is the education of the observation's father) and medu (the mother's education). However, I found a lot of missing values in these 2 variables. One way to get those missing values is to check the education variable (called educlvl2) in the observations of the father and mother themselves. However, I am facing two problems here: first I have a problem relating the variables "fedu and medu" in the child's observation with the education variable "educlvl2" in the father's or mother's observation. Second, when i only keep observations 6 to 17 years old, I lose the observations of the parents, any idea what to do in this case?

here is a brief explanation of the variables in my dataex:
hhid is the household ID
pn is the individual's number in the household (usually the father is number 1, mother is number 2. Households with no children are of no interest to me)
educlvl2 is the observation's educational level
fedu and medu are father's and mother's education, respectively

here is an example of my data:
Code:
*

input str21 hhid byte(pn age educlvl2 fedu medu)
"18120100011"       1 55 7 2 1
"18120100021"       1 69 1 3 1
"18120100021_1802"  1 30 6 4 1
"18120100021_1802"  2 21 6 4 1
"18120100021_1802"  3  2 . . .
"18120100021_1803"  1 32 1 4 1
"18120100021_1803"  2 28 4 1 1
"18120100021_1803"  3  5 . . .
"18120100021_1803"  4  2 . . .
"18120100031"       1 48 2 1 1
"18120100031"       2 44 6 1 1
"18120100031"       3 23 6 . .
"18120100031"       4 20 6 . .
"18120100041"       1 52 6 1 1
"18120100041"       2 45 3 3 1
"18120100041"       3 24 5 . .
"18120100041"       4 20 5 . .
"18120100041"       5 17 3 . .
"18120100041_1803"  1 26 8 5 1
"18120100041_1803"  2  2 . . .
"18120100051"       1 39 6 3 1
"18120100051"       2 35 6 2 1
"18120100051"       3 13 3 . .
"18120100051"       4 11 2 . .
"18120100051"       5  6 1 . .
"18120100061"       1 40 3 1 1
"18120100061"       2 34 3 1 1
"18120100061"       3 16 3 . .
"18120100061"       4 15 2 . .
"18120100061"       5 13 2 . .
"18120100061"       6 12 1 . .
"18120100061"       7 10 1 . .
"18120100061"       8  8 1 . .
"18120100061"       9  7 1 . .
"18120100061"      10  4 . . .
"18120100061"      11  0 . . .
"18120100081"       1 58 1 1 1
"18120100081"       2 49 4 5 1
"18120100081"       3 23 8 4 .
"18120100081"       4 14 3 . .
"18120100091"       1 62 1 1 1
"18120100091"       2 54 1 1 1
"18120100091_1803"  1 22 6 1 1
"18120100091_1803"  2 22 4 5 1
"18120100091_1803"  3  3 . . .
"18120100101"       1 38 6 2 1
"18120100101"       2 35 4 2 1
"18120100101"       3 13 3 . .
"18120100101"       4 11 2 . .
"18120100101"       5  9 2 . .
"18120100101"       6  7 1 . .
"18120100111"       1 48 6 1 1
"18120100111"       2 47 1 1 1
"18120100111"       3 20 6 . .
"18120100111"       4 17 4 . .
"18120100111"       5 13 3 . .
"18120100121"       1 38 4 5 1
"18120100121"       2 30 6 2 1
"18120100121"       3  8 2 . .
"18120100121"       4  5 . . .
"18120100131"       1 37 8 5 .
"18120100131"       2 31 8 6 6
"18120100131"       3  8 1 . .
"18120100131"       4  5 . . .
"18120100131"       5  3 . . .
"18120100131"       6 82 1 1 1
"18120100141"       1 44 6 1 1
"18120100141"       2 41 6 3 1
"18120100141"       3 14 2 . .
"18120100141"       4 14 2 . .
"18120100141"       5  0 . . .
"18120100151"       1 72 1 1 1
"18120100151"       2 42 6 . 1
"18120100151"       3 40 6 1 1
"18120100151"       4 15 3 . .
"18120100171"       1 56 4 1 1
"18120100171"       2 55 6 1 1
"18120100171"       3 15 3 . .
"18120100171_1803"  1 28 4 1 2
"18120100171_1803"  2 24 6 4 5
"18120100171_1803"  3  1 . . .
"18120100171_1805"  1 30 6 1 1
"18120100171_1805"  2 29 6 4 5
"18120100171_1805"  3  1 . . .
"18120100171_1805"  4  7 2 5 .
"18120100181"       1 85 3 1 1
"18120100181"       2 54 4 . 1
"18120100191"       1 74 7 1 1
"18120100191"       2 68 4 1 1
"18120100191"       3 37 6 . .
"18120100191"       4 29 4 1 1
"18120100191"       5 11 1 . .
"18120100191"       6  9 1 . .
"18120100191"       7  4 . . .
"18120100241"       1 40 6 1 1
"18120100241"       2 39 6 2 2
"18120100241"       3 15 4 . .
"18120100241"       4 13 3 . .
"18120100241"       5  9 2 . .
"18120100241"       6  2 . . .
end
label values educlvl2 educlvl2
label def educlvl2 1 "Illiterate", modify
label def educlvl2 2 "Reads & Writes", modify
label def educlvl2 3 "Primary", modify
label def educlvl2 4 "Preparatory", modify
label def educlvl2 5 "General secondary", modify
label def educlvl2 6 "Vocational secondary", modify
label def educlvl2 7 "Post-secondary institute", modify
label def educlvl2 8 "University", modify
label values fedu education2_2
label values medu education2_2
label def education2_2 1 " Illiterate", modify
label def education2_2 2 " Read and Write", modify
label def education2_2 3 " Primary", modify
label def education2_2 4 " Preparatory", modify
label def education2_2 5 " General secondary/Technical secondary", modify
label def education2_2 6 " Middle institute", modify