I have 2 files one containing information at household level and another
one at individual level. I would like to have each individual to in a
household have a value of an index which is at household level. When merged
two files on perm_id, here is what I get. Some individual are missing the
value of the index. When I do it on family_id, it gives me un-anticipated
results. What is the trick here?