Re: st: RE: mean and sd of lagged variables

["Ben Hoen" <bhoen@lbl.gov>]

Well Nick, you have blown right past my level of competency.  I could not
figure out how to execute a rolling command correctly.

I did get a manual mean and sd to work, but now I am curious about how to
use rolling, assuming that if I learn to use it for this purpose it will
have many other uses.

Here is the ado file that is producing what I want, manually

use http://www.stata-press.com/data/imeus/grunfeld,clear
keep if company==1
tsset year
g ml3i=(L3.invest + L2.invest + l1.invest)/3
g sdl3i= (((L3.invest-ml3i)^2 + (L2.invest-ml3i)^2 + ///
(L1.invest-ml3i)^2)/3)^.5
label var ml3i "ma lag3 of invest"
label var sdl3i "sd lag3 of invest"
list year invest ml3i sdl3i, sep(20)

And this was what I was working on with .rolling until I gave up:

rolling ml3ri=r(mean) sdl3ri=r(sd), window(3):summarize invest, detail
list year invest ml3ri sdl3ri, sep(20)

Can you see where my error(s) was(were)? Will the rolling command allow me
to add variables like .generate or .egen (the sample ado seemed to discard
the working data for new data - but again, maybe I was not getting it)?

I don't know what I would do without this list,

Ben

=============================================================
st: RE: mean and sd of lagged variables