The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Dataset use in Stata » Food security measurement from Nepal DHS2011
Food security measurement from Nepal DHS2011 [message #8184] Tue, 08 September 2015 08:39 Go to next message
sohelruhrd is currently offline  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 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3013
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.
Re: Food security measurement from Nepal DHS2011 [message #8207 is a reply to message #8201] Fri, 11 September 2015 12:31 Go to previous messageGo to next message
sohelruhrd is currently offline  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.
Re: Food security measurement from Nepal DHS2011 [message #8229 is a reply to message #8207] Fri, 18 September 2015 14:02 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3013
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?
Re: Food security measurement from Nepal DHS2011 [message #8248 is a reply to message #8229] Tue, 22 September 2015 00:40 Go to previous messageGo to next message
sohelruhrd is currently offline  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 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3013
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).

Re: Food security measurement from Nepal DHS2016 [message #13882 is a reply to message #8254] Thu, 18 January 2018 02:41 Go to previous messageGo to next message
Santosh is currently offline  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

[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 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3013
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"
Re: Food security measurement from Nepal DHS2016 [message #18574 is a reply to message #13908] Thu, 02 January 2020 03:51 Go to previous messageGo to next message
RAM075 is currently offline  RAM075
Messages: 4
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.

[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 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3013
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 Go to previous messageGo to next message
Sajhama is currently offline  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
Re: Food security measurement from Nepal DHS2011 [message #23523 is a reply to message #23501] Thu, 30 September 2021 10:53 Go to previous message
Shireen-DHS is currently offline  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
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:
  


Current Time: Mon Mar 18 23:09:47 Coordinated Universal Time 2024