The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » General » Merged Housedhold and Domestic Violence dataset
Merged Housedhold and Domestic Violence dataset [message #22378] Thu, 04 March 2021 12:39 Go to next message
Aye Thiri Kyaw is currently offline  Aye Thiri Kyaw
Messages: 1
Registered: March 2021
Member
Hi
This is Aye Thiri
My colleague and I: We have a merged dataset for Household and women individual data.

Question 1
Our question "Is there any way we can tell that those who answered the Household questionnaires is women or men"?

Question 2: Is there a way we can tell the age of the child for the women/men who answered the child discipline questions?

Kindest Regards
Re: Merged Housedhold and Domestic Violence dataset [message #22398 is a reply to message #22378] Fri, 05 March 2021 19:23 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 2355
Registered: February 2013
Senior Member
Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

First question: The line number of the household respondent is given by hv003 for everyone in the household. The sex of that person is given by hv104. If you want to attach that to everyone in the household, you can use these lines in Stata, with the PR file:

gen temp=hv104 if hvidx==hv003
list hv001 hv002 hv003 hvidx hv104 temp if _n<=100, table clean
egen hhresp_hv104=min(temp), by(hv001 hv002)
drop temp
list hv001 hv002 hv003 hvidx hv104 hhresp* if _n<=100, table clean
The "list" lines will show you how the gen and egen lines work. You can extend this to copy other characteristics of the household respondent onto every every person in the household.

Second question: The relevant line number for the child who was selected for the child discipline module in the Myanmar survey was sh148. As I said the other day, sh148-sh161 were copied onto the record for every person in the household. You can restrict to the reference children just with "keep if hvidx==sh148" and then you have the age of the child as hv105. Alternatively, if you just want to make those children more identifiable but keep everyone in the PR file, you could do the following to make the sh variables ".", for NA, in the PR file:

local cdvars sh148 sh149 sh150 sh151 sh152 sh153 sh154 sh155 sh156 sh157 sh158 sh159 sh160 sh161
list hv001 hv002 hvidx hv105 sh148-sh152 if _n<=100, table clean
foreach cdvar of local cdvars {
replace `cdvar'=. if hvidx~=sh148
} 
list hv001 hv002 hvidx hv105 sh148-sh152 if _n<=100, table clean
Again, the "list" lines are just for checking.

Re: Merged Housedhold and Domestic Violence dataset [message #22451 is a reply to message #22398] Mon, 15 March 2021 14:16 Go to previous messageGo to next message
smiedema is currently offline  smiedema
Messages: 3
Registered: March 2021
Member
Thank you Tom and Bridgette. This is very useful.

Unfortunately, the provided code does not work because there are multiple possible variables for hvidx, hv104 etc. When I tried to add the _*, the code does not run and I continue to receive "ambiguous abbreviation" error messages from Stata.

In addition, to add to my colleagues previous note, we are not only trying to determine whether the individual who answered the household survey was a woman, but also whether she was the woman who was selected for the domestic violence module. Do you have any insight into either of these issues?


Thank you very much for your assistance.

Best,
Stephanie
Re: Merged Housedhold and Domestic Violence dataset [message #22452 is a reply to message #22451] Mon, 15 March 2021 15:40 Go to previous messageGo to next message
smiedema is currently offline  smiedema
Messages: 3
Registered: March 2021
Member
Hi Tom and Bridgette,
First - please ignore the question about code below. I used the PR file, and it worked. The second question still remains. We would like to know whether it is possible to restrict the sample to women who answered both the household survey (e.g. reported their own use of harsh child discipline against the selected child) and the domestic violence module questions. I do not see line items for the domestic violence module, so am not sure this is possible?

Thanks,
Stephanie


Re: Merged Housedhold and Domestic Violence dataset [message #22460 is a reply to message #22452] Tue, 16 March 2021 15:09 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 2355
Registered: February 2013
Senior Member

Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

The line number of the respondent, v003, matches her line number in the household survey, hvidx. The line number of the household respondent (in the PR file) is hv003. In the merged PR/IR file, if v003=hv003, then the woman was the household respondent. Hope this will answer the question.
Re: Merged Housedhold and Domestic Violence dataset [message #22472 is a reply to message #22460] Wed, 17 March 2021 13:41 Go to previous message
smiedema is currently offline  smiedema
Messages: 3
Registered: March 2021
Member
Thank you very much for this response and clarification. It is much appreciated. Best, Stephanie
Previous Topic: Comoros 2012 KMIR61FL
Next Topic: Total number households reported vs v002
Goto Forum:
  


Current Time: Mon Aug 2 02:19:28 Coordinated Universal Time 2021