Hello all,
i am currently doing my thesis using the data from IFLS.
i want to estimate the effect of preferences on education spending from a household

i only want to observe the Head of HH with children age 7-23

but how to assign the info on head of HH, if the data is mixed by head of HH and its children


Code:
* Example generated by -dataex-. For more info, type help dataex
clear
input str10 hhid14_9 double(pid14 ar02b)
"001060000"  1  1
"001060000"  7  2
"001060000"  8  3
"001060000"  8  3
"001060000"  8  3
"001060000"  8  3
"001060000"  8  3
"001060000"  8  3
"001060000"  8  3
"001060000"  8  3
"001060000"  9  3
"001060000" 10  3
"001060000" 11  3
"001060004"  1  2
"001060004"  2  1
"001060004"  2  1
"001060004"  2  1
"001060004"  2  1
"001060004"  2  1
"001060004"  2  1
"001060004"  2  1
"001060004"  2  1
"001060004"  2  1
"001060004"  2  1
"001060004"  3  3
"001060004"  4  3
"001080000"  8  1
"001080003"  1  1
"001080003"  2  2
"001080003"  3  3
"001080003"  4  3
"001080003"  5  3
"001080003"  6  3
"001080003"  6  3
"001080003"  6  3
"001080003"  6  3
"001080003"  6  3
"001080003"  6  3
"001080003"  6  3
"001080003"  7  3
"001220000"  1  1
"001220000"  1  1
"001220000"  1  1
"001220000"  1  1
"001220000"  1  1
"001220000"  1  1
"001220000"  1  1
"001220000"  1  1
"001220000"  1  1
"001220000"  2  2
"001220000"  6  3
"001220000" 14  3
"001220000" 15  3
"001220009"  1  1
"001224100"  1  1
"001224100"  2  2
"001224100"  3  3
"001224100"  4  3
"001224100"  5  3
"001224100"  5  3
"001224100"  5  3
"001224100"  5  3
"001224100"  5  3
"001224100"  5  3
"001224100"  5  3
"001224100"  5  3
"001224100"  6  3
"001224200"  1  1
"001240000"  2  1
"001240000"  3  3
"001240000"  4  3
"001240000"  7  3
"001240000" 12 10
"001240000" 14  3
"001240000" 16 10
"001240000" 17 10
"001240000" 18 10
"001240000" 19 10
"001240000" 20 10
"001240000" 21 10
"001240000" 22 10
"001240000" 23 10
"001240000" 24 17
"001240000" 25  5
"001240005"  1  1
"001240005"  2  2
"001240005"  2  2
"001240005"  2  2
"001240005"  2  2
"001240005"  2  2
"001240005"  2  2
"001240005"  2  2
"001240005"  2  2
"001240005"  2  2
"001240005"  2  2
"001240005"  2  2
"001240005"  2  2
"001240005"  2  2
"001240005"  2  2
"001240005"  2  2
end
label values ar02b ar02b
label def ar02b 1 "1:Head of the household", modify
label def ar02b 2 "2:Husband/wife", modify
label def ar02b 3 "3:Children (biological", modify
label def ar02b 5 "5:Sons/daughters-in-law", modify
label def ar02b 10 "10:Grandchild", modify
label def ar02b 17 "17:Non-relative", modify

many thanks