Good morning
I am trying to solve an issue with a big dataset (unbalanced panel with several missing data).
The task is quite easy, but the dimension of the panel require an automated routine.
Briefly speaking, I need to calculate a moving average of a variable including 3 lags and the current value.
I find that the command
tssmooth ma movaverage = targetvariable, window(3 1)
works fine, since it manages very well the missing values but it has a drawback; it provides values for each year, including the first three ones.
However, I expect (need) three missing values at the beginning of each time series, since only in year 4 the average can be properly calculated.
Some Statalist posts suggest to use the
(L3.var + L2.var + L1.var + var)/4
strategy, but I guess that missing data create several problems here.
Is there a better strategy to manage the issue?
Thanks again as usual for your insightful comments
Simone
Related Posts with Moving average for panel data with missing values
quietly globalRunning a loop in Stata...I often put quietly before several commands. Is there a way to suppress ou…
Selection of appropriate test for pre/post intervention (single arm) with repeated measures - Is the Mixed Linear Model most appropriate?Hello Stata Forum, I hope you all are doing well! I wanted to clarify my utilization of the mixed …
error with GLM modeling costs and obtaining predicted means.Hello . I am modeling costs and have balanced covariates using ebalance. The glm runs but when I cal…
Saving a Matrix from the Predict CommandI'm interested in saving a matrix generated by Mark Schaffer 's cvlasso from lassopack so that I may…
Accessing estadd ysumm estimates from .ster file and exporting to excelHello! I am attempting to access the regression estimates I have stored in a stata .ster file and ex…
Subscribe to:
Post Comments (Atom)
0 Response to Moving average for panel data with missing values
Post a Comment