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?
Gen date variable with missing valuesHi, i want to loop to convert my strings data date starting by "d" into date format. But I have vari…
Wild bootstrap Fixed and Random effects model.Dear Statalist, The topic of my thesis is "How firm specific characteristics affect a firm's Cash ho…
Growth model - No convergenceI would like to develop a latent growth model (LGM) with Stata. The point is to illustrate estimated…
Query on Appending two datasets.Hi everyone, Im trying to append two datasets of different versions together. The variable names ac…
Trial FriI am looking for guidance on interpreting my results from running a rsktest. Below are my results wh…
Subscribe to:
Post Comments (Atom)
0 Response to Efficient lags? Is copy and paste better?
Post a Comment