The DHS Program User Forum       Discussions regarding The DHS Program data and results
Home » Data » Dataset use in SPSS » Calculating cases for IYCF
Calculating cases for IYCF Wed, 26 October 2016 14:05
 anuth Messages: 10Registered: November 2015 Location: Finland Member
Hello DHS team,

I am working on PDHS 2012-13 and calculating some IYCF variables. My cases should be the youngest child living with respondent who are less than 24 months. To calculate this i performed following steps in Under 5 years child file:

1. Select- Age of child <24 months
2. Select- Living with whom=0
3. Select- BIDX=1

But the number of child differ in my calculation and what is given in PDHS 2012-13 report.

My calculation is

Age group of child under 2 years
Frequency Percent Valid Percent Cumulative Percent
Valid Less than 6 months 1075 27,4 27,4 27,4
6 to 8 months 493 12,5 12,5 39,9
9 to 11 months 535 13,6 13,6 53,5
12 to 17 months 1123 28,6 28,6 82,1
18 to 23 months 703 17,9 17,9 100,0
Total 3929 100,0 100,0

But in PDHS 2012-13 report the total number of under 2 years child eligible for IYCF questionnaire is 3,206 ( from table 11.5, page 200)

Grateful if you could help me to find where i am wrong or what i am missing)

Thank you,
Anupa

