XLStransform2: XLS transform (non-EU)

In bowerth/stan: Structural Analysis

Description

XLS Questionnaire transformation (non-EU)

Usage

XLStransform2(cou = stop("'cou' needs to be specified"), isic = 4,
  append = FALSE, path = PATH.SP,
  folder = stop("'folder' needs to be specified"),
  file = stop("'file' needs to be specified"), prefix = "",
  nameyear = c(2000:2012), startRow = 14, startCol = 1, endCol = 11,
  colNames = c("ind", "PROD", "INTI", "VALU", "VALK", "CFCC", "CFCK", "NOPS",
  "OTXS", "LABR", "WAGE"))

Arguments

cou	a 3-digit country ISO code character string.
isic	industry classification to be used for the data output locacation.
append	a boolean expression if variables shall be added to those already present.
path	a character string specifying the search location.
folder	a character string specifying the containing folder.
file	a character string specifying the file name.
prefix	a character string specifying the sheet prefix.
nameyear	a numeric vector with years in worksheet names.
startRow	an integer specifying the first data row.
startCol	an integer specifying the first data column.
endCol	an integer specifying the last data column.
colNames	an integer with variable names.

Details

Transform non-EU Excel Questionnaire for loading in SAS.

Author(s)

OECD STAN

See Also

couLocate, ANA2XLS

Examples

cou <- "COL"
folder.file <- couLocate(cou = cou)[3,] # select the file here
folder <- as.character(folder.file[,1])
file <- as.character(folder.file[,2])
XLStransform2(cou="COL", isic = 3, folder=folder, file=file, prefix="3.1_", nameyear=c(2000:2011))
cou <- "MEX"
folder.file <- couLocate(cou = cou)[1,] # select the file here
folder <- as.character(folder.file[,1])
file <- as.character(folder.file[,2])
XLStransform2(cou="MEX", isic = 4, folder=folder, file=file, prefix="3.1 ", nameyear=c(2003:2012))

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