lag function

[GeorgeSAS]

Hello everyone,

Is there a lag like function can get reversed lag without merging tables?

currently we have lag1(var),lag2(var).......,can we do something like lag(var,-1),lag(var,-2)......? this avoid merge tables.

Thanks!

[art297]

If by reverse lag you mean look ahead, I don't think so. But it's quite easy, see: http://www.sascommunity.org/wiki/Look-Ahead_and_Look-Back

Art, CEO, AnalystFinder.com

[GeorgeSAS]

Thank you art, while this method still need to merge table.

[Rwon]

If you are able, you could sort in the reverse way and use the lag function to get the "reverse" lag.