| Re: Child's dietary history [message #9946 is a reply to message #9826] |
Tue, 07 June 2016 18:23  |
Trevor-DHS
Messages: 800
Registered: January 2013
|
Senior Member |
|
|
All of the missing data that you are seeing is related to the structure of the questionnaire used at the time of the Guinea 2005 survey. in this survey women are asked if they gave children each type of food in the past 7 days, and if they gave the food in the past 7 days then whether they gave the child the food in the past 24 hours. If they did not give the child the food in the past 7 days or the response was missing, then there is no valid response in the question on the last 24 hours.
You may want to look at variables M37A-X (last 24 hours) and M40A-X (last 7 days). For example, if you compare M37C with V469C for the selected cases you will see that they are identical. If you then crosstab M37C (or V469C) with M40C you will see that the cases that are codes 0 or 9 on M40C are the one that are not valid on M37C and V649C.
Also note that your selection criteria is not quite correct. You need to select the youngest child living with the mother. You have always selected the last born child (bidx=1), but this child is not the youngest child living with the mother if the last born child does not live with the mother or is dead. You need to first sort the data according to the ID fields v001, v002, v003, bidx (the file may be sorted already) and then use the following condition:
COMPUTE filter_$=(HW1>=6 AND HW1<24 AND b5=1 and b9=0 and lag(caseid)<>caseid).
Using the lag function ensures that only the last child living with the mother is selected.
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
