The DHS Program User Forum: Tanzania

Home » Countries » Tanzania » DHS 2022

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

DHS 2022 [message #30643]

Tue, 14 January 2025 08:19

acseng
Messages: 8
Registered: November 2024

Member

I would be grateful if someone could advise me on how to get an estimate for the question described below (it is just a fictitious example):

Country: Tanzania

DHS 2022

Region: Dar es Salaam

Clusters: 141+ 142

Desired estimates: (1) Total number and (2) the proportion of children under 5 years old, in the clusters 141 and 142, over the total
population of Dar es Salaam.

I know that in Dar es Salaam this proportion is around 11.6 (https://sensa.nbs.go.tz/publication/report7.pdf), but I need to know
an estimate for particular clusters in relation to the respective region. In the GPS file TZGC81FL.csv, I found the cells (1)
UN_Population_Count_2020, (2) U5_Population_2020, (3) All_Population_Count_2020, for each cluster, but I noticed that the
cells (1) and (3) seem to have very different numbers.

Report message to a moderator

Re: DHS 2022 [message #30659 is a reply to message #30643]

Wed, 15 January 2025 08:55

Janet-DHS
Messages: 932
Registered: April 2022

Senior Member

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

The Stata lines below illustrate how to get the kinds of numbers I think you are looking for. I am using the PR file for the 2022 survey.

use "...TZPR82FL.DTA" , clear

* hv024 is region
describe hv024

* the label for hv024 is HV024; list it
label list HV024

* which clusters are in hv024=7
tab hv001 if hv024==7

* Look at children in clusters 141 and 142

gen agelt5=0
replace agelt5=1 if hv105<5
label define agelt5 0 "Age 5+" 1 "Age0-4"
label values agelt5 agelt5

* Unweighted
tab agelt5 if hv024==7
tab agelt5 if hv001==141 | hv001==142

* Weighted
tab agelt5 if hv024==7 [iweight=hv005/1000000]
tab agelt5 if hv001==141 | hv001==142 [iweight=hv005/1000000]

Report message to a moderator