topic COMPARISON BETWEEN LINES in SAS Programming https://communities.sas.com/t5/SAS-Programming/COMPARISON-BETWEEN-LINES/m-p/726823#M225911 <P>Hi,</P><P>&nbsp;</P><P>I have a table, where each line represents a day of information for a given product.</P><P>I would like to know how to create an IF that compares the lines.</P><P>&nbsp;</P><P>Exemple:</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>date</TD><TD>prodid</TD><TD>prodname</TD><TD>status</TD></TR><TR><TD>01/01/2021</TD><TD>111</TD><TD>xpto</TD><TD>0</TD></TR><TR><TD>02/01/2021</TD><TD>11</TD><TD>xpto</TD><TD>1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>IF <SPAN>prodid&nbsp;from line 2 is different from line 1 = "status has changed"</SPAN></P><P>&nbsp;</P><P>Is it possible to do that?</P><P>&nbsp;</P> Tue, 16 Mar 2021 16:26:52 GMT KA_ARARO 2021-03-16T16:26:52Z COMPARISON BETWEEN LINES https://communities.sas.com/t5/SAS-Programming/COMPARISON-BETWEEN-LINES/m-p/726823#M225911 <P>Hi,</P><P>&nbsp;</P><P>I have a table, where each line represents a day of information for a given product.</P><P>I would like to know how to create an IF that compares the lines.</P><P>&nbsp;</P><P>Exemple:</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>date</TD><TD>prodid</TD><TD>prodname</TD><TD>status</TD></TR><TR><TD>01/01/2021</TD><TD>111</TD><TD>xpto</TD><TD>0</TD></TR><TR><TD>02/01/2021</TD><TD>11</TD><TD>xpto</TD><TD>1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>IF <SPAN>prodid&nbsp;from line 2 is different from line 1 = "status has changed"</SPAN></P><P>&nbsp;</P><P>Is it possible to do that?</P><P>&nbsp;</P> Tue, 16 Mar 2021 16:26:52 GMT https://communities.sas.com/t5/SAS-Programming/COMPARISON-BETWEEN-LINES/m-p/726823#M225911 KA_ARARO 2021-03-16T16:26:52Z Re: COMPARISON BETWEEN LINES https://communities.sas.com/t5/SAS-Programming/COMPARISON-BETWEEN-LINES/m-p/726848#M225922 Look at the LAG and DIF function. <BR />Depending on what you're doing a BY and FIRST/LAST may also be useful. <BR /><BR /><A href="https://www.listendata.com/2016/08/4-ways-to-calculate-lag-and-lead-in-sas.html" target="_blank">https://www.listendata.com/2016/08/4-ways-to-calculate-lag-and-lead-in-sas.html</A> Tue, 16 Mar 2021 18:04:08 GMT https://communities.sas.com/t5/SAS-Programming/COMPARISON-BETWEEN-LINES/m-p/726848#M225922 Reeza 2021-03-16T18:04:08Z