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

Forum: Unmet Need
 Topic: Response code as "In-consistence" be valuable to include in analysis ?
Response code as "In-consistence" be valuable to include in analysis ? [message #18019] Sun, 18 August 2019 05:11
drseinhlaing is currently offline  drseinhlaing
Messages: 4
Registered: August 2019
Member
Dear DHS specialist

I am analyzing FP unmet need and it predictors in Myanmar DHS 2015-16. In Myanmar DHS data, for example : v531 : Age at first Sex (Imputed) , there is responses coded as "In-consistence". I would like to ask , what should be the suitable practice of managing this category of responses - "In-consistence" while analyzing association between v531 ( predictor variable) and FP-Unmet need ( out come variable) ?
Similarly, another example of V729, Husband / partner Education attainment , there is responses coded as "Don't Know". what should be the suitable practice of managing this category of responses - "Don't know" while analyzing association between predictor variable and FP-Unmet need ( out come variable) ?

Could I re-coded those responses "In-consistence", "Don't Know" as missing data and treated as missing data? or any other recommended practices to manage those responses recoded as "In-consistence" / "Don't Know".

Thanks for your kind guidance
With regards
Sein Hlaing

[Updated on: Sun, 18 August 2019 05:17]

Report message to a moderator

Forum: General Data Questions
 Topic: Education variable (PR file)
Education variable (PR file) [message #18004] Wed, 14 August 2019 03:32
Nyamwiza is currently offline  Nyamwiza
Messages: 3
Registered: August 2019
Member
Good evening Admin,

I am a student at the University of Nottingham working on a research project looking at the prevalence of the risk factors for COPD in Nepal. My outcome measures are;
Type of cooking fuel biomass- yes or no (Created from hv226)
A new variable exposure to biomass smoke in the home was created if cooking took place in the house and biomass==1 Tab hv241 if solid==1
Exposure to tobacco smoke in the home hv252

My supervisors didn't seem to agree on whether to use the HR file or the PR file. I for one had used the PR file as I was looking at the household members exposed to the above markers of HAP.
My independent variables in this analysis include hv271(I used household wealth so that individuals from the same household get to be in the same quintile), hv104, hv105, shecoreg, hv025, hv024, and hv105.

My question is on hv105. How do I get the education level of the household head- I am trying to find out how education level of the household head affects the odds of exposure to household air pollution. I tried to use one of the ideas on the forum but got a bit confused.
Using the PR file, I did the following:
gen headed = hv106 if 101==1 (headed being the education level of the household head). This generated 11,040 which is expected.
But how do I assign this score to the different household members so that people in the same household are assigned to the same household head's education level. I hope my question makes sense.

Thanks in advance,
 Topic: Questions about employment
Questions about employment [message #18000] Tue, 13 August 2019 06:39
anarinaldi is currently offline  anarinaldi
Messages: 10
Registered: December 2016
Location: Uberlandia - Brazil
Member
Hello:

I have doubts about question v717 about work of woman. What kinds of job are categorized as "skilled manual" and "unskilled manual"?
Is it possible to find in any manual of DHS? I searched at manual recode and manual map, but i did not find.
Thank you so much,
Ana Elisa
Forum: India
 Topic: NFHS-4 Median Birth interval mismatch
NFHS-4 Median Birth interval mismatch [message #18002] Tue, 13 August 2019 13:03
dfnbcc is currently offline  dfnbcc
Messages: 3
Registered: June 2019
Member
Hello,

I am trying to calculate the median birth interval using STATA from the NFHS-4. However, I am getting the wrong median compared to the report. The report says the median in India is 32 months, however, I am getting 28 months.

I am subtracting 9 months from the variable as I want birth-to-pregnancy interval, not birth-to-birth. But even if I don't subtract 9, I get different values.

use IABR74FL.dta
gen weight=v005/1000000

rename sdistri shdistri
tostring  shdistri, replace 
gen strata = shdistri
svyset v021 [pweight=weight], strata (strata)

keep shdistri v008 b3 bord b0 b11 v106 hv024 v025 v190 v447a v133 s301 hv001 hv002 hvidx v005 v021 weight strata


*Births in the month of interview are included and births 60 months before the interview are excluded.
	gen monthssncbirth=v008-b3
	replace monthssncbirth=. if monthssncbirth<=60
	drop if monthssncbirth==.
	
*First-order births (and their twins) are excluded from both numerators and denominators.	
	svy: tab bord
	gen birth_order=bord if (b0 > 1) 
	svy: tab birth_order

*subtract by 9 months to find birth-to-pregnancy interval (WHO)
	gen birth_interval=b11-9 
	replace birth_interval=. if birth_interval<0


Members Search Help Register Login Home Home » Topics » Fertility » NFHS-4 Median Birth interval (Median birth interval does not match NFHS-4 report)
Show: Today's Messages :: Show Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
- NFHS-4 Median Birth interval [message #17992] Sun, 11 August 2019 11:28
dfnbcc is currently offline dfnbcc
Messages: 2
Registered: June 2019
Member
Hello,

I am trying to calculate the median birth interval using STATA from the NFHS-4. However, I am getting the wrong median compared to the report. The report says the median in India is 32 months, however, I am getting 28 months.

I am subtracting 9 months from the variable as I want birth-to-pregnancy interval, not birth-to-birth. But even if I don't subtract 9, I get different values.


Code: [Select all] [Show/ hide]
use IABR74FL.dta
gen weight=v005/1000000

rename sdistri shdistri
tostring shdistri, replace
gen strata = shdistri
svyset v021 [pweight=weight], strata (strata)

keep shdistri v008 b3 bord b0 b11 v106 hv024 v025 v190 v447a v133 s301 hv001 hv002 hvidx v005 v021 weight strata


*Births in the month of interview are included and births 60 months before the interview are excluded.
gen monthssncbirth=v008-b3
replace monthssncbirth=. if monthssncbirth<=60
drop if monthssncbirth==.

*First-order births (and their twins) are excluded from both numerators and denominators.
svy: tab bord
gen birth_order=bord if (b0 > 1)
svy: tab birth_order

*subtract by 9 months to find birth-to-pregnancy interval (WHO)
gen birth_interval=b11-9
replace birth_interval=. if birth_interval<0

Would appreciate some help please.

Thanks in advance.
Forum: Nutrition and Anthropometry
 Topic: Missing Children Anthropometry and female adult BMI data from Indonesian Country
Missing Children Anthropometry and female adult BMI data from Indonesian Country [message #18010] Fri, 16 August 2019 01:36
feraketti is currently offline  feraketti
Messages: 1
Registered: August 2019
Location: Debrecen
Member
There is no data about children anthropometry and female adult BMI from Indonesian Country in DHS-7 (2017). Is there any information regarding to that problem? Thank you
 Topic: Dietary Diversity Indicators - Children aged 24-59 months (Malawi DHS 2015-16)
Dietary Diversity Indicators - Children aged 24-59 months (Malawi DHS 2015-16) [message #18003] Tue, 13 August 2019 21:28
Lydia is currently offline  Lydia
Messages: 1
Registered: July 2019
Member
Hi DHS Team

I am calculating Minimum Dietary Diversity for children from the Malawi DHS 2015-16 KR file.
I understand from p. 40 of the Malawi Key Indicators Report http://sphfm.medcol.mw/wp-content/uploads/2016/06/DHS-Malawi -2015-16-key-indicators.pdf that 24hr dietary recall data was collected for "all children born in 2-years preceding the survey" that is those that are between 0-23 months that are alive and living with the mother.

In the KR file I note that there is 24hr dietary recall data for children aged over 2 years - for children aged between 24-59 months.
In light of the fact that only dietary consumption data was collected for children between 0-23 months - how was the dietary consumption data for variables v414E-V calculated for the older children?

I have read both the questionnaire and recode manual and it is not clear if/-how this dietary data for 0-23 month olds was extrapolated to older children. I understand from a previous thread ( https://userforum.dhsprogram.com/index.php?t=msg&goto=84 13&S=Google) that the following duplication/extrapolation was used in a Kenyan dataset:

"The food questions are asked of the mother for the youngest child born within the last 3 years of the interview year. Once these questions are answered, they are then attached to all children in the family of this specific child in the birth recode file."

May I confirm if this duplication of dietary consumption data to all children in the family is also correct for the Malawi dataset.

Warm regards,
Lydia O'Meara
WorldFish (CGIAR)
 Topic: Nutritional Status among Children Age 5-19 Years
Nutritional Status among Children Age 5-19 Years [message #17994] Sun, 11 August 2019 20:57
zelalemth is currently offline  zelalemth
Messages: 3
Registered: August 2018
Location: United States
Member
I am trying to generate similar tables found on pages 176-177 of the final report of the 2014 Egypt DHS that discussed the Nutritional Status among Children Age 5-19 Years. This age group was not captured in the KR file and I am using the BR file. I was able to calculate the BMI using bmi=v445/100. How do I calculate the age-sex specific BMI-scores in SAS? The Guide to DHS Statistics does not cover this age-group.

Thanks,
Zelalem
Forum: Uganda
 Topic: DPT Summary Statistics UDHS2006
DPT Summary Statistics UDHS2006 [message #18007] Thu, 15 August 2019 11:52
Geraldo is currently offline  Geraldo
Messages: 1
Registered: August 2019
Member
Dear All

I am a student of Epidemiology at University of Antwerp, Belgium,

I am currently looking at DHS data for the last five survey for Kenya, Uganda and Tanzania. I intend to look at the trends in vaccination uptake and determinants as proxy for assessing vaccine hesitancy in the East African region.

However, i found 2006 data for Uganda disturbing, the summary statistics for DPT are significantly different from the final report

I generated the age for children under five as follows:
gen months = v008-b3
gen agechild=.
replace agechild=1 if b5==1 & months>11 & months<24
replace agechild=2 if b5==1 & months>23 & months<36
replace agechild=3 if b5==1 & months>35 & months<=59

Please attached stata summary for DPT,

Looking forward to your timely support

Regards,

Gerald
Forum: Merging data files
 Topic: Merging MR and HR and analyzing a variable from HR
Merging MR and HR and analyzing a variable from HR [message #17998] Mon, 12 August 2019 16:25
abark is currently offline  abark
Messages: 1
Registered: August 2019
Member
Hi: I'm using data from the 2015 Tanzanian DHS. I can merge MR and HR by hv001 and hv002 but I want to analyze how many men own a mosquito bed net. That variable for bed net ownership is in the HR dataset (var HV227). In the accompanying IR dataset, this variable is available as V459 and states that it was received from the HR dataset.

Why doesn't the MR dataset have a parallel "mv459" variable?
And how can I figure out how many men own mosquito bed nets after I have merged the MR and IR datasets in SAS? (I have over 14,000 observations and only 3 variables in my merged data sets-- var hv001 hv002 and hv003).

Thank you in advance.
Forum: Other countries
 Topic: Ethiopia IR files have wrong interview date
Ethiopia IR files have wrong interview date [message #17997] Mon, 12 August 2019 14:57
ozak is currently offline  ozak
Messages: 9
Registered: May 2019
Member
Hi,

It seems all the Ethiopia IR files have wrong dates for v007. E.g.

ETIR41FL.DTA shows v007==1992
ETIR51FL.DTA shows v007==1997
ETIR61FL.DTA shows v007==2003
ETIR70FL.DTA shows v007==2008

instead of

ETIR41FL.DTA - 2000
ETIR51FL.DTA - 2005
ETIR61FL.DTA - 2010/1
ETIR70FL.DTA - 2016

So when trying to merge with the geofiles it fails.
Forum: Service Provision Assessment (SPA)
 Topic: Facility Family planning volume -Senegal
Facility Family planning volume -Senegal [message #17993] Sun, 11 August 2019 20:23
kbrindle is currently offline  kbrindle
Messages: 2
Registered: November 2018
Member
Hello,

I'm working with Senegal 2015 raw facility, provider and family planning files, and trying to recreate the variable that is similar to v2002a and v2000a, from Senegal recoded 2012: "fp: n providers per service" and "number of eligible providers" but cannot figure out how this was calculated from the facility raw files. I tried to merge in number of eligible FP providers from the "Staff/listing provider file", raw, but the numbers of providers eligible on day of survey/assessment do not match up. Please let me know how best to code variable from the raw Senegal 2015 files.
Thank you.



Current Time: Sun Aug 18 13:56:02 Eastern Daylight Time 2019