I am trying to link the volume sold on a service to the price of it. However, the timing differs as the service gets paid months in advance. Consequently, a lag is required.
However, as my data on volume starts on Januar 2005 (first row), I need price data from 2004 (e.g. October 2004 for price and January 2005 for volume in case of a 3 months time lag).
I am thinking about creating a new variable (call it 3mLag or so), where I simply move the pricing data by 3 lines (copy paste) while putting in the missing data for 2004.
Is there probably a faster way that may help as my procedure is only simple in case of a small number of lags to be implemented?
Related Posts with Efficient lags? Is copy and paste better?
join month and day in a single date variableDear all, I have a variable that corresponds to month in the format "2012m1" and a variable that co…
Reshape long with multiple values in iHi all, I want to reshape my data from Code: * Example generated by -dataex-. For more info, type …
Correlation matrixHello, I would like to do the correlation matrix between variables P_1, P_5, P_10 P_15, F_1, F_5, F…
A small clarification!I produce here two codes with a slight difference that produce the same output. These codes are base…
Interpretation of testparm after missing F valuesHi all, After adding clustered standard errors to my probit model, the F values were missing. After…
Subscribe to:
Post Comments (Atom)
0 Response to Efficient lags? Is copy and paste better?
Post a Comment