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?
Reshaping data for tabplotArray Hello, How do I reshape the following data to be able to use the tabplot command? Basically I…
fractional probit with sample selection using CMPHello everyone! I am planning to run a fractional response model with sample selection. I wonder if …
How to drop duplicates under certain conditions for a subset of observations?Hi all, I am trying to drop duplicate observations under certain conditions. My data looks something…
command tabcount is unrecognizedHi everyone, I'm learning stata these days. I was trying to use tabcount but I get the following err…
Matrix not found error after just listing the matrixDear All, Sorry for a very lengthy post, but I am trying to explain the problem comprehensively. I a…
Subscribe to:
Post Comments (Atom)
0 Response to Efficient lags? Is copy and paste better?
Post a Comment