Proc Expand Help

mahler_ji — Tue, 15 Sep 2015 15:29:09 GMT

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

Re: Proc Expand Help

PGStats — Tue, 15 Sep 2015 17:27:07 GMT

How about, simply:

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

Re: Proc Expand Help

mahler_ji — Tue, 15 Sep 2015 17:39:29 GMT

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

topic Proc Expand Help in SAS Procedures

Proc Expand Help

Re: Proc Expand Help

Re: Proc Expand Help