A
Re: Calculating cases for IYCF [message #11100 is a reply to message #11097] Wed, 26 October 2016 18:12
 Trevor-DHS Messages: 527Registered: January 2013 Senior Member
This is a common misunderstanding. The youngest child living with the mother is not necessarily one with BIDX = 1. BIDX = 1 is for the last child born, but if the last child born had died or does not live with the mother, then the youngest child living with the mother may have BIDX = 2.

Try the following code:
```* Cases should be sorted already, but in case they are not
sort caseid bidx
* Last child in the last 2 years living with mother
* age in months
gen age = v008-b3
lab var age "Age in months"
* keep if under 24 months and living with mother
keep if age<24 & b9==0
* ... and keep the last born of those. If caseid is the same as the prior case, then not the last born.
drop if _n > 0 & caseid == caseid[_n-1]
* generate variable for still breastfeeding
recode m4 (95=1 "Still breastfeeding")(else=0 "Not breastfeeding"), gen(bf)
lab var bf "Currently breastfeeding"
* generate age groupings
recode age (0/5 = 0 "0-5")(6/8 = 1 "6-8")(9/11 = 2 "9-11")(12/17 = 3 "12-17")(18/23 = 4 "18-23"), gen(ageg)
lab var ageg "Age groups"

* tabulate current breastfeeding status by age group
tab ageg bf [iw=v005/1000000]```

Re: Calculating cases for IYCF [message #11411 is a reply to message #11100] Fri, 16 December 2016 02:51
 Roselync Messages: 13Registered: December 2016 Location: Taiwan Member
Dear DHS team and colleagues,
I recently analyzed the individual dataset for 2010 Malawi demographic and health survey and I used SPSS.I selected youngest children living with their mothers aged less than 24 months. I estimated the prevalence rates of child feeding practices but surprisingly my results didn't match those that are in the 2010 report. I found that Exclusive breastfeeding is at 95.5% instead of 71.4% and the rest of the other breastfeeding practices are also higher than expected. My concern is how can I go about to extract the variables for exclusive breastfeeding and predominant feeding since these were not clearly pointed out in the recode manual. Do I use current breastfeeding variable to estimate the exclusive breastfeeding rate? and for predominant feeding, do I compute some variables(drank plain water, juice and milk and breastmilk) to make one composite variable for predominant feeding? Also how do I manage the missing cases in these variables? I also tried the above suggestions to extract the appropriate sample size but still more there is a difference. Mine was 7333 and the report found a sample size of 7724.Any suggestions will be highly appreciated.

Thank you
Re: Calculating cases for IYCF [message #11421 is a reply to message #11411] Mon, 19 December 2016 08:49
 Bridgette-DHS Messages: 1086Registered: February 2013 Senior Member
Following is a response from DHS Senior Research Associate, Shireen Assaf:

Quote:
To match the table for exclusive breastfeeding you would need to compute some variables such as drank any liquids or consuming any solids, etc. The code below can be used to match the table for exclusive breastfeeding. The estimate is 71.4% for children 0-5 months and the denominator is 1,698.

```** Exclusive breast feeding
use MWKR61FL.dta, clear

gen age=v008-b3

keep if b9==0

* finding the youngest child living with the mother for each mother
bysort v001 v002 v003: egen minbidx=min(bidx)
* keep only children less than 2 years
keep if age<24
* need to drop those that are bidx==2 and minbidx==1
drop if bidx>minbidx

gen water=0
gen liquids=0
gen milk=0
gen solids=0
gen breast=0
gen bottle=0

*TO DETERMINE IF CHILD IS GIVEN WATER, SUGAR WATER, JUICE, TEA OR OTHER.
replace water=1 if (v409>=1 & v409<=7)

* IF GIVEN OTHER LIQUIDS
foreach xvar of varlist v409a v410 v410*  v413* {
replace liquids=1 if `xvar'>=1 & `xvar'<=7
}

cap replace liquids=1 if v412c>=1 & v412c<=7

* IF GIVEN POWDER/TINNED milk, FORMULA OR FRESH milk
foreach xvar of varlist v411 v411a v412 v414p {
replace milk=1 if `xvar'>=1 & `xvar'<=7
}

* IF STILL BREASTFEEDING
replace breast=1 if m4==95

* IF WAS EVER BOTTLE FED
replace bottle=1 if m38==1

*IF GIVEN ANY SOLID FOOD
foreach xvar of varlist v414* {
replace solids=1 if `xvar'>=1 & `xvar'<=7
}
replace solids=1 if v412a==1 | v412b==1

gen diet=7
replace diet=0 if water==0 & liquids==0 & milk==0 & solids==0
replace diet=1 if water==1 & liquids==0 & milk==0 & solids==0
replace diet=2 if            liquids==1 & milk==0 & solids==0
replace diet=3 if                         milk==1 & solids==0
replace diet=4 if                         milk==0 & solids==1
replace diet=5 if                         milk==1 & solids==1
replace diet=6 if breast==0

*diet=0: given only water (full bf)
*diet=1: given only liquids (bf & liquids)
*diet=2: given only milks (bf & milk)
*diet=3: given only solids (bf & solids)
*diet=4: given only milk and solids (bf & milk & solids)
*diet=5: not still breastfeeding (weaned)
*diet=6: not now being breastfed (m4~=95)

** Matching Table 11.3 for exclusive breast feeding in 0-5 month children **
gen ebf=0
replace ebf=1 if diet==0
ta ebf if age<6 [iw=v005/1000000]

```

Re: Calculating cases for IYCF [message #11422 is a reply to message #11421] Mon, 19 December 2016 09:43
 Roselync Messages: 13Registered: December 2016 Location: Taiwan Member
Dear Bridget,
Thank you so much for the response. Will work on the information you have given me and will give feedback once I come up with the results

Regards,
Rose
Re: Calculating cases for IYCF [message #11516 is a reply to message #11421] Fri, 06 January 2017 04:34
 Roselync Messages: 13Registered: December 2016 Location: Taiwan Member
Dear DHS team and colleagues,
I managed to find the exclusive breastfeeding rate that is similar to that of the Malawi DHS REPORT.However, am still finding challenges to find similar the predominant feeding rate and complementary feeding rate.my predominant feeding rate(0-5 months) was 75.64% and Malawi demographic health survey report rate is 77.5%.my complementary feeding rate(0-23months) is 22.15% and the rate in the report is 19%.i did the following to get the rates

following the previous given code
gen diet=7
replace diet=0 if water==0 & liquids==0 & milk==0 & solids==0
replace diet=1 if water==1 & liquids==0 & milk==0 & solids==0
replace diet=2 if liquids==1 & milk==0 & solids==0
replace diet=3 if milk==1 & solids==0
replace diet=4 if milk==0 & solids==1
replace diet=5 if milk==1 & solids==1
replace diet=6 if breast==0

*diet=0: given only water (full bf)
*diet=1: given only liquids (bf & liquids)
*diet=2: given only milks (bf & milk)
*diet=3: given only solids (bf & solids)
*diet=4: given only milk and solids (bf & milk & solids)
*diet=5: not still breastfeeding (weaned)
*diet=6: not now being breastfed (m4~=95)

*To calculate predominant breastfeeding rate
gen pred=0
replace pred=1 if diet==1
replace pred=1 if diet==0

*To calculate complementary feeding
gen comp=0
replace comp=1 if diet==2
replace comp=1 if diet==3
replace comp=1 if diet==4

Could anyone advise me on the above percentages, if the differences I have found are acceptable or not and also if I used the right syntax to calculate the variables for predominant feeding and complementary feeding. Your assistance will be highly appreciated.

Regards,
Rose

Re: Calculating cases for IYCF [message #11522 is a reply to message #11516] Sun, 08 January 2017 09:34
 Roselync Messages: 13Registered: December 2016 Location: Taiwan Member
Dear DHS team and colleagues,
I managed to find the exclusive breastfeeding rate of 71.4% which is similar to that of the 2010 Malawi DHS REPORT but surprisingly the denominator(0-5 months) is 1656 instead of 1698,i tried key in the codes that I was given previously several times using Stata but I keep getting the same denominator(1656) .Iam also still finding challenges to find the correct predominant feeding and complementary feeding rate estimate.my predominant feeding rate(0-5 months) was 75.64% and Malawi demographic health survey report rate is 77.5%.my complementary feeding rate (0-23months) is 22.15% and the rate in the report is 19%.I used every step of the code that I was previously given to get the EXCLUSIVE BREASTFEEDING rate(please find it below).I have also indicated how I got the predominant and complementary feeding rate.

** Exclusive breast feeding
use MWKR61FL.dta, clear

gen age=v008-b3

keep if b9==0

* finding the youngest child living with the mother for each mother
bysort v001 v002 v003: egen minbidx=min(bidx)
* keep only children less than 2 years
keep if age<24
* need to drop those that are bidx==2 and minbidx==1
drop if bidx>minbidx

gen water=0
gen liquids=0
gen milk=0
gen solids=0
gen breast=0
gen bottle=0

*TO DETERMINE IF CHILD IS GIVEN WATER, SUGAR WATER, JUICE, TEA OR OTHER.
replace water=1 if (v409>=1 & v409<=7)

* IF GIVEN OTHER LIQUIDS
foreach xvar of varlist v409a v410 v410* v413* {
replace liquids=1 if `xvar'>=1 & `xvar'<=7
}

cap replace liquids=1 if v412c>=1 & v412c<=7

* IF GIVEN POWDER/TINNED milk, FORMULA OR FRESH milk
foreach xvar of varlist v411 v411a v412 v414p {
replace milk=1 if `xvar'>=1 & `xvar'<=7
}

* IF STILL BREASTFEEDING
replace breast=1 if m4==95

* IF WAS EVER BOTTLE FED
replace bottle=1 if m38==1

*IF GIVEN ANY SOLID FOOD
foreach xvar of varlist v414* {
replace solids=1 if `xvar'>=1 & `xvar'<=7
}
replace solids=1 if v412a==1 | v412b==1

gen diet=7
replace diet=0 if water==0 & liquids==0 & milk==0 & solids==0
replace diet=1 if water==1 & liquids==0 & milk==0 & solids==0
replace diet=2 if liquids==1 & milk==0 & solids==0
replace diet=3 if milk==1 & solids==0
replace diet=4 if milk==0 & solids==1
replace diet=5 if milk==1 & solids==1
replace diet=6 if breast==0

*diet=0: given only water (full bf)
*diet=1: given only liquids (bf & liquids)
*diet=2: given only milks (bf & milk)
*diet=3: given only solids (bf & solids)
*diet=4: given only milk and solids (bf & milk & solids)
*diet=5: not still breastfeeding (weaned)
*diet=6: not now being breastfed (m4~=95)

** Matching Table 11.3 for exclusive breast feeding in 0-5 month children **
gen ebf=0
replace ebf=1 if diet==0
ta ebf if age<6 [iw=v005/1000000]

*To calculate predominant breastfeeding rate I used this code
gen pred=0
replace pred=1 if diet==1
replace pred=1 if diet==0

*To calculate complementary feeding
gen comp=0
replace comp=1 if diet==2
replace comp=1 if diet==3
replace comp=1 if diet==4

Could anyone please advise me on the above percentages, if the differences I have found are acceptable or not;also if I missed any step to calculate the variables for exclusive breastfeeding, predominant feeding and complementary feeding. Your assistance will be highly appreciated.

Regards,
Rose

Re: Calculating cases for IYCF [message #11531 is a reply to message #11522] Mon, 09 January 2017 09:04
 Bridgette-DHS Messages: 1086Registered: February 2013 Senior Member
Following is a response from DHS Senior Research Associate, Shireen Assaf:

After creating your water, liquid, milk and solid variables, please use the following code to match the report.

```gen feeding=1
replace feeding=2 if water==1
replace feeding=3 if liquids==1
replace feeding=4 if milk==1
replace feeding=5 if solids==1
replace feeding=0 if breast==0
label define feeding 0 "Not breastfeeding" 1 "exclusive breastfeeding" 2 "+Water" 3 "+Liquids" 4 "+Other Milk" 5 "+Solids"
label val feeding feeding

*complimentary feeding is category #5 (+solids) and this matches the report for this age group which is 19.1%
ta feeding if age<6 [iw=v005/1000000]

*creating the predominant breastfeeding variable.
recode feeding (0 4 5=0) (1/3=1), gen(predom)

*this matches the report of 77.5% for predominant breastfeeding
ta predom if age<6 [iw=v005/1000000]
```
Re: Calculating cases for IYCF [message #11532 is a reply to message #11531] Mon, 09 January 2017 09:19
 Roselync Messages: 13Registered: December 2016 Location: Taiwan Member
Dear Bridget,
Thank you so much for the response and assistance, will use the code as stated and will give feedback

Regards,
Rose
Re: Calculating cases for IYCF [message #11554 is a reply to message #11532] Tue, 10 January 2017 08:55
 Bridgette-DHS Messages: 1086Registered: February 2013 Senior Member
Following is an additional response from DHS Senior Research Associate, Shireen Assaf:

The denominator of 1656 is correct. In Table 11.3 this is the number of youngest children under age 2 (10th column), the 1698 is the number of all children under age 2 (12 column or last column). For matching the predominant feeding and complimentary feeding please use the provided code which creates the feeding variable and recodes this variable to obtain predominant feeding.
Re: Calculating cases for IYCF [message #11555 is a reply to message #11554] Tue, 10 January 2017 09:06
 Roselync Messages: 13Registered: December 2016 Location: Taiwan Member
Dear Bridget,
Thank you so much for the clarification, I have cross checked in the report, its clear now. For the predominant and complementary feeding I also managed to get the rate that matches with the report. Thank you so much for the assistance, I really appreciate.

Regards,
Rose
Re: Calculating cases for IYCF [message #12184 is a reply to message #11531] Thu, 06 April 2017 07:32
 Roselync Messages: 13Registered: December 2016 Location: Taiwan Member
Dear DHS team and colleagues,
I am trying to analyze data from the 2010 Malawi DHS using Stata and I am looking at the prevalence rate of child feeding practices like exclusive breastfeeding,predominant,early initiation of breast feeding, complementary feeding and bottle feeding which I managed to get through assistance rendered on this forum. To calculate predominant feeding and complementary feeding I was given the following syntax

gen feeding=1
replace feeding=2 if water==1
replace feeding=3 if liquids==1
replace feeding=4 if milk==1
replace feeding=5 if solids==1
replace feeding=0 if breast==0
label define feeding 0 "Not breastfeeding" 1 "exclusive breastfeeding" 2 "+Water" 3 "+Liquids" 4 "+Other Milk" 5 "+Solids"
label var feeding feeding

*complimentary feeding is category #5 (+solids) and this matches the report for this age group which is 19.1%
ta feeding if age<6 [iw=v005/1000000]

*creating the predominant breastfeeding variable.
recode feeding (0 4 5=0) (1/3=1), gen(predom)

*this matches the report of 77.5% for predominant breastfeeding
ta predom if age<6 [iw=v005/1000000]

Now I was wondering if it is also possible to extract bottle feeding for 0-5 months which is 1.9% from the same variable "FEEDING" regardless of the fact that bottle feeding already exists as a separate variable(m38). My main issue is I want to be able to get a total of 100 when I add up complementary feeding,exclusive,predominant and bottle-feeding for 0-5 months. Your favorable assistance will be highly appreciated.

Regards,
Rose
Re: Calculating cases for IYCF [message #12190 is a reply to message #12184] Thu, 06 April 2017 14:33
 Bridgette-DHS Messages: 1086Registered: February 2013 Senior Member

Following is a response from DHS Senior Research Associate, Shireen Assaf:

From what I understand from your question you would like to recode the feeding variable in a way that contains a category that is bottle feeding. However, none of the variables used to construct the feeding variable include the variable on whether the child was bottle fed or not. The feeding variable is only concerned with the types of food and not the mechanism the food was delivered. The closest thing I could think of was to recode it as follows:

recode feeding (0=0 "not breastfed") (1=1 ebf) (2/3=2 "liquid+water") (4=3 "other milk") (5=4 "complimentary feeding"), gen(feed2)

This would give you the categories of not-breastfed, exclusive breastfeeding, liquid+water, other milk, and complimentary feeding. Predominate feeding is the combination of ebf and liquid+water, so you could combine the categories 1 and 2 above if you are interested in having that category. Of course you could not have ebf and predominate breastfeeding as two separate categories since predominate breastfeeding includes the exclusive breastfeeding category. The "other milk" category can be the closest thing to bottle feeding perhaps, but I'm not sure about this. Here I am making the assumption that the children that are given other types of milk are given this milk through a bottle. However, really if you want to know about whether the child was bottle fed you need m38 but this would not be part of the feeding variable.

I guess my confusion is why you need this to total to 100, because the categories you mention are not mutually exclusive. For instance, bottle-feeding and predominant feeding may not separate as you could bottle feed the child with liquids other than milk.
Re: Calculating cases for IYCF [message #12199 is a reply to message #12190] Fri, 07 April 2017 11:01
 Roselync Messages: 13Registered: December 2016 Location: Taiwan Member
Dear Bridgette,
Thank you so much for your response. It has been helpful. The reason why I needed the practices to total to 100 is that, I understand that these breastfeeding practices were extracted from the same population. For example, if we try to look at bottle feeding,predominant,exclusive breastfeeding and complementary feeding for 0-5 months, we find that it was extracted from the same population of 1656 yet when we try to combine these practices the total is about 101.4.So I guess my confusion was if the 'other milk' category as well as some components of complementary feeding and predominant feeding be the closest thing to bottle feeding. So I just wanted to be sure before I run a logistic regression with bottle feeding which happens to be one of the main outcomes(dependent variable).

Thanks,
Rose
Re: Calculating cases for IYCF [message #12603 is a reply to message #11555] Wed, 21 June 2017 05:58
 adenikedegun Messages: 10Registered: June 2017 Location: nigeria Member
good day, i have read all the messages in the thread, but i still need some help please. i am working on exclusive and predominant breastfeeding using the 2003, 2008 and 2013 Nigerian DHS dataset.
firstly, i would like to clarify if it is alright to use the birth recode file, because i have seen that most people have been using the kids recode file.
secondly, i would like directions in SPSS as that is the software i know how to use. what i have done is not matching with the result in the NDHS report and i would be grateful if clarifications can be made.
using the 2013 birth recode file, I selected cases if b8 < 6 (because the population I am working with is babies less than 6 months)
next, I recoded into a different variable all the feeds given, for example if child was given plain water 0 = no, 1 and 8 = yes. original label in the dataset is 0= no, 1 = yes, 8 = dont know.
for EBF, I added those who were currently breastfeeding and had 0 in all the foods listed, I have a list of 21 foods (v409, v410, v411, v411A, v412A, v412C, v413, v414E, v414F, v414G, v414H, v414I, v414J, v414K, v414L, v414M, v414N, v414O, v414P, v414S, v414V)

I did not get the same result as in the report. I would like to know how to go about this.
Thanks so much
Re: Calculating cases for IYCF [message #12605 is a reply to message #12603] Wed, 21 June 2017 08:36
 Bridgette-DHS Messages: 1086Registered: February 2013 Senior Member
Following is a response from Senior DHS Stata Specialist, Tom Pullum:

The first problem I see is that b8 gives age in years, not months. In the surveys you are using, age 0-5 completed months is given by v008-b3<6. The SPSS code for EBF and partial BF is given in the attached text file. You may have to modify it slightly based on the specific codes in these surveys. You may also want to look at this: http://www.ghspjournal.org/content/2/3/355.full.
Let us know if you still cannot get a match. Good luck!
Re: Calculating cases for IYCF [message #12607 is a reply to message #12605] Wed, 21 June 2017 18:03
 adenikedegun Messages: 10Registered: June 2017 Location: nigeria Member
Thanks so much, this has been really helpful. I have run the syntax but I am getting values a little different from the NDHS report values, for example, I got a 17.2% for EBF, whereas the report states a 17.4% I would like to know if there's an explanation for this or if I'm not doing something right. Thanks

I have used HW1 as age in months and I got the same result as using v008-b3.

Re: Calculating cases for IYCF [message #12609 is a reply to message #12605] Thu, 22 June 2017 08:59
 adenikedegun Messages: 10Registered: June 2017 Location: nigeria Member
In calculating predominant breastfeeding rate, I got 69.4%, whereas the reports states 69%, please I want to be sure that it is just approximation issues before I continue.
In addition, I would also like to know if the syntax can be used to calculate EBF and PBF for the other years too, that is for 2003 and for 2008. Thanks for your help.
Re: Calculating cases for IYCF [message #12611 is a reply to message #12609] Thu, 22 June 2017 09:55
 Bridgette-DHS Messages: 1086Registered: February 2013 Senior Member

Following is a response from Senior DHS Stata Specialist, Tom Pullum:

Yes, we would consider that to be a match. The code should be basically the same for all surveys. The only thing that you need to check is the numbers and letters for the variables on liquids, etc. Please proceed and see whether you get a match for 2003 and 2008.

We don't have SPSS code for the other years. If necessary, I can send you the CSPro code which was used for those surveys. You would have to translate it to SPSS. You should be able to do that.
Re: Calculating cases for IYCF [message #12612 is a reply to message #12611] Thu, 22 June 2017 10:10
 Bridgette-DHS Messages: 1086Registered: February 2013 Senior Member

Another response from Senior DHS Stata Specialist, Tom Pullum:

Yes, hw1 is calculated as v008-b3. You can use that for completed months of age. For which survey did you get 17.2% instead of 17.4%?

Re: Calculating cases for IYCF [message #12614 is a reply to message #12611] Thu, 22 June 2017 10:42
 adenikedegun Messages: 10Registered: June 2017 Location: nigeria Member
Thanks so much, I'm happy that's a match. I will go ahead and try it for the previous years and give u a feedback. You could also kindly send me the codes, I dont know how to translate to SPSS, but i will find a way to and if I can't get around it, I will be sure to let you know. I am really very grateful for your help.

Re: Calculating cases for IYCF [message #12615 is a reply to message #12612] Thu, 22 June 2017 11:06
 adenikedegun Messages: 10Registered: June 2017 Location: nigeria Member
That was for the 2013 Nigerian DHS. Thanks
Re: Calculating cases for IYCF [message #12616 is a reply to message #12612] Thu, 22 June 2017 11:15
 adenikedegun Messages: 10Registered: June 2017 Location: nigeria Member
I mean that I got the 17.2% as the EBF prevalence for the year 2013, though the report states 17.4%. Thanks so much again.

Re: Calculating cases for IYCF [message #12617 is a reply to message #12616] Thu, 22 June 2017 14:50
 Bridgette-DHS Messages: 1086Registered: February 2013 Senior Member
We have sent a reply to the email address you registered on the Forum. Thanks for using DHS data.

Re: Calculating cases for IYCF [message #12632 is a reply to message #12611] Tue, 27 June 2017 08:09
 adenikedegun Messages: 10Registered: June 2017 Location: nigeria Member
Good day Sir/Ma,
I am extremely grateful for all the help. I was able to use the syntax sent to compute EBF and Predominant breastfeding (PBF) rates for the three years 2003, 2008 and 2013. I had to adjust the syntax to compute EBF and PBF for 2008 and 2003, as the variables were different for the two other years. I am using the Nigerian DHS dataset (birth recode files) and I got the following rates:
2003 - EBF 17.1%, PBF 52.9%
2008 - EBF 13%, PBF 43.1%
2013 - EBF 17.2%, PBF 69.9%

from the NDHS reports, the prevalences reported were:
2003 - EBF -17.2%, PBF 53%
2008 - EBF - 13.1%, PBF 43.6%
2013 - EBF - 17.4%, PBF - 69%

I would like to confirm again, that all these are taken as matches when compared to the reports.

My next dilemma now is can I merge all the 3 years (2003, 2008 and 2013) before commencing on further analysis? I ask these because the variables are different especially in 2003, where the variables regarding foods given to children less than 6 months are v469A, v46B....v469Y, whilst for 2008 and 2013, the variables are v409 ...v14

Lastly, I am a little confused with the Recode files. Please I would like to know if there is a specific recode file for each year. I have downloaded Recode2, Recode3, Recode4, Recode5 and Reecode6. I would like to be sure which recode is for which dataset.

Thanks again,

Re: Calculating cases for IYCF [message #12634 is a reply to message #12632] Tue, 27 June 2017 10:20
 Bridgette-DHS Messages: 1086Registered: February 2013 Senior Member
Following is a response from Senior DHS Stata Specialist, Tom Pullum:

Yes, we would agree that you have satisfactorily matched the reports. You are thinking of appending the files, not merging them. Apparently you want to combine the three surveys into a single file. I would not recommend that you combine into a single file unless you have a really good reason for doing that. As you note, if you do that, you have to switch to a common set of codes for all three surveys. If you proceed, there will be no alternative to doing your best to construct a common set of codes. This could be difficult or even impossible if the questionnaires were too different.

The names of the IR files for the 2003, 2008, and 2013 surveys are NGIR4B, NGIR53, and NGIR6A, respectively. You should only be using the 4B, 53, and 6A files.

Recoden refers to the recode structure that was used in the survey. If you look at column 4: Recode on the available datasets listing, you will see the "recode" that was used for each survey.

[Updated on: Tue, 27 June 2017 10:24]

Report message to a moderator

Re: Calculating cases for IYCF [message #12636 is a reply to message #12634] Tue, 27 June 2017 15:41
 adenikedegun Messages: 10Registered: June 2017 Location: nigeria Member
Wow, this has been really helpful. Thanks a great deal.