Child health data [message #19581] |
Wed, 15 July 2020 13:54  |
download1music
Messages: 1 Registered: July 2020
|
Member |
|
|
I have used the API to extract information on childhood illness - % children with ARI, Fever and Diarrhea, and % of children treated for the same.
I get 2 values for each survey/indicator/group combination. For example, in the Yemen 2013 survey, for % of children not treated for diarrhea, there are 2 values returned for each wealth quintile.
When referring to the original data, it appears that these 2 values correspond to children born in the past 3 years, and those born in the past 5 years. However, there is no way to distinguish or label this information in the dataset.
Do you have any suggestions for how to CONSISTENTLY capture only 1 of these 2 values for each country and indicator of interest? In other words, I want to be sure that I only keep the values corresponding to children born in the past 5 years.
Thank you
|
|
|
Re: Child health data [message #19583 is a reply to message #19581] |
Wed, 15 July 2020 14:42  |
Trevor-DHS
Messages: 805 Registered: January 2013
|
Senior Member |
|
|
In the data returned by the API there is a column labeled ByVariableLabel in which you can see the labels "Three years preceding the survey" or "Five year preceding the survey". You can select on that text. Alternatively, there is also a ByVariableID with values 14000 and 14001 respectively. You can also select on one of those codes. Either approach will work.
|
|
|