topic Re: add cumulative sum column in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/add-cumulative-sum-column/m-p/148656#M39321 <HTML><HEAD></HEAD><BODY><P>data want;</P><P>set have;</P><P>by group;</P><P>if first.group then want_column=0;</P><P>want_column+value;</P><P>run;</P></BODY></HTML> Thu, 30 Oct 2014 02:02:27 GMT stat_sas 2014-10-30T02:02:27Z add cumulative sum column https://communities.sas.com/t5/SAS-Procedures/add-cumulative-sum-column/m-p/148655#M39320 <HTML><HEAD></HEAD><BODY><P>Need help on creating a sum column by group.</P><P>Here's the sample:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 284px;"><TBODY><TR><TD class="xl63" height="20" width="64"><STRONG>group</STRONG></TD><TD class="xl63" width="64"><STRONG>name</STRONG></TD><TD class="xl63" width="64"><STRONG>value</STRONG></TD><TD class="xl63" width="92"><STRONG>want</STRONG>_<STRONG>column</STRONG></TD></TR><TR><TD height="20">grp1</TD><TD>name1</TD><TD align="right">1</TD><TD align="right">1</TD></TR><TR><TD height="20">grp1</TD><TD>name2</TD><TD align="right">2</TD><TD align="right">3</TD></TR><TR><TD height="20">grp1</TD><TD>name3</TD><TD align="right">3</TD><TD align="right">6</TD></TR><TR><TD height="20">grp1</TD><TD>name4</TD><TD align="right">4</TD><TD align="right">10</TD></TR><TR><TD colspan="1"></TD><TD colspan="1"></TD><TD colspan="1"></TD><TD colspan="1"></TD></TR><TR><TD height="20">grp2</TD><TD>name5</TD><TD align="right">5</TD><TD align="right">5</TD></TR><TR><TD height="20">grp2</TD><TD>name6</TD><TD align="right">6</TD><TD align="right">11</TD></TR><TR><TD height="20">grp2</TD><TD>name7</TD><TD align="right">7</TD><TD align="right">18</TD></TR><TR><TD height="20">grp2</TD><TD>name8</TD><TD align="right">8</TD><TD align="right">26</TD></TR></TBODY></TABLE><P></P><P></P><P>Thanks,</P></BODY></HTML> Thu, 30 Oct 2014 01:51:14 GMT https://communities.sas.com/t5/SAS-Procedures/add-cumulative-sum-column/m-p/148655#M39320 chrisgo 2014-10-30T01:51:14Z Re: add cumulative sum column https://communities.sas.com/t5/SAS-Procedures/add-cumulative-sum-column/m-p/148656#M39321 <HTML><HEAD></HEAD><BODY><P>data want;</P><P>set have;</P><P>by group;</P><P>if first.group then want_column=0;</P><P>want_column+value;</P><P>run;</P></BODY></HTML> Thu, 30 Oct 2014 02:02:27 GMT https://communities.sas.com/t5/SAS-Procedures/add-cumulative-sum-column/m-p/148656#M39321 stat_sas 2014-10-30T02:02:27Z