The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Dataset use in Stata » Reshaping Data (Reshaping PR and IR data)
Re: Reshaping Data [message #30384 is a reply to message #30382] Tue, 19 November 2024 08:09 Go to previous messageGo to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3230
Registered: February 2013
Senior Member

Following is a response from Senior DHS staff member, Tom Pullum:

The variable hv101 in the PR file gives the relationship of each person in the household head to the household head. It does not give the relationship of individuals to one another. It is confusing to me, at least, when you use the terms mother-in-law and daughter-in-law, because these are relationships to the household head. If H is the head of the household, usually a male, then his mother-in-law is his wife's mother and his daughter-in-law is his son's wife. I don't think these are the people you are talking about.

I think you are talking about three possible configurations. One type is male-headed households, and the two people are the wife of the head and the mother of the head. Then (a) the head of the household is male, (b) the spouse is present (and female), and (c) a female parent of the head is present. You want to put the education of person (c) onto the record of person (b).

In the second configuration, (a) the head is male, (b) the spouse is present (and female), and (c) the daughter-in-law of the head is present. You would have to assume that the daughter-in-law of the head is also the daughter-in-law of the head's spouse. Again, you would put the education of person (c) onto the record of person (b).

The third configuration is like the second, but (a) the head is female and (b) her daughter-in-law is present, This time you put the education of person (a) onto the record of person (c).

Some households will not have any such pairs. It is possible for a household to have multiple pairs, e.g. a woman-headed household that includes two adult married sons and their wives.

Does this sound correct? If so, let us know and I will show how to do that. If not, please clarify your question.
 
Read Message
Read Message
Read Message
Read Message
Previous Topic: Issues with Pooled Multi-Country DHS Data
Next Topic: multidimensional poverty index
Goto Forum:
  


Current Time: Fri Jan 31 17:45:06 Coordinated Universal Time 2025