There are two main possibilities to lead or lag a time series.
1. The Lag analysis:
Set the direction as “Method” and length as “Base”.
NOTE: “Lead” moves values backwards in time, while “Lag” moves values forward.
You can also use the formula:
- The function returns the series lagged by the number of observations specified with the variable “Length”. The “Length” variable is rounded to an integer.
This will move the series 2 observations backward (meaning “Lead”).
This will move the series 1 year forward (meaning “Lag”).