The DHS Program User Forum: Application Programming Interface (API) » Maternal and child health indicators by background characteristics

Home » Dissemination and Capacity Strengthening » Application Programming Interface (API) » Maternal and child health indicators by background characteristics

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

Maternal and child health indicators by background characteristics [message #24367]

Mon, 02 May 2022 19:03

DHSuser_NY
Messages: 8
Registered: November 2019

Member

Hi,

Does anyone know if API can generate MCH indicators by background characteristics? I have specified background= all, but the code below only gives me totals for births in the past 2,3 or 5 years. Below is a frequency of the byvariableid. Thanks for your help.

import delimited using ///
" http://api.dhsprogram.com/rest/dhs/data?surveyYearStart=2006 &surveyYearEnd=2010&breakdown=all&indicatorIds=M L_IPTP_W_2SA,ML_IPTP_W_3SA,RH_ANCT_W_TL4,HA_CATH_W_NRS,HA_CA TH_W_ATR,HA_CATH_W_ATN&&scl=1000,3001,3002,4000,4001 ,4002,4003,5001,5002&selectSurveys=latest&returnfiel ds=surveyId,DHS_CountryCode,CountryName,SurveyYear,SurveyYea rLabel,SurveyType,FieldworkStart,FieldworkEnd,indicator,Indi catorID,value,IndicatorData,Footnotes,ByVariableId,shortname &f=csv", clear

ByVariableI |
d | Freq. Percent Cum.
------------+-----------------------------------
0 | 473 49.22 49.22
14000 | 163 16.96 66.18
14001 | 164 17.07 83.25
14002 | 161 16.75 100.00
------------+-----------------------------------
Total | 961 100.00

Report message to a moderator

Re: Maternal and child health indicators by background characteristics [message #24368 is a reply to message #24367]

Mon, 02 May 2022 21:56

Trevor-DHS
Messages: 803
Registered: January 2013

Senior Member

You didn't include the background characteristics in the return fields list, so you can't tell which record is which characteristic.
In the example attached I remove the returnfield list so that all columns are returned and you can see the characteristics.

Attachment: test.do
(Size: 0.25KB, Downloaded 285 times)

Report message to a moderator

Re: Maternal and child health indicators by background characteristics [message #24370 is a reply to message #24368]

Tue, 03 May 2022 08:52

DHSuser_NY
Messages: 8
Registered: November 2019

Member

Hi Trevor,

I see. This is a huge help!

Many thanks,
Suzette

Report message to a moderator

Previous Topic:	Source of contraception by method
Next Topic:	Fetching a specific recode data file from API

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Nov 25 14:47:12 Coordinated Universal Time 2024