COMPARISON BETWEEN LINES

[KA_ARARO]

Hi,

I have a table, where each line represents a day of information for a given product.

I would like to know how to create an IF that compares the lines.

Exemple:

date	prodid	prodname	status
01/01/2021	111	xpto	0
02/01/2021	11	xpto	1

IF prodid from line 2 is different from line 1 = "status has changed"

Is it possible to do that?

[Reeza · Accepted solution]

Look at the LAG and DIF function.
Depending on what you're doing a BY and FIRST/LAST may also be useful.

https://www.listendata.com/2016/08/4-ways-to-calculate-lag-and-lead-in-sas.html