Calculating Undernutrition Indicators for Under-5 Children in Older surveys [message #28630] |
Fri, 09 February 2024 08:40 |
Adetunji
Messages: 7 Registered: August 2023
|
Member |
|
|
Hi,
I am working on the coexisting forms of malnutrition in under-5 children in SSA. Using the KR file in the newer surveys DHS-V upward, I have successfully computed the indicators of undernutrition and their coexistence respectively. I used the variables hw71, hw71 and hw72 for my computation. However, these variables are not found in the same KR file in DHS-IV downward.
Kindly advise on what I should do. My unit of analysis remains the under-5 children.
Thanks in anticipation of your help.
|
|
|
|
|
Re: Calculating Undernutrition Indicators for Under-5 Children in Older surveys [message #28659 is a reply to message #28652] |
Thu, 15 February 2024 16:31 |
Janet-DHS
Messages: 899 Registered: April 2022
|
Senior Member |
|
|
Following is a response from DHS staff member, Tom Pullum:
The formulas for the WHO Child Growth Standards (https://www.who.int/tools/child-growth-standards) have not changed since 2006. The only part of the standards that DHS uses to construct hw70-hw72 are weight, height/length, and whether the child was standing (height) or lying (length) at the time of measurement. The assumptions, cutoffs, etc., are all consistent with WHO standards. We have had several reports related to the quality of the anthropometric data (see our publications page) and there is good evidence of improved measurement, especially of height/length, in the past 6 years or so. With the HW files you can get the values that would have been calculated in earlier years if the formulas had been available in earlier years. If you go back to the earliest years of DHS, however, there was no anthropometry at all.
|
|
|
Re: Calculating Undernutrition Indicators for Under-5 Children in Older surveys [message #30385 is a reply to message #28647] |
Tue, 19 November 2024 10:31 |
Adetunji
Messages: 7 Registered: August 2023
|
Member |
|
|
I am using the Nigeria DHS for 1990 and 2003. I have successfully merged the anthropometric data in the HW file in the 2003 to the KR file using the code below. However, I have issue replicating the same for the 1990 datasets.
There is no b16 (child's line number) in the 1990 KR file and there is no hwhhid in the 1990 HW file.
Kindly let me know how to navigate this. My code is shared below:
use "${kr2003}", clear
gen hwhhid = substr(caseid,1,12)
clonevar hwline = b16
sort hwhhid hwline
merge m:1 hwhhid hwline using "${hw2003}"
keep if _merge==3
//Rename the anthropometric variables to make it comparable to the earlier surveys
rename hc70 hw70
rename hc71 hw71
rename hc72 hw72
rename hc73 hw73
//Save the merged dataset
save "${temp}/kr_hw_2003", replace
use "${kr1990}", clear
gen hwhhid = substr(caseid,1,12)
clonevar hwline = v003
sort hwhhid hwline
merge m:1 hwhhid hwline using "${hw1990}"
keep if _merge==3
//Rename the anthropometric variables to make it comparable to the earlier surveys
rename hc70 hw70
rename hc71 hw71
rename hc72 hw72
rename hc73 hw73
//Save the merged dataset
save "${temp}/kr_hw_1990", replace
|
|
|
Re: Calculating Undernutrition Indicators for Under-5 Children in Older surveys [message #30396 is a reply to message #30385] |
Thu, 21 November 2024 09:37 |
Janet-DHS
Messages: 899 Registered: April 2022
|
Senior Member |
|
|
Following is a response from DHS staff member, Tom Pullum:
The following lines will do the merge for the 1990 files:
use "...NGHW21FL.DTA", clear
rename hwcaseid caseid
rename hwline bidx
merge 1:1 caseid bidx using "...NGKR21FL.DTA"
tab _merge
"hwcaseid" in the HW file is equivalent to "caseid", the woman's unique ID, in the IR and KR files. "hwline" is equivalent to "bidx". You can see the correspondence if you list hwcaseid and hwline for the first 50 cases in the HW file, and caseid and bidx for the first 50 cases in the KR file (for example, "list caseid bidx if _n<=50, table clean").
|
|
|