DataCombine (version 0.1.13)

slide: A function for creating lag and lead variables, including for time-series cross-sectional data.

Description

The function slides a column up or down to create lag or lead variables. If GroupVar is specified it will slide Var for each group. This is important for time-series cross-section data. The slid data is placed in a new variable in the original data frame. Note: your data needs to be sorted by date. The date should be ascending (i.e. increasing as it moves down the rows). Also, the time difference between rows should be constant, e.g. days, months, years.

Usage

slide(data, Var, GroupVar = NULL, NewVar = NULL, slideBy = -1)

Arguments

data

a data frame object.

Var

a character string naming the variable you would like to slide (create lag or lead).

GroupVar

a character string naming the variable grouping the units within which Var will be slid. If GroupVar = NULL then the whole variable is slid up or down. This is similar to shift

NewVar

a character string specifying the name for the new variable to place the slid data in.

slideBy

numeric value specifying how many rows (time units) to shift the data by. Negative values slide the data down--lag the data. Positive values shift the data up--lead the data.

Value

• a data frame

source

Partially based on TszKin Julian's shift function: http://ctszkin.com/2012/03/11/generating-a-laglead-variables/

Details

slide a function for creating lag and lead variables, including for time-series cross-sectional data.

See Also

shift, ddply

Examples

# Create dummy data
 A <- B <- C <- 1:20
 ID <- sort(rep(seq(1:4), 5))
 Data <- data.frame(ID, A, B, C)

 # Lead the variable by two time units
 DataSlid1 <- slide(Data, Var = "A", NewVar = "ALag", slideBy = 2)

 # Lag the variable one time unit by ID group
 DataSlid2 <- slide(data = Data, Var = "B", GroupVar = "ID",
                NewVar = "BLag", slideBy = -1)