topic ACCUMULATIVE BY GROUP AND DATE in SAS Programming https://communities.sas.com/t5/SAS-Programming/ACCUMULATIVE-BY-GROUP-AND-DATE/m-p/814455#M321460 <P><SPAN class="">Hello everyone, I hope you are very well, I have a problem that has not worked for me at all, I need to accumulate a numeric column by group and date. The example table is the following:</SPAN></P><P>&nbsp;</P><TABLE><TBODY><TR><TD>GROUP</TD><TD>DATE</TD><TD>TOTAL</TD><TD>CUMULATIVE_BY_GROUP</TD></TR><TR><TD>A</TD><TD>01-01-2022</TD><TD>12</TD><TD>12</TD></TR><TR><TD>A</TD><TD>02-01-2022</TD><TD>15</TD><TD>27</TD></TR><TR><TD>A</TD><TD>03-01-2022</TD><TD>3</TD><TD>30</TD></TR><TR><TD>A</TD><TD>04-01-2022</TD><TD>3</TD><TD>33</TD></TR><TR><TD>A</TD><TD>05-01-2022</TD><TD>16</TD><TD>49</TD></TR><TR><TD>A</TD><TD>06-01-2022</TD><TD>7</TD><TD>56</TD></TR><TR><TD>B</TD><TD>01-01-2022</TD><TD>3</TD><TD>3</TD></TR><TR><TD>B</TD><TD>02-01-2022</TD><TD>6</TD><TD>9</TD></TR><TR><TD>B</TD><TD>03-01-2022</TD><TD>18</TD><TD>27</TD></TR><TR><TD>B</TD><TD>04-01-2022</TD><TD>6</TD><TD>33</TD></TR><TR><TD>B</TD><TD>05-01-2022</TD><TD>2</TD><TD>35</TD></TR><TR><TD>B</TD><TD>06-01-2022</TD><TD>12</TD><TD>47</TD></TR><TR><TD>C</TD><TD>01-01-2022</TD><TD>16</TD><TD>16</TD></TR><TR><TD>C</TD><TD>02-01-2022</TD><TD>4</TD><TD>20</TD></TR><TR><TD>C</TD><TD>03-01-2022</TD><TD>19</TD><TD>39</TD></TR><TR><TD>C</TD><TD>04-01-2022</TD><TD>16</TD><TD>55</TD></TR><TR><TD>C</TD><TD>05-01-2022</TD><TD>4</TD><TD>59</TD></TR><TR><TD>C</TD><TD>06-01-2022</TD><TD>6</TD><TD>65</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thanks.</P> Fri, 20 May 2022 14:50:09 GMT Andres_Fuentes1 2022-05-20T14:50:09Z ACCUMULATIVE BY GROUP AND DATE https://communities.sas.com/t5/SAS-Programming/ACCUMULATIVE-BY-GROUP-AND-DATE/m-p/814455#M321460 <P><SPAN class="">Hello everyone, I hope you are very well, I have a problem that has not worked for me at all, I need to accumulate a numeric column by group and date. The example table is the following:</SPAN></P><P>&nbsp;</P><TABLE><TBODY><TR><TD>GROUP</TD><TD>DATE</TD><TD>TOTAL</TD><TD>CUMULATIVE_BY_GROUP</TD></TR><TR><TD>A</TD><TD>01-01-2022</TD><TD>12</TD><TD>12</TD></TR><TR><TD>A</TD><TD>02-01-2022</TD><TD>15</TD><TD>27</TD></TR><TR><TD>A</TD><TD>03-01-2022</TD><TD>3</TD><TD>30</TD></TR><TR><TD>A</TD><TD>04-01-2022</TD><TD>3</TD><TD>33</TD></TR><TR><TD>A</TD><TD>05-01-2022</TD><TD>16</TD><TD>49</TD></TR><TR><TD>A</TD><TD>06-01-2022</TD><TD>7</TD><TD>56</TD></TR><TR><TD>B</TD><TD>01-01-2022</TD><TD>3</TD><TD>3</TD></TR><TR><TD>B</TD><TD>02-01-2022</TD><TD>6</TD><TD>9</TD></TR><TR><TD>B</TD><TD>03-01-2022</TD><TD>18</TD><TD>27</TD></TR><TR><TD>B</TD><TD>04-01-2022</TD><TD>6</TD><TD>33</TD></TR><TR><TD>B</TD><TD>05-01-2022</TD><TD>2</TD><TD>35</TD></TR><TR><TD>B</TD><TD>06-01-2022</TD><TD>12</TD><TD>47</TD></TR><TR><TD>C</TD><TD>01-01-2022</TD><TD>16</TD><TD>16</TD></TR><TR><TD>C</TD><TD>02-01-2022</TD><TD>4</TD><TD>20</TD></TR><TR><TD>C</TD><TD>03-01-2022</TD><TD>19</TD><TD>39</TD></TR><TR><TD>C</TD><TD>04-01-2022</TD><TD>16</TD><TD>55</TD></TR><TR><TD>C</TD><TD>05-01-2022</TD><TD>4</TD><TD>59</TD></TR><TR><TD>C</TD><TD>06-01-2022</TD><TD>6</TD><TD>65</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thanks.</P> Fri, 20 May 2022 14:50:09 GMT https://communities.sas.com/t5/SAS-Programming/ACCUMULATIVE-BY-GROUP-AND-DATE/m-p/814455#M321460 Andres_Fuentes1 2022-05-20T14:50:09Z Re: ACCUMULATIVE BY GROUP AND DATE https://communities.sas.com/t5/SAS-Programming/ACCUMULATIVE-BY-GROUP-AND-DATE/m-p/814456#M321461 <P>&nbsp;</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">/* Untested Code */ data want; set have; by group; if first.group then cumulative_by_group=0; cumulative_by_group+total; run;</CODE></PRE> Fri, 20 May 2022 14:53:16 GMT https://communities.sas.com/t5/SAS-Programming/ACCUMULATIVE-BY-GROUP-AND-DATE/m-p/814456#M321461 PaigeMiller 2022-05-20T14:53:16Z