The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Other countries » Pakistan: Standard DHS, 1990 Dataset (Question about Stunting Estimates)
Re: Pakistan: Standard DHS, 1990 Dataset [message #22390 is a reply to message #22384] Fri, 05 March 2021 08:21 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 2407
Registered: February 2013
Senior Member
Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

This is an old survey, and dates to the time when height and weight were measured as part of the survey of women, rather than the household survey. Therefore only the children whose mother was alive and in the same household as the child were measured. In the HW file, I see that the id's are badly labeled. "hwcaseid" is actually the mother's "caseid" and "hwline" is bidx, NOT the household line number of the child. This survey predates the use of b16.

So for this survey the HW file is to be merged with the KR file, not the PR file. The lines to do this are below. There is a 1 to 1 match, that is, _merge=3 for all cases in the merged file. You only need to change the paths.

use "C:\Users\26216\ICF\Analysis - Shared Resources\Data\DHSdata\PKHW21FL.DTA" 
rename hwcaseid caseid 
rename hwline bidx

sort caseid bidx
save e:\DHS\DHS_data\scratch\PKtemp.dta, replace

use "C:\Users\26216\ICF\Analysis - Shared Resources\Data\DHSdata\PKKR21FL.DTA" 
sort caseid bidx

merge caseid bidx using e:\DHS\DHS_data\scratch\PKtemp.dta
tab _merge

[Updated on: Fri, 05 March 2021 08:22]

Report message to a moderator

Read Message
Read Message
Read Message
Previous Topic: Indonesian Special DHS 2002-03
Next Topic: Philippine 2008-2017 data - strata ID
Goto Forum:

Current Time: Wed Oct 20 14:47:39 Coordinated Universal Time 2021