The DHS Program User Forum: Kenya » KDHS 2022: Table 2.17 Food security status

Home » Countries » Kenya » KDHS 2022: Table 2.17 Food security status

Show: Today's Messages :: Show Polls :: Message Navigator

KDHS 2022: Table 2.17 Food security status [message #28229]

Mon, 04 December 2023 10:29

sokiya
Messages: 76
Registered: May 2017
Location: Nairobi

Senior Member

Hi,
I am interested in reproducing the results in Table 2.17. I have checked the DHS GitHub repository but I haven't found anything.
Thanks in advance!

Report message to a moderator

Re: KDHS 2022: Table 2.17 Food security status [message #28242 is a reply to message #28229]

Tue, 05 December 2023 07:12

Bridgette-DHS
Messages: 3043
Registered: February 2013

Senior Member

Following is a response from Senior DHS staff member, Tom Pullum:

This is a new table and it depends on the specific questions about foods included in the questionnaire. We do not have Stata code for this table and cannot take the time to prepare it. You can read about the Food Consumption Score here ( https://inddex.nutrition.tufts.edu/data4diets/indicator/food -consumption-score-fcs) and elsewhere.

Report message to a moderator

Re: KDHS 2022: Table 2.17 Food security status [message #28248 is a reply to message #28229]

Tue, 05 December 2023 12:33

sokiya
Messages: 76
Registered: May 2017
Location: Nairobi

Senior Member

Can you share the CPSro syntax used so that I can replicate it? As you already know, some of the tables aren't reproducible even based on your Stata codes in GitHub repor. I don't want to take time to reproduce an indicator based on another public document. I would rather replicate what DHS has done and then we pick from there.

Report message to a moderator

Re: KDHS 2022: Table 2.17 Food security status [message #28250 is a reply to message #28248]

Wed, 06 December 2023 01:18

sokiya
Messages: 76
Registered: May 2017
Location: Nairobi

Senior Member

For anyone interested in reproducing the table with Stata, the code below does it

use "KEHR8AFL.dta", clear
desc sh148ca sh148cb sh148cc sh148cd sh148ce sh148cf sh148cg sh148ch sh148ci sh148cj sh148ck sh148cl sh148cm sh148cn sh148co sh148cp

gen g1 = (sh148ca + sh148cb) // Cereals and roots
gen g2 = sh148cc // Pulses, nuts 
gen g3 = (sh148cd + sh148ce + sh148cf) // Vegetables
gen g4 = (sh148cg + sh148ch) // Fruits
gen g5 = (sh148ci + sh148cj + sh148ck + sh148cl) // mMats
gen g6 = sh148cm // Milk
gen g7 = sh148co // Sugar
gen g8 = sh148cp // Oils

forvalues i=1/8 {
	replace g`i' = 7 if g`i' > 7 & g`i' < .
}

gen FCS = (g1*2) + (g2*3) + (g3*1) + (g4*1) + (g5*4) + (g6*4) + (g7*0.5) + (g8*0.5)
label var FCS "Food Consumption Score"
recode FCS (0/21 = 1 "Poor") (22/35 = 2 "Borderline") (nonmissing = 3 "Acceptable") (missing=.), gen(FCG_Groups)

ta FCG_Groups, m
ta FCG_Groups [iw=hv005]

Report message to a moderator

Re: KDHS 2022: Table 2.17 Food security status [message #28263 is a reply to message #28250]

Wed, 06 December 2023 10:38

Bridgette-DHS
Messages: 3043
Registered: February 2013

Senior Member

From Senior DHS staff member, Tom Pullum:

Congratulations on constructing the Stata code yourself! Other users will be able to refer to this.

[Updated on: Wed, 06 December 2023 10:38]

Report message to a moderator

Re: KDHS 2022: Table 2.17 Food security status [message #28814 is a reply to message #28250]

Wed, 13 March 2024 05:54

dkadengye
Messages: 1
Registered: October 2017
Location: Kampala, Uganda

Member

Dear,
The code is very helpful and thank you.
For this same table, I would be happy if you managed to get around how the coping strategy index was computed in Stata.
Thank you.
Damazo

Report message to a moderator

Previous Topic:	KDHS 2022: Table 11.4 Breastfeeding status according to age
Next Topic:	Kenya 1998 Dataset Content Questions

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Apr 27 05:23:55 Coordinated Universal Time 2024