Description Usage Arguments Details Author(s) See Also Examples
XLS Questionnaire transformation (non-EU)
1 2 3 4 5 6 7 | 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"))
|
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. |
Transform non-EU Excel Questionnaire for loading in SAS.
OECD STAN
1 2 3 4 5 6 7 8 9 10 | 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))
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.