The DHS Program User Forum: General » Variable v034: merging datasets

Home » Topics » General » Variable v034: merging datasets ("Husband not in the household" (00))

Show: Today's Messages :: Show Polls :: Message Navigator

Variable v034: merging datasets [message #24738]

Sun, 03 July 2022 11:40

salome
Messages: 19
Registered: August 2021

Member

Good afternoon,

I am trying to understand the number of women's partners who were not in the household at the time of the women's interview as a proportion of women who declare to be cohabiting/married. v034 has an option of 0: husband not in the household). If a man is not in the household, does this mean that he did not participate in the male DHS survey? Essentially, would I be able to look at any data from men who "are not in the household"? (v034 = 0). I assume not, but I wanted to check.

Thank you in advance.

Report message to a moderator

Re: Variable v034: merging datasets [message #24768 is a reply to message #24738]

Thu, 07 July 2022 10:06

Janet-DHS
Messages: 911
Registered: April 2022

Senior Member

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

If the husband/partner is not in the household at the time of the survey, but is listed on the household roster (that is, he is a de jure member but not de facto), then he will not appear in the men's survey but some information about him will be provided by the household respondent. You could look at combinations of hv102 and hv103 in the PR file. Some women do list as their partner a man such as this.

Also, the women's survey includes some questions about the partner whether or not he is in the household. You can quickly identify such questions in the women's questionnaire that is in an appendix of the final report. The responses go into the IR file. You can then determine whether that man is in the household. Hope this helps.

Report message to a moderator

Re: Variable v034: merging datasets [message #24772 is a reply to message #24768]

Thu, 07 July 2022 13:03

salome
Messages: 19
Registered: August 2021

Member

Good afternoon

Thank you so much for your response - this helps. I have a few follow-up questions:
* Does v034=0 mean that the man was not in the household at the time of the survey (but is in the roster) OR that the man is not in the household roster at all?
* You mention that some information about men who are de jure members of the household (not defacto) will be provided by the household respondent. Are you referring to the questions on their sex, age, marital status, educational attainment? (listed prior to child labor/discipline questions?)

Thank you again in advance!

Report message to a moderator

Re: Variable v034: merging datasets [message #24784 is a reply to message #24772]

Mon, 11 July 2022 10:11

Janet-DHS
Messages: 911
Registered: April 2022

Senior Member

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

To answer a question such as your first one, go to the IR file and enter this line:

. describe v034

You will get the following:

/index.php?t=getfile&id=1875&private=0

What's important here is that there is a value label, and it is V034. Then enter this line:

. label list V034

You will get the following:

V034:
0 husband not in household

Variable labels are usually the same as the variable name, either all caps (as in V034) or lower case (as in v034). That answers your first question.

The answer to the second question is "yes". Unless otherwise specified in the questionnaire, the same kinds of information are obtained about all adults on the household roster, whether they are de jure or de facto residents. The information comes from the "household respondent", the household member whose line number is given by hv003 in the PR file.

Attachment: Response 24738.PNG
(Size: 5.69KB, Downloaded 380 times)

Report message to a moderator

Re: Variable v034: merging datasets [message #24789 is a reply to message #24784]

Mon, 11 July 2022 10:18

salome
Messages: 19
Registered: August 2021

Member

Thank you so much for clarifying. This helps a lot!

Report message to a moderator

Re: Variable v034: merging datasets [message #24887 is a reply to message #24789]

Thu, 28 July 2022 00:19

salome
Messages: 19
Registered: August 2021

Member

Hello

Sorry to bother you again, but I was wondering in DHS how are couples datasets created - by merging men's dataset to women's or the other way around? I found on the website that "DHS, men's questionnaires are only applied to a sub-sample of households. This means that not all currently married women have a match with a men's questionnaire. In this case, the base file should be the men's questionnaire and the resulting file (unit of analysis) will be the Couples file", however I also noticed that there is a variable on whether a household was selected for male survey in the household dataset so I was wondering...

[Updated on: Thu, 28 July 2022 09:28]

Report message to a moderator

Re: Variable v034: merging datasets [message #24911 is a reply to message #24887]

Mon, 01 August 2022 12:33

Janet-DHS
Messages: 911
Registered: April 2022

Senior Member

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

I believe you want to identify men in the PR file who are de jure (hv102=1) but absent (hv103=0) and whose line number is given in the IR file by v034. I will illustrate with the Nigeria 2018 survey (NG7B). It shows that out of 25,662 husbands identified in the PR file, there were 687 who were de jure but not de facto. Hope this is what you were looking for.

cd e:\DHS\DHS_data\scratch

use "...NGIR7BFL.DTA", clear
keep v001 v002 v003 v034
rename v001 cluster
rename v002 hh
rename v003 wline
rename v034 hline
sort cluster hh hline

save NGIRtemp.dta, replace

* w for wife, h for husband

use "...NGPR7BFL.DTA", clear
* keep males age 15+
keep if hv104==1 & hv105>=15

keep hv001 hv002 hvidx hv102 hv103
rename hv001 cluster
rename hv002 hh
rename hvidx hline
sort cluster hh hline
tab hv102 hv103

merge cluster hh hline using NGIRtemp.dta
tab _merge

tab hv102 hv103 if _merge==3

. tab hv102 hv103 if _merge==3

usual | slept last night
resident | no yes | Total
-----------+----------------------+----------
no | 0 31 | 31
yes | 687 24,944 | 25,631
-----------+----------------------+----------
Total | 687 24,975 | 25,662

Report message to a moderator

Re: Variable v034: merging datasets [message #24928 is a reply to message #24911]

Thu, 04 August 2022 00:17

salome
Messages: 19
Registered: August 2021

Member

Thank you so much!!This is incredibly helpful.

S

Report message to a moderator

Previous Topic:	Multilevel modeling
Next Topic:	Women decision making power

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Dec 30 09:29:39 Coordinated Universal Time 2024