The DHS Program User Forum: Dataset use in Stata » Food security measurement from Nepal DHS2011

Home » Data » Dataset use in Stata » Food security measurement from Nepal DHS2011

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

Food security measurement from Nepal DHS2011 [message #8184]

Tue, 08 September 2015 08:39

sohelruhrd
Messages: 19
Registered: July 2014
Location: Bangladesh

Member

Hi,

I want to create a variable for different levels of household food security from Nepal DHS 2011 dataset.

Can anybody help me?

Thanks
SR

[Updated on: Tue, 08 September 2015 08:41]

Report message to a moderator

Re: Food security measurement from Nepal DHS2011 [message #8201 is a reply to message #8184]

Thu, 10 September 2015 07:26

Bridgette-DHS
Messages: 3214
Registered: February 2013

Senior Member

Please see the attached user request related to food security, and a response from the Nepal country manager, Anju Pradhan. This might help.

Attachment: FoodSecurity.docx
(Size: 16.11KB, Downloaded 1559 times)

Report message to a moderator

Re: Food security measurement from Nepal DHS2011 [message #8207 is a reply to message #8201]

Fri, 11 September 2015 12:31

sohelruhrd
Messages: 19
Registered: July 2014
Location: Bangladesh

Member

Thanks for sending the response file.

I used the following STATA code to estimate different levels of food insecurity form Nepal DHS 2011 household record dataset. I was able to estimate food security. But, different levels of food insecurity is not matching with Table 2.17 (page 37). Could you please help me in this regards.

clear all
use "C:\dhs\data\NPHR60FL.DTA", clear
set more off
gen fsecurity=1 if ((sh130==0 | sh130==1) & sh131==0 & sh132==0 & sh133==0 & sh134==0 & sh135==0 & sh136==0)
replace fsecurity=2 if ((sh130==2 | sh130==3 | sh131==1 | sh131==2 | sh131==3 | sh132==1) & sh133==0 & sh134==0 & sh135==0 & sh136==0)
replace fsecurity=3 if ((sh130==2 | sh130==3 | sh131==1 | sh131==2 | sh131==3 | sh132==2 | sh132==3 | sh133==1 | sh133==2 | sh134==1 | sh134==2 ) & sh135==0 & sh136==0)
replace fsecurity=4 if (sh130==2 | sh130==3 | sh131==2 | sh131==3 | sh132==2 | sh132==3 | sh133==3 | sh134==3 | sh135==1 | sh135==2 | sh135==3 | sh136==1 | sh136==2 | sh136==3)
tab fsecurity
tab fsecurity [iw=hv005]

Thank you.

Report message to a moderator

Re: Food security measurement from Nepal DHS2011 [message #8229 is a reply to message #8207]

Fri, 18 September 2015 14:02

Bridgette-DHS
Messages: 3214
Registered: February 2013

Senior Member

Our Stata specialist is reviewing your post. Before he answers your question about the food security indicator in the Nepal 2011 survey, can we first ask where you got the Stata code that you posted? Did you construct it yourself, or did you get it from another source or another survey?

Report message to a moderator

Re: Food security measurement from Nepal DHS2011 [message #8248 is a reply to message #8229]

Tue, 22 September 2015 00:40

sohelruhrd
Messages: 19
Registered: July 2014
Location: Bangladesh

Member

Thanks for your reply.

I have constructed it myself. I tried to generate a single variable for different levels of food security and followed the conditions from the attached docx file in your previous reply (response from the Nepal country manager).

The conditions are:

HFIA category 1:
If [(Q130=0 or Q130=1) and Q131=0 and Q132=0 and Q133=0 and Q134=0 and Q135=0 and Q136=0]
HFIA category 2:
If [(Q130=2 or Q130=3 or Q131=1 or Q131=2 or Q131=3 or Q132=1) and Q133=0 and Q134=0 and Q135=0 and Q136=0]
HFIA category 3:
If [(Q130=2 or Q130=3 or Q131=1 or Q131=2 or Q131=3 or Q132=2 or Q132=3 or Q133=1 or Q133=2 or Q134=1 or Q134=2) and Q135=0 and Q136=0]
HFIA category 4:
If [Q130=2 or Q130=3 or Q131=2 or Q131=3 or Q132=2 or Q132=3 or Q133=3 or Q134=3 or Q135=1 or Q135=2 or Q135=3 or Q136=1 or Q136=2 or Q136=3]

Thank you.

[Updated on: Tue, 22 September 2015 00:41]

Report message to a moderator

Re: Food security measurement from Nepal DHS2011 [message #8254 is a reply to message #8248]

Tue, 22 September 2015 10:48

Bridgette-DHS
Messages: 3214
Registered: February 2013

Senior Member

Following is a response from our DHS Stata Specialist, Lindsay Mallick:

Here is the code that produces results which match the table in the final report:

gen fsecurity=1 if (sh130==0 | sh130==1) & sh131==0 & sh132==0 & sh133==0 & sh134==0 & sh135==0 & sh136==0
replace fsecurity=2 if (sh130==2 | sh130==3 | sh131==1 | sh131==2| sh131==3 | sh132==1) & sh133==0 & sh134==0 & sh135==0 & sh136==0
replace fsecurity=3 if (sh132==2 | sh132==3 | sh133==1 | sh133==2 | sh134==1 | sh134==2 ) & sh135==0 & sh136==0
replace fsecurity=4 if (sh133==3 | sh134==3 )| (sh135==1 | sh135==2 | sh135==3 | sh136==1 | sh136==2 | sh136==3)
tab fsecurity [iw=hv005/1000000]

The levels of food insecurity are mutually exclusive and not cumulative (as you appeared to have them coded in your post).

Report message to a moderator

Re: Food security measurement from Nepal DHS2016 [message #13882 is a reply to message #8254]

Thu, 18 January 2018 02:41

Santosh
Messages: 8
Registered: January 2018
Location: Tokyo, Japan

Member

Dear DHS Experts,

Currently, I am working on Nepal DHS data 2016.I was trying to reproduce the food security estimates provided in Nepal DHS 2016 report (Table 2.20). I followed "Household Food Insecurity Access Scale Indicator Guide v.2". I was able to match the sample size, but the percentage didn't match.

So could you kindly help me to get the exact result.

Regards,
Santosh

Attachment: Sam food security.do
(Size: 0.98KB, Downloaded 1002 times)

[Updated on: Sun, 21 January 2018 22:43]

Report message to a moderator

Re: Food security measurement from Nepal DHS2016 [message #13908 is a reply to message #13882]

Tue, 23 January 2018 12:30

Bridgette-DHS
Messages: 3214
Registered: February 2013

Senior Member

Please see the following response from DHS Technical Specialist, Rukundo Benedict:

Your subject line refers to the Nepal 2011 survey but the question is about the Nepal 2016 survey. We have looked at the archived CSPro code that was used to produce the tables in the main report on the 2016 survey. It appears that there was an error in the coding of the "Household Food Insecurity Access Scale Indicator Guide". The problem is that the code used in the report does not specify how to use sh145b=1. This is "unable to eat preferred foods because of lack of resources", response "rarely". Apparently this response should indicate "mild food insecurity".

I will paste below the Stata code that should be correct, but will not match the report. I have highlighted in yellow the piece that was missing (missing from the CSPro version). Please check. If you drop the yellow piece I believe you will get a match with the report. If you include it you will not get a match but will get the correct values.

We will discuss whether to issue an erratum. We will also check whether this error occurred in any other survey reports. Thanks for identifying the problem.

gen foodsec=.

replace foodsec=1 if (sh145a==0 |sh145a==1) & sh145b==0 & sh145c==0 & sh145d==0 & sh145e==0 & sh145f==0 & sh145g==0 & sh145h==0 & sh145i==0  

replace foodsec=2 if sh145a==2 |sh145a==3 | sh145b==1 | sh145b==2 | sh145b==3 | sh145c==1 | sh145d==1 & ( sh145e==0 & sh145f==0 & sh145g==0 & sh145h==0 & sh145i==0) 

replace foodsec=3 if sh145c==2 | sh145c==3 | sh145d==2 | sh145d==3 | sh145e==1 | sh145e==2 | sh145f==1 | sh145f==2 & (sh145g==0 & sh145h==0 & sh145i==0)

replace foodsec=4 if sh145e==3 | sh145f==3 | sh145g==1 | sh145g==2 | sh145g==3 |sh145h==1 | sh145h==2 | sh145h==3 | sh145i==1 | sh145i==2 | sh145i==3  

label define foodsec 1"Food secure" 2 "Mildy food insecure" 3 "Moderately food insecure"  4 "Severely food insecure"
label val foodsec foodsec
label variable foodsec "Household Food Insecurity Access Category"

Report message to a moderator

Re: Food security measurement from Nepal DHS2016 [message #18574 is a reply to message #13908]

Thu, 02 January 2020 03:51

RAM075
Messages: 5
Registered: November 2019

Member

I used this guide for food security index for the dhs 2016. But it also doesnot match with the table generated in DHS report. Can anybody suggest if new index has proposed.

Attachment: food security access.pdf
(Size: 379.12KB, Downloaded 2151 times)

[Updated on: Thu, 02 January 2020 03:53]

Report message to a moderator

Re: Food security measurement from Nepal DHS2016 [message #18611 is a reply to message #18574]

Fri, 10 January 2020 11:10

Bridgette-DHS
Messages: 3214
Registered: February 2013

Senior Member

Please see the following response from DHS Technical Specialist, Rukundo Benedict:

As previously stated, there was a minor error in the coding for this indicator in the Final Report. The corrected code was posted by Dr. Benedict. With this code you can produce the corrected version of Table 2.20. It will not match the original table 2.20 because the original table was based on an erroneous construction of the HFIAS indicator.

[Updated on: Fri, 10 January 2020 11:11]

Report message to a moderator

Re: Food security measurement from Nepal DHS2011 [message #23501 is a reply to message #8254]

Wed, 29 September 2021 02:49

Sajhama
Messages: 28
Registered: July 2017

Member

Dear Bridgette,

I am trying to generate the four levels of food insecurity for Nepal 2011. I followed the code provided by manager Ms. Anju, however, the data it gave me doesn't match with that of Nepal DHS 2011 report.

Therefore, I ran the code given by you, however it is still same, there isn't change in number (in SPSS)
gen fsecurity=1 if (sh130==0 | sh130==1) & sh131==0 & sh132==0 & sh133==0 & sh134==0 & sh135==0 & sh136==0
replace fsecurity=2 if (sh130==2 | sh130==3 | sh131==1 | sh131==2| sh131==3 | sh132==1) & sh133==0 & sh134==0 & sh135==0 & sh136==0
replace fsecurity=3 if (sh132==2 | sh132==3 | sh133==1 | sh133==2 | sh134==1 | sh134==2 ) & sh135==0 & sh136==0
replace fsecurity=4 if (sh133==3 | sh134==3 )| (sh135==1 | sh135==2 | sh135==3 | sh136==1 | sh136==2 | sh136==3)
tab fsecurity [iw=hv005/1000000]

Please let me know.

Look forward

Attachment: HH FS Nepal.JPG
(Size: 24.86KB, Downloaded 269 times)

Report message to a moderator

Re: Food security measurement from Nepal DHS2011 [message #23523 is a reply to message #23501]

Thu, 30 September 2021 10:53

Shireen-DHS
Messages: 140
Registered: August 2020
Location: USA

Senior Member

Hello,

I used your code below with the HR file of the Nepal 2011 DHS and was able to match Table 2.17 in the final report. See the screenshot of my Stata output.
Have you used the right file? You should be using the NPHR61FL.dta file.

/index.php?t=getfile&id=1757&private=0

Thank you.

Shireen Assaf
The DHS Program

Attachment: NPfoodsecure.png
(Size: 22.80KB, Downloaded 1603 times)

Report message to a moderator

Previous Topic:	How to carry out Individual Meta-analysis of DH surveys in sub-Saharan Africa using Stata
Next Topic:	Cluster level population density data (Geospatial Covariate Datasets)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Dec 18 10:45:35 Coordinated Universal Time 2024