dotstatGetData: Access .Stat SQL

In bowerth/stan: Structural Analysis

Description

Use stored procedures to retrieve from OECD.Stat

dotStatGetDimensionList: Retrieve dimensions of dataset.

dotStatGetDimensionMemberList: Retrieve dimension members of dataset.

Usage

dotstatGetData(channel, datasetcode, dim.list, time)

dotStatGetDimensionList(channel, datasetcode, lang)

dotStatGetDimensionMemberList(dim, channel, datasetcode, lang)

Arguments

channel	open SQL channel created with odbcDriverConnect
datasetcode	character code of dataset
dim.list	named list with character vector for each dimension in dataset
time	integer vector with start and end year
lang	character en or fr
dim	character to specify dimension

Details

dotStatGetData : retrieve data based on dimension member list

dotStatGetDimensionList(channel, datasetcode, lang)

dotStatGetDimensionMemberList(dim, channel, datasetcode, lang)

Author(s)

OECD STAN

Examples

## create the dimension list with members - order of dimensions as in dataset
dim.list.test <- list(LOCATION=c("AUT", "BEL"),
                      VAR=c("PROD", "VALU"),
                      ISIC4=c("05_09", "10_33"),
                      SRC=c("SSIS"),
                      ## SRC=c(""),
                      SCL=c("TOTAL"))
## retrieve data according to selected dimension member selection
data.test <- dotstatGetData(channel = SQL.STAT,
                            datasetcode = "SSIS_BSC_ISIC4",
                            dim.list = dim.list.test,
                            time = c(2007, 2008))
namedim <- dotStatGetDimensionList(channel = SQL.STAT,
                                   datasetcode = "SSIS_BSC_ISIC4",
                                   lang = "en")
## for a single dimension
dotStatGetDimensionMemberList(dim = "LOCATION",
                              channel = SQL.STAT,
                              datasetcode = "SSIS_BSC_ISIC4",
                              lang = "en")
## for multiple dimensions
namedim <- c("LOCATION", "VAR")
dim.list <- lapply(namedim, dotStatGetDimensionMemberList,
                   channel = SQL.STAT,
                   datasetcode = "SSIS_BSC_ISIC4",
                   lang = "en")
names(dim.list) <- namedim

bowerth/stan documentation built on May 13, 2019, 12:38 a.m.