Opposite of Lag function

[SASdevAnneMarie]

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!

[Rick_SAS · Accepted solution]

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.

[SASdevAnneMarie]

Thank you very much!