The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Other countries » Mali Household Electricity Access and Child Health (How to go about my analysis on household electricity access and child health in Mali using SPSS.)
Mali Household Electricity Access and Child Health [message #29692] Mon, 22 July 2024 16:59 Go to next message
HPALSOTON is currently offline  HPALSOTON
Messages: 2
Registered: July 2024
Member
Hi there,

I am just wondering how to get data on under five mortality having downloaded the DHS 2018 survey for Mali (child recode downloaded). I know from the DHS website ( https://www.dhsprogram.com/data/Guide-to-DHS-Statistics/Earl y_Childhood_Mortality.htm) that there is a way of calculating it but I am unsure of whether I need to do this calculation in order to use under five mortality as a variable in my research using SPSS software. Would anyone be able to give advice on whether I need to calculate under 5 mortality using the information on the DHS website or whether I could just use StatCompiler Data on under 5 mortality and somehow add a new variable to the Mali 2018 data set that I have downloaded on my computer using StatCompiler stats on Mali under 5 mortality for 2018?

If I do need to calculate the under five mortality using SPSS using variables already in the data set that I have downloaded, how do I go about this? (asking anyone with SPSS experience).

Or, if I should add in a variable using StatCompiler data on under 5 mortality from 2018, how should I go about doing this in SPSS?


For wider context, I plan to look at the correlation between household electricity access and under five mortality in Mali using binomial logistic regression in SPSS. If anyone has advice on how to prepare my variables such as household electricity access, under 5 mortality, and covariates (such as household access to improved sanitation, improved water, and maternal literacy, then please do let me know.

[Updated on: Mon, 22 July 2024 17:00]

Report message to a moderator

Re: Mali Household Electricity Access and Child Health [message #29709 is a reply to message #29692] Wed, 24 July 2024 08:28 Go to previous messageGo to next message
Janet-DHS is currently offline  Janet-DHS
Messages: 888
Registered: April 2022
Senior Member
Following is a response from DHS staff member, Tom Pullum:
Mortality rates are complex and are only defined for aggregates of children.  For an individual-level measure, I suggest you just use the KR file and define a variable that is 1 if b7<12 and 0 otherwise.  b7 is completed months of age IF the child died, and b7<12 identifies children who died before the first birthday. This is analogous to the Infant Mortality Rate but is not the same because the KR file includes children born in the last year who have not had full exposure to the risk of dying before the first birthday. You can analyze this binary outcome with logit regression. You can also b5, which is 1 if the child died (at any age) before the survey. Statistically speaking, it is hard to get statistical significance with these outcomes because they are so skewed (relatively rare). Other indicators of child health may be more useful.  Other users may have other suggestions.
Re: Mali Household Electricity Access and Child Health [message #29717 is a reply to message #29709] Thu, 25 July 2024 15:07 Go to previous message
HPALSOTON is currently offline  HPALSOTON
Messages: 2
Registered: July 2024
Member
Hi there,

Thank you for that feedback. I will consider this in my research, ideally I would want to use under 5 mortality as a measure as I had based this off of another paper that seems to look at household factors such as electricity and their correlation with under 5 mortality.

Best wishes

H
Previous Topic: Pakistan 2017-2018 Excluded Territories
Next Topic: Pakistan DHS from 1990 until 2017
Goto Forum:
  


Current Time: Sun Nov 24 07:34:40 Coordinated Universal Time 2024