https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-sum-each-previous-rows/m-p/714504#M38022 <P>Or, <EM>very</EM> slightly optimized:</P> <PRE><CODE class=" language-sas">data want; set have; by SPcislo; if first.SPcislo then c = cislo; else c + cislo; run;</CODE></PRE> <P>(at all FIRST. events, there's only one assignment instead of two)</P> Wed, 27 Jan 2021 09:20:51 GMT Kurt_Bremser 2021-01-27T09:20:51Z https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-sum-each-previous-rows/m-p/714499#M38020 <P>Hello, i want to ask how can i sum each previous rows by variable SPCislo, here is sample of data:</P><P>&nbsp;</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>PK</TD><TD>DatumPodpisu</TD><TD>SPcislo</TD><TD>cislo</TD></TR><TR><TD>501377324233203</TD><TD>23Sep2019 0:00:00,000</TD><TD>5100543</TD><TD>10</TD></TR><TR><TD>501377324233208</TD><TD>23Sep2019 0:00:00,000</TD><TD>5100543</TD><TD>10</TD></TR><TR><TD>501377324233213</TD><TD>23Sep2019 0:00:00,000</TD><TD>5100543</TD><TD>10</TD></TR><TR><TD>501377324274981</TD><TD>23Sep2019 0:00:00,000</TD><TD>5100543</TD><TD>10</TD></TR><TR><TD>501377324461518</TD><TD>10Mar2020 0:00:00,000</TD><TD>555</TD><TD>38,0352</TD></TR><TR><TD>501377324452148</TD><TD>11Mar2020 0:00:00,000</TD><TD>555</TD><TD>11,543</TD></TR><TR><TD>501377324458471</TD><TD>12Mar2020 0:00:00,000</TD><TD>555</TD><TD>195,7242</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>And i want to calculated sum of each row by rows group by SPCislo, like this:</P><TABLE><TBODY><TR><TD>PK</TD><TD>DatumPodpisu</TD><TD>SPcislo</TD><TD>cislo</TD><TD><STRONG>how to calculate this???</STRONG></TD></TR><TR><TD>501377324233203</TD><TD>23Sep2019 0:00:00,000</TD><TD>5100543</TD><TD>10</TD><TD><STRONG>10</STRONG></TD></TR><TR><TD>501377324233208</TD><TD>23Sep2019 0:00:00,000</TD><TD>5100543</TD><TD>10</TD><TD><STRONG>20</STRONG></TD></TR><TR><TD>501377324233213</TD><TD>23Sep2019 0:00:00,000</TD><TD>5100543</TD><TD>10</TD><TD><STRONG>30</STRONG></TD></TR><TR><TD>501377324274981</TD><TD>23Sep2019 0:00:00,000</TD><TD>5100543</TD><TD>10</TD><TD><STRONG>40</STRONG></TD></TR><TR><TD>501377324461518</TD><TD>10Mar2020 0:00:00,000</TD><TD>555</TD><TD>38,0352</TD><TD><STRONG>38,0352</STRONG></TD></TR><TR><TD>501377324452148</TD><TD>11Mar2020 0:00:00,000</TD><TD>555</TD><TD>11,543</TD><TD><STRONG>49,5782</STRONG></TD></TR><TR><TD>501377324458471</TD><TD>12Mar2020 0:00:00,000</TD><TD>555</TD><TD>195,7242</TD><TD><STRONG>245,3024</STRONG></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thanks all for help <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Wed, 27 Jan 2021 08:52:55 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-sum-each-previous-rows/m-p/714499#M38020 Pato485 2021-01-27T08:52:55Z https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-sum-each-previous-rows/m-p/714502#M38021 <PRE><CODE class=" language-sas">data want; set have; by SPcislo; if first.SPcislo then c = 0; c + cislo; run; </CODE></PRE> Wed, 27 Jan 2021 09:12:26 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-sum-each-previous-rows/m-p/714502#M38021 PeterClemmensen 2021-01-27T09:12:26Z https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-sum-each-previous-rows/m-p/714504#M38022 <P>Or, <EM>very</EM> slightly optimized:</P> <PRE><CODE class=" language-sas">data want; set have; by SPcislo; if first.SPcislo then c = cislo; else c + cislo; run;</CODE></PRE> <P>(at all FIRST. events, there's only one assignment instead of two)</P> Wed, 27 Jan 2021 09:20:51 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-sum-each-previous-rows/m-p/714504#M38022 Kurt_Bremser 2021-01-27T09:20:51Z