https://communities.sas.com/t5/SAS-Programming/how-to-sum-column-every-record/m-p/564516#M158367 <PRE><CODE class=" language-sas">data have ; input number ; cards ; 2 4 4 8 2 7 9 5 7 ; data want; retain mysum; set have; if (mysum + number) &gt; 20 then mysum = number; else mysum + number; run;</CODE></PRE> Fri, 07 Jun 2019 17:27:15 GMT VDD 2019-06-07T17:27:15Z https://communities.sas.com/t5/SAS-Programming/how-to-sum-column-every-record/m-p/564515#M158366 <P>I have one dataset like see below</P><P>data have ;</P><P>input number ;</P><P>cards ;</P><P>2&nbsp;</P><P>4</P><P>4</P><P>8</P><P>2</P><P>7</P><P>9</P><P>5</P><P>7</P><P>;</P><P>&nbsp;</P><P>How to sum upto 20 and again start with record value like see below example</P><P>number&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;sum</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2</P><P>4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6</P><P>4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10</P><P>8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 18</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20</P><P>7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7------------------------again start with record value</P><P>9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 16</P><P>5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5----------------------again start with record value</P><P>7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12</P><P>;</P> Fri, 07 Jun 2019 17:10:41 GMT https://communities.sas.com/t5/SAS-Programming/how-to-sum-column-every-record/m-p/564515#M158366 thanikondharish 2019-06-07T17:10:41Z https://communities.sas.com/t5/SAS-Programming/how-to-sum-column-every-record/m-p/564516#M158367 <PRE><CODE class=" language-sas">data have ; input number ; cards ; 2 4 4 8 2 7 9 5 7 ; data want; retain mysum; set have; if (mysum + number) &gt; 20 then mysum = number; else mysum + number; run;</CODE></PRE> Fri, 07 Jun 2019 17:27:15 GMT https://communities.sas.com/t5/SAS-Programming/how-to-sum-column-every-record/m-p/564516#M158367 VDD 2019-06-07T17:27:15Z