In this post, I show a trick to do moving average calculation (can be extended to other operations requiring windowing functions) that is super fast.
Often, SAS analysts need to conduct moving average calculation and there are several options by the order of preference:
1. PROC EXPAND
2. DATA STEP
3. PROC SQL
Read more »