wbopendata Multiple Indicators

[Laura Martin]

Hi All,

I am currently trying to download multiple indicators onto STATA from wbopendata,
Currently I am typing :

"wbopendata, indicator (NV.SRV.TETC.ZS;NV.IND.TOTL.ZS;NY.GDP.MKTP.KD.ZS;N Y.GDP.PCAP.KD.ZG;NV.AGR.TOTL.ZS;NV.IND.MANF.KD.ZG) long clear"

STATA is only downloading the first indicator and returns the following message:

"file __000002 could not be opened

Sorry... No metadata was downloaded for
NV.SRV.TETC.ZS;NV.IND.TOTL.ZS;NY.GDP.MKTP.KD.ZS;NY .GDP.PCAP.KD.ZG;NV.AGR.TOTL.ZS;NV.IND.MANF.KD.ZG."

I have tried the command both with and without spaces after the ; but still no luck either way.

Can anybody help here? I'm a bit of a beginner here so any help appreciated

Thanks!

[William Lisowski]

Welcome to Statalist.

I do not understand the exact error message you are seeing.

The best approach to debugging a problem like this is to try each indicator separately. When I do that, the first two work successfully, but the third one tells me the following.

. wbopendata, indicator (NY.GDP.MKTP.KD.ZS) long clear

    Sorry... No data was downloaded for indicator NY.GDP.MKTP.KD.ZS.

    (1) Please check your internet connection by clicking here, if does not work please check
    with your internet provider or IT support, otherwise...
    (2) Please check your access to the World Bank API by clicking here, if does not work
    please check with your firewall settings or internet provider or IT support, otherwise...
    (3) Please check the availability of your indicator or topic by clicking here. If the
    paramater value is not valid...
    (4) Please check the list of available indictator(s) or topic(s) in the help wbopendata or
    by visiting the API query builder, if all the above seems fine...
    (5) Please consider ajusting your Stata timeout parameters. For more details see netio.
    (6) Please send us an email to report this error by clicking here or writing to:
            email: [email protected]
            subject: wbopendata query error 20 at 24 Jan 2019 09:59:17:
    http://api.worldbank.org/en/countries/all/Indicators/NY.GDP.MKTP.KD.ZS?date=&

So I follow (4) by looking at the output of help wbopendata and see

indicator(string)   Indicators List list of indicator codes (All series). When selecting
                    multiple indicators please use semicolon (;), to separate differenet
                    indicatos.

and I note that Indicators List is a clickable link. Clicking on it and scrolling and scrolling and scrolling eventually takes me to the section for indicators beginning NY, and scrolling further I see the only two lines for NY.GDP.MKTP.KD

      NY.GDP.MKTP.KD                    GDP at market prices (constant 2005 US$)
      NY.GDP.MKTP.KD.ZG                 GDP growth (annual %)

neither of which is the indicator that failed. So in this case we see than an indicator was misspecified.

I'm not certain that the code you provided was actually the code you ran, because there's a space in the list that doesn't belong there. But this general approach will help you narrow down the problem.