Proc Expand Help

[mahler_ji]

Hello All,

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

etc.

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.

Thanks!!

John

[PGStats · Accepted solution]

How about, simply:

convert value=y / transformout=(movave 3 lag 1);

[mahler_ji]

Thank you very much!  Didn't know you could put those commands together like that!