| Re: Question about Anemia Levels in NFHS5 Adult Data [message #30099 is a reply to message #30092] |
Mon, 23 September 2024 13:19   |
Bridgette-DHS
Messages: 3199
Registered: February 2013
|
Senior Member |
|
|
Following is a response from Senior DHS staff member, Tom Pullum:
Sorry--I see that we were talking about the same survey, but different files.
The biometric data are collected during the household survey. The hemoglobin concentrations and anemia levels are coded in the PR file (IAPR7EFL) as ha56 and ha57 for women and hb56 and hb57 for men. The cutoffs for constructing ha57 from ha56 are different from the cutoffs for constructing hb57 from hb56.
During data processing, DHS copies ha56 and ha57 into the IR file (in which cases are women), changing the names to v456 and v457, respectively. hb56 and hb57 are copied into the MR file (in which cases are men) as mv456 and mv457.
For this survey, the copying into the IR file was done correctly, but apparently the copying into the MR file was not done. As a result, the variables for men are ONLY in the PR file, as hb56 and hb57; the variables mv456 and mv457 should appear in the MR file but are missing. If you want these variables for men, you would never find them in an IR file. They should be in the MR file, but for this survey they are not.
The PR and MR files can be merged to correct this omission. Below I will paste Stata lines that will merge hb56 and hb57 into the MR file and will rename them as mv456 and mv457. There are 7,331 men in the MR file who do not have a valid value of mv457 in the merged file. I don't know why. Hope this will help.
* Specify a workspace
cd e:\DHS\DHS_data\scratch
* Open the PR file, prepare for merge
use "C:\Users\26216\ICF\Analysis - Shared Resources\Data\DHSdata\IAPR7EFL.DTA", clear
rename hv024 mv024
rename hv001 mv001
rename hv002 mv002
rename hvidx mv003
rename hb56 mv456
rename hb57 mv457
keep if mv457<.
keep mv*
save IAPR7Etemp.dta, replace
* Open the PR file and merge
use "C:\Users\26216\ICF\Analysis - Shared Resources\Data\DHSdata\IAMR7EFL.DTA", clear
gen in_MR=1
merge 1:1 mv024 mv001 mv002 mv003 using IAPR7Etemp.dta
tab _merge in_MR,m
keep if in_MR==1
drop _merge
* Save this file with a new name
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
