The DHS Program User Forum
Discussions regarding The DHS Program data and results
Today's Messages (on)  | Unanswered Messages (off)

Forum: Mortality
 Topic: neonatal mortality
Re: neonatal mortality [message #28917 is a reply to message #28913] Thu, 28 March 2024 06:50
danielmoyo2001@gmail.com is currently offline  danielmoyo2001@gmail.com
Messages: 5
Registered: March 2024
Member
i would really appreciate your quick response
Re: neonatal mortality [message #28918 is a reply to message #28917] Thu, 28 March 2024 10:55
Janet-DHS is currently offline  Janet-DHS
Messages: 666
Registered: April 2022
Senior Member
Following is a response from DHS staff member, Tom Pullum:

You might look at this Further Analysis Report: Trends in Neonatal Mortality in Rwanda, 2000-2010 [FA88]https://dhsprogram.com/pubs/pdf/FA88/FA88.pdf. I would recommend logistic regression, as used in this report, although not necessarily the decomposition, which is a lot more work and harder to interpret.
Forum: Wealth Index
 Topic: Antenatal care
Antenatal care [message #28919] Thu, 28 March 2024 11:23
Abid Monga is currently offline  Abid Monga
Messages: 2
Registered: February 2024
Member
Hi,
I am working on determinants of antenatal care for the state of Jammu and Kashmir (India). I am using the 'Individual Recode' file. With regard to Wealth wealth index, I find various versions wealth index in the data, for instance, All women factor - Wealth Index, Wealth Index combined, Wealth Index factor scores combined (5 decimals) etc. I am not sure which one I should use, keeping in mind that my analysis is restricted to the women who have had a live birth in five years preceding the survey.
Please help.
Forum: Weighting data
 Topic: SSU variables in the Mauritania DHS2019-2021
Re: SSU variables in the Mauritania DHS2019-2021 [message #28920 is a reply to message #28914] Thu, 28 March 2024 13:07
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3017
Registered: February 2013
Senior Member

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

The table with 1, 623.14 births after August 2019 was constructed with this command: "tab v024 birthdate [iweight=v005/1000000]". The table with just 13.697 births after August 2019 was constructed with "tab v024 birthdate if bidx==1 & v213==1 [iweight=v005/1000000]". Both frequencies were weighted, but the second and much smaller frequency was limited to the most recent birth (bidx=1) and to women who are pregnant at the time of the survey (v213=1). They are a very small subset of the births in the first table. These tables were what I understood you to be requesting.

You say that you are trying to measure the potential impact of an intervention related to ANC care. I don't see how either of these tables could be used to describe such an impact. This is an interesting question, but this survey may not be appropriate for answering it. I would like to help but the question is outside the scope of the user forum. I hope other users can help.

Here is a journal article that may help, but it uses two successive surveys:

Mallick, Lindsay, Trinadh Dontamsetti, Thomas Pullum, and Julia Fleuret. 2019. Using the Uganda Demographic and Health Surveys from 2011 and 2016 to assess changes in Saving Mothers, Giving Life intervention districts. J. of Global Health Research 3. doi:10.29392/joghr.3.e2019026.

Forum: Domestic Violence
 Topic: MERGING DV CHARACTERISITCS TO CHILD OUTCOME
Re: MERGING DV CHARACTERISITCS TO CHILD OUTCOME [message #28924 is a reply to message #28902] Thu, 28 March 2024 15:20
Janet-DHS is currently offline  Janet-DHS
Messages: 666
Registered: April 2022
Senior Member
Following is a response from DHS staff member, Tom Pullum:

What do you mean by "a child mortality dummy"? There is a variable b5 in the KR and BR files that is 1 if the child survived to the date of interview and 0 if died.

The IR and BR files go out to a maximum of 20 children ever born. The KR file goes out to a maximum of 5 births because it only includes children born in the past 5 years.

The following Stata lines will add the DV variables for the mother to the children's data.

* Specify a workspace
cd e:\DHS\DHS_data\scratch

* Save a version of the IR file restricted to the DV variables (or other variables
*   you want to add to the KR or BR file), plus the ID variables
 
use "...IAIR7EFL.DTA" , clear
keep v001 v002 v003 v024 d*
save dtemp.dta, replace

* Open the KR or BR file
use "...IAKR7EFL.DTA" , clear
gen in_file=1
tab in_file
merge m:1 v001 v002 v003 v024 using dtemp.dta

* Restrict to cases in the child file
tab _merge in_file,m
keep if in_file==1

* Save this file with a new name
Forum: General
 Topic: GIS Temperature data
GIS Temperature data [message #28916] Thu, 28 March 2024 04:17
Anmol is currently offline  Anmol
Messages: 1
Registered: March 2024
Member
I want to merge PDHS data with GIS data. In this, I am interested to find average temperature for each month of years (2012-2018) like Mar 2014, April 2016 and so on. Is there a way that I can get this data?
 Topic: Region Variable v024 (Haiti)
Re: Region Variable v024 (Haiti) [message #28921 is a reply to message #28894] Thu, 28 March 2024 15:11
Janet-DHS is currently offline  Janet-DHS
Messages: 666
Registered: April 2022
Senior Member
Following is a response from DHS staff member, Tom Pullum:

The variable hv024 (in the HR and PR files), v024 (in the IR, BR, and KR files) and mv024 (in the MR file) is generically referred to as region. In the Haiti surveys, it is the department. Here are the codes in the 2017 survey:

. label list HV024
HV024:
0 aire metropolitaine
1 rest-ouest
2 sud-est
3 nord
4 nord-est
5 artibonite
6 centre
7 sud
8 grand'anse
9 nord-ouest
10 nippes

These match with the departments given here https://en.wikipedia.org/wiki/Departments_of_Haiti but in a different sequence.
 Topic: Village Recode of NFHS
Re: Village Recode of NFHS [message #28926 is a reply to message #28896] Thu, 28 March 2024 15:22
Janet-DHS is currently offline  Janet-DHS
Messages: 666
Registered: April 2022
Senior Member
Following is a response from DHS staff member, Tom Pullum:
#2 is the only NFHS for which there are VR files.
Forum: Child Health
 Topic: Overweight to under 5 children
Re: Overweight to under 5 children [message #28923 is a reply to message #28904] Thu, 28 March 2024 15:17
Janet-DHS is currently offline  Janet-DHS
Messages: 666
Registered: April 2022
Senior Member
Following is a response from DHS staff member, Tom Pullum:

The measurements of height and weight are done in the household survey.  All of the measured children appear in the PR file, and there the variables have the prefix hc.  Later, women are interviewed and they list their children in a birth history. All of their children born in the past 5 years are included in the KR file. For children who were measured, their va;ies are copied into the KR file during data processing, with the prefix hw.

Most children in the PR file are also in the KR file and most children in the KR file are also in the PR file.  For individual children who are in both files, there is no difference at all.  However, some children in the PR file are not in the KR file.  These are children whose mothers have died, or are not in the same household as the child, or were not interviewed.  (Also some children in the KR file are not in the PR file--children who have died or are not living in the same household as the mother--but they have not been measured.)

Some other variables are in more than one file but have different names. For example, a woman's anemia status is ha57 in the PR file but v457 in the IR file, but for an individual woman who is in both files, her values are exactly the same.
 Topic: Vaccination Coverage
Re: Vaccination Coverage [message #28927 is a reply to message #28891] Thu, 28 March 2024 15:23
Janet-DHS is currently offline  Janet-DHS
Messages: 666
Registered: April 2022
Senior Member
Following is a response from DHS staff member, Tom Pullum:

For your research on vaccination coverage in children under 32 months in Sub-Saharan Africa, you can find relevant data from the Demographic and Health Surveys (DHS). The DHS collects data on vaccination coverage, among other health indicators, in many countries including those in Sub-Saharan Africa.

The variable of interest, indicating whether a child had complete vaccination coverage or not, can be found in the children's recode (KR) file of the DHS datasets. This file contains information for all children born in the five years preceding the survey. The variable is named v435 and it indicates whether a child is fully immunized or not.

In addition to the vaccination coverage variable, the KR file also contains other relevant explanatory variables for your analysis such as the child's age, sex, birth order, mother's education level, mother's age, place of residence (urban/rural), and wealth index, among others.

Regarding your question about the use of the BR database, it is important to note that the BR file contains information for all births in the five years preceding the survey to women of reproductive age (15-49 years). If you are interested in all children under 32 months regardless of the mother's age, the KR file would be more appropriate for your analysis.

For questions regarding the DHS Program history or specific information about the surveys please go to dhsprogram.com. This chatbot is intended for answering UserForum questions.
Forum: Nutrition and Anthropometry
 Topic: Maternal Education and Stunting
Re: Maternal Education and Stunting [message #28928 is a reply to message #28900] Thu, 28 March 2024 15:25
Janet-DHS is currently offline  Janet-DHS
Messages: 666
Registered: April 2022
Senior Member
Following is a response from DHS staff member, Tom Pullum:

To proceed with your analysis in Stata, you will need to use regression commands. For your first question, you can use a logistic regression model where the dependent variable is stunting (coded as 1 for stunted, 0 for not stunted) and the independent variable is mother's education (measured in years). You can also include an interaction term between mother's education and a binary variable for urban/rural location to see how the impact of mother's education on stunting varies across urban and rural areas. The Stata command for this would be:
logit stunting c.mother_education##c.urban_rural

For your second question, you will need to recode mother's education into categories (e.g., no education, incomplete primary, complete primary, etc.) and then run a logistic regression model with these categories as independent variables. You can then compare the coefficients to determine which category yields the greatest relative return. The Stata command for this would be:
xi: logit stunting i.education_category

Please note that these are basic commands and you may need to adjust them based on the specifics of your dataset and research question.
Forum: Uganda
 Topic: A n Urgent Request: how to merge data files
Re: A n Urgent Request: how to merge data files [message #28922 is a reply to message #28903] Thu, 28 March 2024 15:15
Janet-DHS is currently offline  Janet-DHS
Messages: 666
Registered: April 2022
Senior Member
Following is a response from DHS staff member, Tom Pullum:

You have to use hv112 and hv114 to match children with their mothers and fathers.  You can't do it with hv101.

Below I will paste a Stata program to do this.  I don't use R but hope you can convert to R. It could be more efficient but it runs very quickly. This constructs a new file, with the variables renamed to have suffix "child", "mother" and "father". The cases are children age 0-17.  The education variables are hv106-hv109 and hv121-hv124. A 2x2 table is produced  describing the matches.  Hope this helps.

* specify a workspace
cd e:\DHS\DHS_data\scratch

* The education variables are hv106-hv109, hv121-hv124

* Make a file of potential mothers
use "C:\Users\26216\ICF\Analysis - Shared Resources\Data\DHSdata\UGPR7BFL.DTA", clear
keep if hv104==2
drop if hv105<=17
keep hv*
rename hv001 cluster
rename hv002 hh
rename hvidx mo_line
rename hv114 fa_line
rename hv* hv*_mother
save mother.dta, replace
* Make a file of potential fathers
use "C:\Users\26216\ICF\Analysis - Shared Resources\Data\DHSdata\UGPR7BFL.DTA", clear
keep if hv104==1
drop if hv105<=17
keep hv*
rename hv001 cluster
rename hv002 hh
rename hvidx fa_line
rename hv* hv*_father
save father.dta, replace

* Make a file of children age 0-17
use "C:\Users\26216\ICF\Analysis - Shared Resources\Data\DHSdata\UGPR7BFL.DTA", clear
keep if hv105<=17
keep hv*
rename hv001 cluster
rename hv002 hh
rename hv112 mo_line
rename hv114 fa_line
rename hv* hv*_child

gen child=1
tab child
label define noyes 1 "No" 3 "Yes"
quietly merge m:1 cluster hh mo_line using mother.dta
rename _merge mother_matched
label values mother_matched noyes
keep if child==1
quietly merge m:1 cluster hh fa_line using father.dta
rename _merge father_matched
label values father_matched noyes
keep if child==1

tab *matched
 
. tab *matched

mother_mat |    father_matched
      ched |        No        Yes |     Total
-----------+----------------------+----------
        No |    10,095      3,095 |    13,190
       Yes |    10,828     26,454 |    37,282
-----------+----------------------+----------
     Total |    20,923     29,549 |    50,472

* save this file
Re: A n Urgent Request: how to merge data files [message #28929 is a reply to message #28903] Thu, 28 March 2024 16:32
Jackie N is currently offline  Jackie N
Messages: 2
Registered: March 2024
Member
Hi Tom and Janet,

Thank you both very much for your response. This is critically illuminating. I need the children to be at least 21 in 2016 because that way, they would have had an opportunity to pursue primary-tertiary education. It is just easier to draw conclusions when they've, theoretically, "finished" school rather than when they are still going through the system.


Hopefully, this results in a sufficient sample size.


Much thanks once again,

Jackie.
Forum: Reproductive Health
 Topic: Regarding term pregnancy
Re: Regarding term pregnancy [message #28925 is a reply to message #28892] Thu, 28 March 2024 15:21
Janet-DHS is currently offline  Janet-DHS
Messages: 666
Registered: April 2022
Senior Member
Following is a response from DHS staff member, Tom Pullum:

I don't think v233 will be useful. If you enter "tab v233 v228,m" you will see that v233 only refers to the most recent terminated pregnancy ("terminated" means "not a live birth").

In the NR file, you can enter "tab p20 p32". The first column, for live births, has 3 at 6 months, 34 at 7 months, 287 at 8 months, 2807 at 9 months, and 46 at 10 months. I think this is the closest we can come to what you are looking for. We do not have weeks, just months.  It is not clear whether, say, "9 months" means "in the 9th month of pregnancy" or "after 9 completed months of pregnancy, but not 19".  These are not clinical data.  Another table that could be useful is given by "tab m14 p20 if p32==1 & pidx==1".  You can repeat that command for other values of p32. Your analysis should include sampling weights, which I have omitted here.
 Topic: Gabon Abortion s231a
Gabon Abortion s231a [message #28930] Thu, 28 March 2024 19:26
behayes4 is currently online  behayes4
Messages: 20
Registered: February 2020
Member
In Gabon 2019 - 2021 is s231a for the last 5 years or lifetime? Also, was there a filter question before this item? The sample size drops for this item. Thank you !



Current Time: Thu Mar 28 19:30:42 Coordinated Universal Time 2024