| Re: Pakistan: Standard DHS, 1990 Dataset [message #22390 is a reply to message #22384] |
Fri, 05 March 2021 08:21  |
Bridgette-DHS
Messages: 3199
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 |
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
