topic lag function in SAS Programming

lag function

GeorgeSAS — Fri, 14 Jul 2017 16:03:16 GMT

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 — Fri, 14 Jul 2017 16:07:34 GMT

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

Rwon — Fri, 14 Jul 2017 16:09:18 GMT

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

GeorgeSAS — Fri, 14 Jul 2017 18:22:45 GMT

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