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: 15
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: 1510
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: 15
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: 1510
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: 15
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: 1510
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 message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1510
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"
Previous Topic: Declaring my Data Survey Data
Next Topic: Unique ID Error
Goto Forum:
  


Current Time: Mon Dec 17 01:05:22 Eastern Standard Time 2018