topic Re: Opposite of Lag function in SAS Programming

Opposite of Lag function

SASdevAnneMarie — Thu, 17 Sep 2020 10:22:16 GMT

Hello Experts,
Do you know please if there is the opposite of LAG function?
I need to create a new column with the next value in my column.
Thank you very much!

Re: Opposite of Lag function

Rick_SAS — Thu, 17 Sep 2020 10:40:16 GMT

The "opposite of LAG" function is often called a LEAD function. It is not natively implemented in the SAS DATA step, but you can perform some tricks to emulate the behavior. These notes should get you started in the right direction:

Create the equivalent of a LEAD function by using the POINT= option in the SET statement
Creating the equivalent of the LEAD function by merging variables
The %HOP macro

Personally, I like the "merging variables" options for simple applications.

Re: Opposite of Lag function

SASdevAnneMarie — Thu, 17 Sep 2020 11:12:42 GMT

Thank you very much!