Operations calling values of a variable in specific rows ...

[deleted_user]

Hi !
How could I perform operations with the value of a variable in a specific row ? could be the previous row (n-1.variable), the next one (n+1.variable), the first (first.variable), the last (last.variable) or the value from a variable in a specific row number (rowx.variable).


I am trying to perform operations like:


if n.variable ne n-1.variable then y=1;


Thanks in advance.

Asier

[Peter_C]

have you looked at the LAG() function?

[deleted_user]

Thanks a lot Peter, the LAG() function solved my doubt.

Asier.