How to get rolling average

[lizzy28]

Hi everyone,

This may be a simple question. I am trying to get a rolling average, that is, average of a number of observations vertically. Please see the excel file as attached. Col C: avg_roll is my target field to get from Col B: volume.

Thank you!

Lizi

[Reeza · Accepted solution]

http://support.sas.com/kb/25/027.html

https://communities.sas.com/t5/General-SAS-Programming/Array-subscript-out-of-range-question/m-p/168...