The DHS Program User Forum: Nutrition and Anthropometry » Vitamin A supplement in last 6 months

Home » Topics » Nutrition and Anthropometry » Vitamin A supplement in last 6 months

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

Vitamin A supplement in last 6 months [message #12758]

Mon, 10 July 2017 06:01

Shek
Messages: 19
Registered: November 2014

Member

I am using Nigeria DHS 2013 data set. I am having problem replicating the figures in table 11.7 for percentage given vitamin A supplements in the last 6 months among all children aged 6-59 months.

Report message to a moderator

Re: Vitamin A supplement in last 6 months [message #12762 is a reply to message #12758]

Mon, 10 July 2017 13:00

Liz-DHS
Messages: 1516
Registered: February 2013

Senior Member

Dear User,
The DHS Program has recently released a blog and a series of youtube videos on matching to the final report. You can find these here:
http://blog.dhsprogram.com/final-report-tables/ and here: https:// www.youtube.com/watch?list=PLagqLv-gqpTMU3avlnBDodTWCazURy4C T&v=tjuaPV4eC_E

After reviewing these, if you still have questions, please feel free to post again.
Thank you!

Report message to a moderator

Re: Vitamin A supplement in last 6 months [message #12763 is a reply to message #12762]

Tue, 11 July 2017 03:27

Shek
Messages: 19
Registered: November 2014

Member

Dear Liz,
Thank you very much for your prompt response. However, i am still having difficulties replicating table 11.7 of the 2013 Nigerian DHS report(percentage given vitamin A supplements in the last 6 months).
-What variable was used for vitamin A supplementation in the last 6 month?
-I used H34 and recoded as follow: 1=1 (yes), 0=0 (No), 8=0 (dont know), 9=missing. I then selected children aged 6-59 months (after creating the variable childs age (v008-b3)). However, the weighted prevalence of vitamin A supplementation that i got for all children aged 6-59 months is quite different from what was reported in the 2013 Nigeria DHS report.

Report message to a moderator

Re: Vitamin A supplement in last 6 months [message #12769 is a reply to message #12763]

Tue, 11 July 2017 12:24

Liz-DHS
Messages: 1516
Registered: February 2013

Senior Member

A response from Senior Analyst, Dr. Lindsay Mallick:
Quote:

Here is some code to help match the Vitamin A indicator to the final report. In order to match, you also have to use the date of the supplementation according to the vaccination card.

gen wt= v005/1000000

gen agemonths = v008 - b3

*to match vitamin A to the report, need to convert month/year from vaccination card into CMC
gen month = h33m if h33m<13 & h33m>0
gen year=h33y if h33y>2004 & h33y<2016
gen vacccmc = (year - 1900)*12 + month
gen last6 = v008 - vacccmc
gen lastva = 1 if last6<7

gen vita=0 if b5==1
replace vita=1 if h34==1
replace vita=1 if lastva==1
                                
tab  vita  if agemonths>5 & agemonths<60 [iw=wt]

Thanks,
Lindsay

Report message to a moderator