The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » General » Functional Disability 5-17 year olds Mozambique (Challenges matching the sample size in table 20.4)
Functional Disability 5-17 year olds Mozambique [message #30524] Sat, 14 December 2024 13:07 Go to next message
Simon is currently offline  Simon
Messages: 6
Registered: October 2024
Member
Hi there,
Very grateful for your time.
I'm working with the 2022 DHS survey for Mozambique and currently looking at functional disabilities in children aged 5-17 (which is unlucky for me since the code for that module isn't yet on github I think!)

Anyway, I've replicated the numbers for 2-5 year olds easily. And am quite confident in my variables for 5-17 year olds. However, I do not match the numbers in the report - and notably, I do not match the sample size of 11,769 reported in table 20.4. I've followed the instructions on handling missing variables and 'don't know' answers quite carefully...

I was hoping you might share the code for this table - and let me know which dataset it is based on. Initially I have assumed Household Members - but I am beginning to wonder if it is Households and something odd has happened in the conversion. Though probably I have just made a mistake somewhere...

Thanks a lot!
Simon
Re: Functional Disability 5-17 year olds Mozambique [message #30550 is a reply to message #30524] Wed, 18 December 2024 12:00 Go to previous messageGo to next message
Janet-DHS is currently offline  Janet-DHS
Messages: 911
Registered: April 2022
Senior Member
Following is a response from DHS staff member, Tom Pullum:

The following lines will give the subsample for the disability variables for 5-17 year olds in this survey. I was able to match the number of cases by restricting to de facto household members with hv103=1. The "Nota" below the table refers to residency status but I don't read Portuguese and I can't tell whether it is consistent with this restriction. I HOPE it is, because that restriction was definitely made.

All of the hdis variables will be NA for the same cases, so you can look at just hdis1, and restrict to hdis1<., to get the cases that are not NA.
use "...MZPR81FL.DTA", clear
keep if hv105>=5 & hv105<=17 & hdis1<. & hv103==1
tab hv104 [iweight=hv005/1000000]
The construction of the relevant table (Table 20.4 in the MZ report) should be the same as before DHS-8, but please let me know if you cannot get a match. It is possible that no updates were needed for the disability variables. I would like to know if updates were needed and they have not yet been uploaded.
Re: Functional Disability 5-17 year olds Mozambique [message #30554 is a reply to message #30550] Fri, 20 December 2024 13:30 Go to previous message
Simon is currently offline  Simon
Messages: 6
Registered: October 2024
Member
Hi Tom,
That's great thank you - yes, when I restrict according to hv103 == 1 I do match.
I also don't speak Portuguese, and in my translated copy of the report, the staying the night previously isn't noted on that particular table (20.4). It is however noted on table 20.1, and 20.2 - I should have tried it sooner! Might be some confusion due to translation, not sure.
I can now exactly match the 2022 Mozambique numbers for functional disability! So thanks very much indeed! :)
Simon
Previous Topic: Assistance with DHS Data Analysis for Maternal Health Indicators
Next Topic: Breaking Down the EA Exam Fees Clearly
Goto Forum:
  


Current Time: Wed Dec 25 15:21:58 Coordinated Universal Time 2024