Hi Xavier---Glad it worked. Variables such as prop_age1 are household-level variables that after the merge are coded on to the records for each person in the household. It could be good to have them there for some kinds of analyses. For example, you might have a hypothesis that children who live in a household with a high child dependency ratio are less likely to be in school. This would be a kind of contextual effects model.

If you really want just one record per household, the easiest way to do that after the merge would be with the line "keep if hvidx==1" or "keep if hv101==1". The latter will just keep the line for the household head (who is usually, but not always, the person with hvidx=1). Hope that will give what you want. Otherwise, to get the mean value of prop_age1 from the merged file you could do something such as "summarize prop_age1 if hvidx==1" to get just one value per household.

Note that the summarize commands should include weighting by hv005, or you should use svyset and svy. I did not need to use weights when constructing prop_age1, etc., because everyone in the same household has the same weight. Good luck.