https://communities.sas.com/t5/SAS-Enterprise-Guide/calculating-the-difference-between-two-rows/m-p/937#M262 Lag function may be an option.<BR /> <BR /> <A href="http://support.sas.com/ctx/samples/index.jsp?sid=1498&amp;tab=code" target="_blank">http://support.sas.com/ctx/samples/index.jsp?sid=1498&amp;tab=code</A> Fri, 30 Jun 2006 16:48:17 GMT deleted_user 2006-06-30T16:48:17Z https://communities.sas.com/t5/SAS-Enterprise-Guide/calculating-the-difference-between-two-rows/m-p/936#M261 Hi,<BR /> i'm trying to calculate the difference between two observations from the same variable on two differents rows. Per example, <BR /> id var<BR /> 1 4<BR /> 1 2<BR /> <BR /> Basically, making 4-2.<BR /> <BR /> Thanks,<BR /> <BR /> JS Fri, 30 Jun 2006 16:17:11 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/calculating-the-difference-between-two-rows/m-p/936#M261 deleted_user 2006-06-30T16:17:11Z https://communities.sas.com/t5/SAS-Enterprise-Guide/calculating-the-difference-between-two-rows/m-p/937#M262 Lag function may be an option.<BR /> <BR /> <A href="http://support.sas.com/ctx/samples/index.jsp?sid=1498&amp;tab=code" target="_blank">http://support.sas.com/ctx/samples/index.jsp?sid=1498&amp;tab=code</A> Fri, 30 Jun 2006 16:48:17 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/calculating-the-difference-between-two-rows/m-p/937#M262 deleted_user 2006-06-30T16:48:17Z