The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Bangladesh » Creating Nutritional intake
Creating Nutritional intake [message #14204] Sun, 04 March 2018 07:29 Go to next message
anikhpg42@gmail.com is currently offline  anikhpg42@gmail.com
Messages: 38
Registered: December 2017
Location: Bangladesh
Member

Hi,

In BDKR14 database, I want to create a new variable named "Nutritious food given to child" by combining 12 binary variables. What can
I do in the next level? I have done recoding upto the following commands,

******Foods given to the child
*Plain water
recode v409 (0 = 0 "No") (1 = 1 "Yes"), gen(water)
label variable water "Plain water"
label values water water
ta water

*juice
recode v410 (0 8 = 0 "No") (1 = 1 "Yes"), gen(juice)
label variable juice "juice"
label values juice juice
ta juice

*Tinned/powdered milk
recode v411 (0 8 = 0 "No") (1 = 1 "Yes"), gen(tmilk)
label variable tmilk "Tinned/powdered milk"
label values tmilk tmilk
ta tmilk

*Baby formula
recode v411a (0 = 0 "No") (1 = 1 "Yes"), gen(bf)
label variable bf "Baby formula"
label values bf bf
ta bf

*Bread, noodles & other foods from grains
recode v414e (0 = 0 "No") (1 = 1 "Yes"), gen(grains)
label variable grains "Bread, noodles & other foods from grains"
label values grains grains
ta grains

*Potatoes, cassava or other tubers
recode v414f (0 = 0 "No") (1 = 1 "Yes"), gen(tubers)
label variable tubers "Potatoes, cassava or other tubers"
label values tubers tubers
ta tubers

*Eggs
recode v414g (0 = 0 "No") (1 = 1 "Yes"), gen(eggs)
label variable eggs "Eggs"
label values eggs eggs
ta eggs

*Meat
recode v414h (0 8 = 0 "No") (1 = 1 "Yes"), gen(meat)
label variable meat "Meat"
label values meat meat
ta meat

*Pumpkin, carrots or squash
recode v414i (0 = 0 "No") (1 = 1 "Yes"), gen(pumpkin)
label variable pumpkin "Pumpkin, carrots or squash"
label values pumpkin pumpkin
ta pumpkin

*Mangoes, papayas, other vitamin a fruits
recode v414k (0 = 0 "No") (1 = 1 "Yes"), gen(fruits)
label variable fruits "Mangoes, papayas, other vitamin a fruits"
label values fruits fruits
ta fruits

*Mineral rich foods
recode v414m (0 8 = 0 "No") (1 = 1 "Yes"), gen(mineral)
label variable mineral "Mineral rich foods"
label values mineral mineral
ta mineral

*Fish
recode v414n (0 8 = 0 "No") (1 = 1 "Yes"), gen(fish)
label variable fish "Fish"
label values fish fish
ta fish


What should be the next commands to create a binary variable named "Nutritious food given to child" (Given properly, Not given properly) by combining
these 12 variables.?
Can anyone help me?

Thank you very much.


ASIBUL ISLAM ANIK
Re: Creating Nutritional intake [message #14306 is a reply to message #14204] Tue, 20 March 2018 17:09 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 DHS Technical Specialist, Rukundo Benedict:

Thanks for your question. It would be good the know the context in which you plan to use this variable as this is not a standard WHO IYCF variable. What does the "nutritious food given to child" variable mean? It seems like you are trying to create a variable similar to the minimum dietary diversity (MDD). I would refer you to this post as it walks through how to create the MDD. It will also give you an example of code for how to create the "nutritious food given to child" binary variable if you decide that is what you want to do.

Re: Creating Nutritional intake [message #14309 is a reply to message #14306] Wed, 21 March 2018 04:17 Go to previous messageGo to next message
anikhpg42@gmail.com is currently offline  anikhpg42@gmail.com
Messages: 38
Registered: December 2017
Location: Bangladesh
Member

Thank you very much for understanding this.
Exactly this was what I needed to know.
Will you please help me to recode the variable in binary format?

Minimum dietary diversity couldn't be found in BDHSKR 2014 database. Now what can I do?


ASIBUL ISLAM ANIK
Re: Creating Nutritional intake [message #14320 is a reply to message #14309] Thu, 22 March 2018 12:10 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 DHS Technical Specialist, Rukundo Benedict:

Stata code for calculating Minimum Dietary Diversity using the BDHS 2014 can be found here: https://userforum.dhsprogram.com/index.php?t=msg&th=5461 &goto=10727&S=Google. Once you have generated the food groups the last few lines generate the binary variable for MDD.

Re: Creating Nutritional intake [message #14687 is a reply to message #14320] Mon, 30 April 2018 03:04 Go to previous messageGo to next message
Hassen
Messages: 121
Registered: April 2018
Location: Ethiopia,Africa
Senior Member
Dear DHS Experts, How can I construct Minimum Dietary Diversity Score from KR file Using SPSS command? Sorry I am a fresh DHS User.
Thank you in advance!!


Hassen Ali(Chief Public Health Professional Specialist)
Re: Creating Nutritional intake [message #14753 is a reply to message #14687] Thu, 03 May 2018 14:58 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3013
Registered: February 2013
Senior Member
Following is a response from DHS Technical Specialist, Rukundo Benedict:

Here is SPSS code geared towards reproducing the table.

*// [ Opening women's data file  ] **.
GET FILE=!DatPath+!IRDataF.

*// Age cut off. 
Compute Cutoff = 24.

*// VECTOR command to find the last child, the age and living status .
VECTOR B3 = B3$01 to B3$06
              /B9 = B9$01 to B9$06
              /B4 = B4$01 to B4$06
              /M4 = M4$1 to M4$6
              /M39 = M39$1 to M39$6.
LOOP i = 1 to 6.
+  DO IF (  (V008 - B3(i)  < CutOff) & B9(i)=0 ).
+     COMPUTE Months = V008 - B3(i).
*/ Sex .
+    COMPUTE ChldSex = B4(i).
*/ No breastfeeding.
+     COMPUTE BreastFg = 2.
*/ Currently breastfeeding .
+     IF ( M4(i) = 95 ) BreastFg = 1.
*// Amount of solid and semisolid.
+     COMPUTE M39w = M39(i).
*// if last child found, break the loop .
+     BREAK.
+  END IF.
END LOOP.

*// Selecting only mother with children 6-23m.
SELECT IF ( Months >= 6 & Months <= 23).

*// Weighting table.
COMPUTE rweight = V005 / 1000000.
WEIGHT BY rweight.

*// age of the child (First row variable)..
RECODE Months (0,1 = 1) (2,3 = 2) (4,5=3) (6,7,8=4) (9 thru 11 = 5) (12 thru 17=6) (18 thru 23=7) INTO ChAge.
VARIABLE LABELS ChAge "Age".
VALUE LABELS ChAge 1"0-1" 2"2-3" 3"4-5" 4"6-8" 5"9-11" 6"12-17" 7"18-23".


*// Milk group.
COUNT GroupA = V411 V411A V414V V414P (1).
IF ( GroupA > 0) GroupA = 1.
*// Grains / roots / tubers group.
COUNT GroupB = V412A V414E V414F (1).
IF ( GroupB > 0) GroupB = 1.
*// vitamin A rich fruits and vegetables.
COUNT GroupC = V414I V414J V414K (1).
IF ( GroupC > 0) GroupC = 1.
*// other fruits and vegetables group.
COUNT GroupD = V414L (1).
*// Eggs group.
COUNT GroupE = V414G (1).
*// meat, poultry, fish groups.
COUNT GroupF = V414M V414H V414N (1).
IF ( GroupF > 0) GroupF = 1.
*// legumes and nuts.
COUNT GroupG = V414O (1).
*// All groups.
COMPUTE AllGrps = ( GroupA +  GroupB + GroupC + GroupD + GroupE + GroupF + GroupG).
*// All groups excluding milk group.
COMPUTE AllGrps1 = (  GroupB + GroupC + GroupD + GroupE + GroupF + GroupG).

*// Total milk food.
COMPUTE TotMilk = 0.
IF ( V469E > 0 & V469E <= 7) TotMilk = TotMilk + V469E.
IF ( V469F > 0 & V469F <= 7) TotMilk = TotMilk + V469F.
IF ( V469X > 0 & V469X <= 7) TotMilk = TotMilk + V469X.
*// define minimum feeding times for breastfeed children .
COMPUTE MinFeed = 0.
IF ( BreastFg = 1 & Months >= 6 & Months <= 8   & m39w >= 2 & m39w <= 7) MinFeed = 1.
IF ( BreastFg = 1 & Months >= 9 & Months <= 23 & m39w >= 3 & m39w <= 7) MinFeed = 1.
*// define mimum feedings for none-breasfeeding children .
COMPUTE  Feedings = TotMilk.
IF ( m39w > 0 & m39w <= 7) Feedings = Feedings + m39w.
IF ( BreastFg = 2 & Feedings >= 4 ) MinFeed1 = 1.

*// Column1: 4+ food groups .
IF ( BreastFg = 1 & AllGrps >= 4 ) Coln01 = 1.
VARIABLE LABELS Coln01 "4+ food groups 1".
*// Column2: 4Minimum meal frequency .
IF ( BreastFg = 1 & MinFeed = 1 ) Coln02 = 1.
VARIABLE LABELS Coln02 "Minimum meal frequency 2".
*// Column 3: both 4+ & minimum times.
IF ( BreastFg = 1 & AllGrps >= 4 & Minfeed = 1) Coln03 = 1.
VARIABLE LABELS Coln03 "Both 4+ food groups and mini-mum meal frequency".
*// Column 4: Number of breast-fed children 6-23 months.
IF ( BreastFg = 1 & Months >= 6 & Months <= 23 ) Age623a = 1.
VARIABLE LABELS Age623a "".
VALUE LABELS Age623a 1"Number of breastfed children 6-23 months".
*// Label to be nested for breastfeeding children 6-23 months.
IF ( BreastFg = 1 & Months >= 6 & Months <= 23 ) Label1 = 1.
VARIABLE LABELS Label1 "".
VALUE LABELS Label1 1"Among breastfed children 6-23 months, percentage fed:".

*// Column 5: milk or milk products given 2+ times .
IF ( BreastFg = 2 & TotMilk >= 2 ) Coln05 = 1.
VARIABLE LABELS Coln05 "Milk or milk products 3".
*// Column 6: 4+ food groups  .
IF ( BreastFg = 2 & AllGrps >= 4 ) Coln06 = 1.
VARIABLE LABELS Coln06 "4+ food groups 1".
*// Column 7: Minimum meal frequency .
IF ( BreastFg = 2 & MinFeed1 = 1 ) Coln07 = 1.
VARIABLE LABELS Coln07 "Minimum meal frequency 4".
*// Column 8:  with 3 appropriate IYCF practices  .
IF ( BreastFg = 2 & AllGrps1 >= 4 & Totmilk >= 2 & MinFeed1 = 1 ) Coln08 = 1.
VARIABLE LABELS Coln08 "With 3 IYCF practices 5".
*// Column 9: Number of non-breast-fed children 6-23 months.
IF ( BreastFg = 2 ) Age623b = 1.
VARIABLE LABELS Age623b "".
VALUE LABELS Age623b 1"Number of non-breastfed children 6-23 months".
*// Label to be nested for breastfeeding children 6-23 months.
IF ( BreastFg = 2 & Months >= 6 & Months <= 23 ) Label2 = 1.
VARIABLE LABELS Label2 "".
VALUE LABELS Label2 1"Among non-breastfed children 6-23 months, percentage fed:".

*// Column 10: breastmilk or milk products given 2+ times .
IF ( BreastFg = 1 | TotMilk >= 2 ) Coln10 = 1.
VARIABLE LABELS Coln10 "Breast milk, milk or milk products 6".
*// Column 11: 4+ food groups  .
IF ( AllGrps >= 4 ) Coln11 = 1.
VARIABLE LABELS Coln11 "4+ food groups 1".
*// Column 11: Minimum meal frequency (minimum times or more for breafeeding and none-breastfeeding ).
IF ( MinFeed = 1 | MinFeed1 = 1) Coln12 = 1.
VARIABLE LABELS Coln12 "Minimum meal frequency 7".
*// Column 12:  with 3 appropriate IYCF practices  .
IF (coln03 = 1  | Coln08 = 1  ) Coln13 = 1.
VARIABLE LABELS Coln13 "With 3 IYCF practices".
*// Column 12: Number of children 6-23 months.
IF ( Months >= 6 & Months <= 23 ) Age623c = 1.
VARIABLE LABELS Age623c "".
VALUE LABELS Age623c 1"Number of children 6-23 months".
Previous Topic: BDHS2014-bdkr data set- Children nutrition- table 11.6 in BDHS report, 4+food group
Next Topic: child mortality rate per women's empowerment indicator
Goto Forum:
  


Current Time: Tue Mar 19 00:16:46 Coordinated Universal Time 2024