https://communities.sas.com/t5/SAS-Programming/Line-by-line-calculation-with-lag/m-p/718251#M222241 Wed, 10 Feb 2021 14:28:40 GMT SASdevAnneMarie 2021-02-10T14:28:40Z https://communities.sas.com/t5/SAS-Programming/Line-by-line-calculation-with-lag/m-p/718242#M222237 Thu, 11 Feb 2021 08:33:47 GMT https://communities.sas.com/t5/SAS-Programming/Line-by-line-calculation-with-lag/m-p/718242#M222237 SASdevAnneMarie 2021-02-11T08:33:47Z https://communities.sas.com/t5/SAS-Programming/Line-by-line-calculation-with-lag/m-p/718247#M222238 <P>So your data looks like this.. Rather than us correcting your code a bit, let me ask this.</P> <P>&nbsp;</P> <P>What does your desired result look like, given this data?</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">data WORK.VARIATION6; infile datalines dsd truncover; input NO_POLICE:$20. DATE:DDMMYY10. MT_EA:32. CD_EVT:$8. MT_EVT:32. MT_EA_AVMVT:32. DeltaEAs:32. EAs:32. count:32. boucle:32. EAs_avant:32.; format DATE DDMMYYS10.; label NO_POLICE="NO_POLICE" MT_EA="MT_EA" CD_EVT="CD_EVT" MT_EVT="MT_BRUT"; datalines4; V55900010,31/12/2019,147171.89315,,,,0,147171.89315,1,7, V55900010,15/01/2020,,RDES,-1800,149675.17929,-1769.895376,145371.89315,2,7,147171.89315 V55900010,22/01/2020,,VINV,100000,148782.16658,100000,245371.89315,3,7,145371.89315 V55900010,15/04/2020,,RDES,-1800,227609.96392,-1940.46605,243571.89315,4,7,245371.89315 V55900010,15/07/2020,,RDES,-1800,237720.68701,0,0,5,7,243571.89315 V55900010,15/10/2020,,RDES,-1800,232272.14554,0,0,6,7,0 V55900010,31/12/2020,248976.1154,,,,0,0,7,7,0 ;;;; </CODE></PRE> Wed, 10 Feb 2021 14:23:17 GMT https://communities.sas.com/t5/SAS-Programming/Line-by-line-calculation-with-lag/m-p/718247#M222238 PeterClemmensen 2021-02-10T14:23:17Z https://communities.sas.com/t5/SAS-Programming/Line-by-line-calculation-with-lag/m-p/718250#M222240 <P>Please supply example data for variation<STRONG>5</STRONG>, and the variation6 you <EM>expect</EM> from this.</P> Wed, 10 Feb 2021 14:25:45 GMT https://communities.sas.com/t5/SAS-Programming/Line-by-line-calculation-with-lag/m-p/718250#M222240 Kurt_Bremser 2021-02-10T14:25:45Z https://communities.sas.com/t5/SAS-Programming/Line-by-line-calculation-with-lag/m-p/718251#M222241 Wed, 10 Feb 2021 14:28:40 GMT https://communities.sas.com/t5/SAS-Programming/Line-by-line-calculation-with-lag/m-p/718251#M222241 SASdevAnneMarie 2021-02-10T14:28:40Z https://communities.sas.com/t5/SAS-Programming/Line-by-line-calculation-with-lag/m-p/718252#M222242 <P>Hello,<BR />Thank you,<BR />I added the data with results into my first message.<BR />Thank you !</P> Wed, 10 Feb 2021 14:33:24 GMT https://communities.sas.com/t5/SAS-Programming/Line-by-line-calculation-with-lag/m-p/718252#M222242 SASdevAnneMarie 2021-02-10T14:33:24Z https://communities.sas.com/t5/SAS-Programming/Line-by-line-calculation-with-lag/m-p/718254#M222243 <P>Hello,<BR /><BR />I added the data with results into my first message.<BR />Thank you very much !</P> Wed, 10 Feb 2021 14:34:05 GMT https://communities.sas.com/t5/SAS-Programming/Line-by-line-calculation-with-lag/m-p/718254#M222243 SASdevAnneMarie 2021-02-10T14:34:05Z https://communities.sas.com/t5/SAS-Programming/Line-by-line-calculation-with-lag/m-p/718256#M222245 I added the Variation5.<BR />Thank you, Kurt. Wed, 10 Feb 2021 14:37:02 GMT https://communities.sas.com/t5/SAS-Programming/Line-by-line-calculation-with-lag/m-p/718256#M222245 SASdevAnneMarie 2021-02-10T14:37:02Z https://communities.sas.com/t5/SAS-Programming/Line-by-line-calculation-with-lag/m-p/718366#M222317 Finally I found the solution <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> Thank you ! Wed, 10 Feb 2021 19:27:56 GMT https://communities.sas.com/t5/SAS-Programming/Line-by-line-calculation-with-lag/m-p/718366#M222317 SASdevAnneMarie 2021-02-10T19:27:56Z