LogoLogo
Data CataloguePacificMapPDH.statMicrodata Library
  • Pacific Data Hub
    • Change Log
  • Data Catalogue
    • User Guide
      • Creating a new account
    • Advanced Search
      • Solr Search Queries
    • API
  • PacificMap
    • User Guide
  • PDH.stat
    • Data Explorer
    • Plugins
      • Excel
      • Power BI
      • R
      • Python
      • STATA
    • API
      • Interface
      • Use cases
      • Sample code
  • Microdata Library
    • User Guide
Powered by GitBook
On this page
  • STATA
  • sdmxpdh
  • Installation
  • Quick start

Was this helpful?

Export as PDF
  1. PDH.stat
  2. Plugins

STATA

Connect STATA to PDH.stat with sdmxpdh

PreviousPythonNextAPI

Last updated 4 years ago

Was this helpful?

STATA

sdmxpdh

Full credit goes to Sebastien Fontenay, Robert Picard, Nicholas Cox.

This module is a simple adaptation of the SDMXUSE module (Fontenay), which itself uses the MOSS module (Picard & Cox).

Sebastien Fontenay, 2016. "SDMXUSE: Stata module to import data from statistical agencies using the SDMX standard," Statistical Software Components S458231, Boston College Department of Economics, revised 30 Sep 2018.

Robert Picard & Nicholas J. Cox, 2011. "MOSS: Stata module to find multiple occurrences of substrings," Statistical Software Components S457261, Boston College Department of Economics, revised 29 Apr 2016.

Installation

Instructions work for Stata SE 15.1 in Windows

In Stata, find your "PERSONAL" directory path with the command: sysdir

In Windows, go to the "PERSONAL" directory location. It is probably C:\ado\personal\. If the path doesn't seem to exist, make the necessary folders yourself.

Put .ado and .sthlp files inside your "PERSONAL" directory.

Restart Stata.

Check the install worked by bringing up the SDMXPDH help document: help sdmxpdh

Quick start

PDH.stat resources are maintained by SPC (Pacific Community), so SPC is the provider for resources.

General command structure is: sdmxpdh <resource> <provider>, <filters>

See all dataflows from Pacific Data Hub

sdmxpdh dataflow SPC, clear
list

Get all data for a dataflow

For example, use dataflow DF_CPI (Consumer Price Index)

sdmxpdh data SPC, clear dataset(DF_CPI)
list

Get specific data for a dataflow

This time, we want DF_CPI time series data from 2005 to 2018, for countries Fiji and Guam.

sdmxpdh data SPC, clear dataset(DF_CPI) dimensions(A.FJ+GU.INF.) start(2005) end(2018) timeseries
list

Get a datastructure definition for a dataflow

Again, let's use DF_CPI.

sdmxpdh datastructure SPC, clear dataset(DF_CPI)
list

SDMXPDH is a version of the SDMXUSE Stata module, with the changes allowing users to connect to Pacific Data Hub .Stat API (PDH.stat). See the code .

Download .ado and .sthlp files from the Github repository .

Using the dimensions() option is tricky, see the API for a guide.

here
here
documentation