BookmarkSubscribeRSS Feed
GeorgeSAS
Lapis Lazuli | Level 10

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!

3 REPLIES 3
art297
Opal | Level 21

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
Lapis Lazuli | Level 10
Thank you art, while this method still need to merge table.
Rwon
Obsidian | Level 7

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

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1044 views
  • 0 likes
  • 3 in conversation