topic Compare two records in same data set in SAS Programming https://communities.sas.com/t5/SAS-Programming/Compare-two-records-in-same-data-set/m-p/727593#M226346 <P>Data set growth has 50K records</P><P>here are sample data set looks like, I would like to compare by node,period&nbsp; of growth value&nbsp; (REC1-Rec2)&gt; +-5000 the select the Node or display the node</P><P>&nbsp;</P><P>this needs to repeated all the records by node and period only</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>STRATEGY</TD><TD>NODE</TD><TD>Period</TD><TD>Fast_GROWTH_DAY_NUM</TD><TD>GROWTH_VALUE</TD></TR><TR><TD>Mar9QF Strategy</TD><TD>892922</TD><TD>1</TD><TD>1</TD><TD>32468.1295</TD></TR><TR><TD>MML Strategy</TD><TD>892922</TD><TD>1</TD><TD>1</TD><TD>32468.1295</TD></TR><TR><TD>MML Strategy</TD><TD>892922</TD><TD>2</TD><TD>1</TD><TD>36007.7485</TD></TR><TR><TD>Mar9QF Strategy</TD><TD>892922</TD><TD>2</TD><TD>1</TD><TD>36007.7485</TD></TR><TR><TD>Mar9QF Strategy</TD><TD>892922</TD><TD>3</TD><TD>1</TD><TD>36007.7485</TD></TR><TR><TD>MML Strategy</TD><TD>892922</TD><TD>3</TD><TD>1</TD><TD>36007.7485</TD></TR><TR><TD>MML Strategy</TD><TD>892922</TD><TD>4</TD><TD>1</TD><TD>36007.7485</TD></TR><TR><TD>Mar9QF Strategy</TD><TD>892922</TD><TD>4</TD><TD>1</TD><TD>36007.7485</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>How to do this SAS</P><P>&nbsp;</P> Thu, 18 Mar 2021 22:34:34 GMT Ashpak 2021-03-18T22:34:34Z Compare two records in same data set https://communities.sas.com/t5/SAS-Programming/Compare-two-records-in-same-data-set/m-p/727593#M226346 <P>Data set growth has 50K records</P><P>here are sample data set looks like, I would like to compare by node,period&nbsp; of growth value&nbsp; (REC1-Rec2)&gt; +-5000 the select the Node or display the node</P><P>&nbsp;</P><P>this needs to repeated all the records by node and period only</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>STRATEGY</TD><TD>NODE</TD><TD>Period</TD><TD>Fast_GROWTH_DAY_NUM</TD><TD>GROWTH_VALUE</TD></TR><TR><TD>Mar9QF Strategy</TD><TD>892922</TD><TD>1</TD><TD>1</TD><TD>32468.1295</TD></TR><TR><TD>MML Strategy</TD><TD>892922</TD><TD>1</TD><TD>1</TD><TD>32468.1295</TD></TR><TR><TD>MML Strategy</TD><TD>892922</TD><TD>2</TD><TD>1</TD><TD>36007.7485</TD></TR><TR><TD>Mar9QF Strategy</TD><TD>892922</TD><TD>2</TD><TD>1</TD><TD>36007.7485</TD></TR><TR><TD>Mar9QF Strategy</TD><TD>892922</TD><TD>3</TD><TD>1</TD><TD>36007.7485</TD></TR><TR><TD>MML Strategy</TD><TD>892922</TD><TD>3</TD><TD>1</TD><TD>36007.7485</TD></TR><TR><TD>MML Strategy</TD><TD>892922</TD><TD>4</TD><TD>1</TD><TD>36007.7485</TD></TR><TR><TD>Mar9QF Strategy</TD><TD>892922</TD><TD>4</TD><TD>1</TD><TD>36007.7485</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>How to do this SAS</P><P>&nbsp;</P> Thu, 18 Mar 2021 22:34:34 GMT https://communities.sas.com/t5/SAS-Programming/Compare-two-records-in-same-data-set/m-p/727593#M226346 Ashpak 2021-03-18T22:34:34Z Re: Compare two records in same data set https://communities.sas.com/t5/SAS-Programming/Compare-two-records-in-same-data-set/m-p/727648#M226366 <P>In this sample data, can you indicate which data you want to compare with which data?</P> Fri, 19 Mar 2021 05:30:52 GMT https://communities.sas.com/t5/SAS-Programming/Compare-two-records-in-same-data-set/m-p/727648#M226366 japelin 2021-03-19T05:30:52Z Re: Compare two records in same data set https://communities.sas.com/t5/SAS-Programming/Compare-two-records-in-same-data-set/m-p/727680#M226381 <P>Please post data in usable form and show what you expect as result.</P> <P>The lag-function can be used to access values in prior observation(s).</P> Fri, 19 Mar 2021 07:54:51 GMT https://communities.sas.com/t5/SAS-Programming/Compare-two-records-in-same-data-set/m-p/727680#M226381 andreas_lds 2021-03-19T07:54:51Z