The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Nigeria » sanitation service (percentage of basic and limited sanitation service )
sanitation service [message #25341] Fri, 07 October 2022 17:29 Go to next message
anum.ali is currently offline  anum.ali
Messages: 6
Registered: September 2022
Member
Can someone guide me how to generate percentage of basic and limited sanitation service for nigeria 2018 dhs for de jure population/household for chap 2 table 2.3.1 household sanitation facilities?

I have seen DHS guide but unable to generate appropriate percentages

Re: sanitation service [message #25365 is a reply to message #25341] Wed, 12 October 2022 12:18 Go to previous 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:

To get this table, use the PR file. The outcome variable is hv205. You must use weights, hv005. For households, restrict to one record per household, either with hv101=1 or hvidx=1. For individuals, get de jure residents with hv102. The following Stata lines will match the percentages and frequencies in table 2.3.1.

use "...NGPR7BFL.DTA", clear

* For households, restrict to household head
tab hv205 if hv101==1 [iweight=hv005/1000000]

* For individuals, restrict to de jure
tab hv205 if hv102==1 [iweight=hv005/1000000]
Previous Topic: DV ELIGIBLE WOMEN
Next Topic: chap 9 reproductive health
Goto Forum:
  


Current Time: Sun Nov 24 22:38:39 Coordinated Universal Time 2024