09-15-2015 11:28 AM - edited 09-15-2015 11:29 AM
I am working with Proc Expand and have a quick question. I am pretty good wiht this procedure, but there is somemthing that I can't figure out.
I have data that takes the following form:
Obs ID Value:
1 1 3
2 1 4
3 1 6
4 1 1
5 1 3
6 1 2
7 1 5
8 1 5
9 1 9
10 1 2
and I want to get a backwards looking moving average that DOES NOT take into account the current observation. So, for example, if I wanted the the three obs backward moving average, I have been using TRANSFORMOUT = (movave 3) and then changing the obs value and remerging, but I want to be able to do that in one step in proc expand, so that I don't have to worry about data issues when remerging.
Ultimately, this is what i want:
The three day backward moving ave for obs 4 would be 13/3 and not 11/3. I hope that makes sense.
Need further help from the community? Please ask a new question.