Import IMF DOTS Panel data into Stata

[Ram Regmi]

I have been working to prepare country panel data on IMF DOTS flow merging with WB GDP and Per capita GDP for the last 30 years. WB data are now prepared using WB page in Stata with ISO-3 country code. However, I could only download the same span of year data in EXCEL format turning difficult to merge with WB datasets.

Would be great if some of you can assist possible easier way to transfer IMF DOTS datasets from IMF's official webpage into ISO-3 country code into Stata long format.

Sincerely,

[Leonardo Guizzetti]

This is not my area at all, so I'm not familiar with these specific file formats or structures. You may have (at least) two options.

1) -search imf- shows a package -getdata- (-ssc describe getdata-) which purports to possibly do what you want. An extract of the package description:

...
getdata imports data from several SDMX Data providers (OECD,
      EUROSTAT, ECB, IMF, ILO, ...) in   raw, cross-sectional,
      time series or panel data structure using SDMX rest codes.
...

2) You can always import the Excel file(s) using -import excel- and then manipulate them within Stata.