Description Usage Arguments Details Author(s) See Also Examples
Apply industry conversion based on calculation formula
1 2 3 |
data |
data in wide format with industries in columns. |
formula |
data frame with "ind" and "formula" column. |
id.vars |
character vector to specify preserved columns. |
Uses a data frame containing formulas to convert industry classification.
OECD STAN
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | require(reshape2)
require(stanData)
data(STANNAi4)
cou <- "AUT"
var <- "VALU"
data <- DATA.STAN
data <- data[data$cou%in%cou &
data$var%in%var,]
data <- dcast(data, cou + var + year ~ ind, value.var = "value")
file <- paste0(PATH.SASi4, "Lists\\MDL_STAN_i4_i3_A64.txt")
line.remove <- c("/* aggregate */")
formula <- SASformula(file=file, line.remove=line.remove)
data <- calcFormula(data=data, formula=formula, id.vars=id.vars)
data <- melt(data, id.vars = id.vars, variable.name = "ind", na.rm = TRUE)
data <- subset(data, select = c("cou", "var", "ind", "year", "value"))
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.