The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Nepal » Nutritional status of women
Re: Nutritional status of women [message #23389 is a reply to message #23385] Thu, 02 September 2021 09:29 Go to previous messageGo to previous message
Shireen-DHS is currently offline  Shireen-DHS
Messages: 140
Registered: August 2020
Location: USA
Senior Member
Hello,

It's best not to drop cases in this way. You have dropped cases according to bmi and then again for height, but that could drop women still part of the bmi sample. It's better to replace your variables as missing where the values should not apply.

For your categories I use the following code with the Nigeria 2018 survey and match Table 11.12.

Best,
Shireen


gen bmic=.
replace bmic=1 if v445>=1200 & v445<1850
replace bmic=2 if v445>=1850 & v445<2500
replace bmic=3 if v445>=2500 & v445<3000
replace bmic=4 if v445>=3000 & v445<6000
replace bmic=. if (v213==1 | age<2)
label define bmic 1"Underweight" 2"Normal" 3"Overweight" 4"Obese"
label values bmic bmic

gen wt=v005/1000000

ta bmic [iw=wt]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: DHS 1996, 2001, 2006 village names
Next Topic: Replicating some variables
Goto Forum:
  


Current Time: Tue Nov 26 23:54:16 Coordinated Universal Time 2024