topic cumulative sum by group on different conditions in SAS Programming https://communities.sas.com/t5/SAS-Programming/cumulative-sum-by-group-on-different-conditions/m-p/509621#M137013 <P>Hello</P><P>&nbsp;</P><P>I need suggestions on the following request.</P><TABLE><TBODY><TR><TD><P><STRONG>New varname</STRONG></P></TD><TD><P><STRONG>Calculation</STRONG></P></TD></TR><TR><TD><P>kcal_day</P></TD><TD><P>= sum of <SPAN>kcal</SPAN></P></TD></TR><TR><TD><P>discsav_tot</P></TD><TD><P>= sum of <SPAN>disc_sav</SPAN></P></TD></TR><TR><TD><P>discsav_kcal</P></TD><TD><P>= sum of <SPAN>kcal</SPAN> for all observations where <SPAN>disc_sav</SPAN>=1</P></TD></TR><TR><TD><P>discswt_tot</P></TD><TD><P>= sum of <SPAN>disc_swt</SPAN></P></TD></TR><TR><TD><P>Discswt_kcal</P></TD><TD><P>= sum of <SPAN>kcal</SPAN> for all observations where <SPAN>disc_swt</SPAN>=1</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>The original data set is&nbsp;</P><TABLE><TBODY><TR><TD>patid</TD><TD>date</TD><TD>kcal</TD><TD>disc_sav</TD><TD>disc_swt</TD></TR><TR><TD>1</TD><TD>13-Dec-14</TD><TD>124.8</TD><TD>0</TD><TD>.</TD></TR><TR><TD>1</TD><TD>13-Dec-14</TD><TD>278.64</TD><TD>0</TD><TD>1</TD></TR><TR><TD>1</TD><TD>13-Dec-14</TD><TD>0</TD><TD>.</TD><TD>.</TD></TR><TR><TD>1</TD><TD>13-Dec-14</TD><TD>58.5</TD><TD>0</TD><TD>.</TD></TR><TR><TD>1</TD><TD>13-Dec-14</TD><TD>1413.255</TD><TD>1</TD><TD>0</TD></TR><TR><TD>1</TD><TD>13-Dec-14</TD><TD>293.76</TD><TD>0</TD><TD>.</TD></TR><TR><TD>1</TD><TD>13-Dec-14</TD><TD>142.59</TD><TD>1</TD><TD>0</TD></TR><TR><TD>1</TD><TD>13-Dec-14</TD><TD>124.8</TD><TD>0</TD><TD>.</TD></TR><TR><TD>1</TD><TD>13-Dec-14</TD><TD>0</TD><TD>.</TD><TD>.</TD></TR><TR><TD>2</TD><TD>7-Jan-15</TD><TD>144</TD><TD>1</TD><TD>1</TD></TR><TR><TD>2</TD><TD>7-Jan-15</TD><TD>62.424</TD><TD>1</TD><TD>.</TD></TR><TR><TD>2</TD><TD>30-Mar-15</TD><TD>80.6</TD><TD>0</TD><TD>0</TD></TR><TR><TD>2</TD><TD>30-Mar-15</TD><TD>122</TD><TD>0</TD><TD>.</TD></TR><TR><TD>2</TD><TD>30-Mar-15</TD><TD>298.89</TD><TD>1</TD><TD>.</TD></TR><TR><TD>2</TD><TD>30-Mar-15</TD><TD>0</TD><TD>.</TD><TD>.</TD></TR><TR><TD>2</TD><TD>31-Mar-15</TD><TD>69.16</TD><TD>1</TD><TD>0</TD></TR><TR><TD>2</TD><TD>31-Mar-15</TD><TD>33.756624</TD><TD>0</TD><TD>.</TD></TR><TR><TD>2</TD><TD>31-Mar-15</TD><TD>51.072</TD><TD>1</TD><TD>1</TD></TR><TR><TD>2</TD><TD>31-Mar-15</TD><TD>62.62</TD><TD>1</TD><TD>.</TD></TR><TR><TD>2</TD><TD>31-Mar-15</TD><TD>0</TD><TD>.</TD><TD>.</TD></TR><TR><TD>2</TD><TD>31-Mar-15</TD><TD>14.025</TD><TD>1</TD><TD>.</TD></TR><TR><TD>2</TD><TD>30-Apr-15</TD><TD>10.35</TD><TD>1</TD><TD>.</TD></TR><TR><TD>2</TD><TD>30-Apr-15</TD><TD>85.92</TD><TD>1</TD><TD>.</TD></TR><TR><TD>2</TD><TD>30-Apr-15</TD><TD>26.555344</TD><TD>1</TD><TD>0</TD></TR><TR><TD>2</TD><TD>30-Apr-15</TD><TD>105.28</TD><TD>1</TD><TD>.</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>The final output wants only one raw per patid&nbsp;and date.&nbsp; Thank you for your suggestion.</P> Thu, 01 Nov 2018 17:36:44 GMT CHL0320 2018-11-01T17:36:44Z cumulative sum by group on different conditions https://communities.sas.com/t5/SAS-Programming/cumulative-sum-by-group-on-different-conditions/m-p/509621#M137013 <P>Hello</P><P>&nbsp;</P><P>I need suggestions on the following request.</P><TABLE><TBODY><TR><TD><P><STRONG>New varname</STRONG></P></TD><TD><P><STRONG>Calculation</STRONG></P></TD></TR><TR><TD><P>kcal_day</P></TD><TD><P>= sum of <SPAN>kcal</SPAN></P></TD></TR><TR><TD><P>discsav_tot</P></TD><TD><P>= sum of <SPAN>disc_sav</SPAN></P></TD></TR><TR><TD><P>discsav_kcal</P></TD><TD><P>= sum of <SPAN>kcal</SPAN> for all observations where <SPAN>disc_sav</SPAN>=1</P></TD></TR><TR><TD><P>discswt_tot</P></TD><TD><P>= sum of <SPAN>disc_swt</SPAN></P></TD></TR><TR><TD><P>Discswt_kcal</P></TD><TD><P>= sum of <SPAN>kcal</SPAN> for all observations where <SPAN>disc_swt</SPAN>=1</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>The original data set is&nbsp;</P><TABLE><TBODY><TR><TD>patid</TD><TD>date</TD><TD>kcal</TD><TD>disc_sav</TD><TD>disc_swt</TD></TR><TR><TD>1</TD><TD>13-Dec-14</TD><TD>124.8</TD><TD>0</TD><TD>.</TD></TR><TR><TD>1</TD><TD>13-Dec-14</TD><TD>278.64</TD><TD>0</TD><TD>1</TD></TR><TR><TD>1</TD><TD>13-Dec-14</TD><TD>0</TD><TD>.</TD><TD>.</TD></TR><TR><TD>1</TD><TD>13-Dec-14</TD><TD>58.5</TD><TD>0</TD><TD>.</TD></TR><TR><TD>1</TD><TD>13-Dec-14</TD><TD>1413.255</TD><TD>1</TD><TD>0</TD></TR><TR><TD>1</TD><TD>13-Dec-14</TD><TD>293.76</TD><TD>0</TD><TD>.</TD></TR><TR><TD>1</TD><TD>13-Dec-14</TD><TD>142.59</TD><TD>1</TD><TD>0</TD></TR><TR><TD>1</TD><TD>13-Dec-14</TD><TD>124.8</TD><TD>0</TD><TD>.</TD></TR><TR><TD>1</TD><TD>13-Dec-14</TD><TD>0</TD><TD>.</TD><TD>.</TD></TR><TR><TD>2</TD><TD>7-Jan-15</TD><TD>144</TD><TD>1</TD><TD>1</TD></TR><TR><TD>2</TD><TD>7-Jan-15</TD><TD>62.424</TD><TD>1</TD><TD>.</TD></TR><TR><TD>2</TD><TD>30-Mar-15</TD><TD>80.6</TD><TD>0</TD><TD>0</TD></TR><TR><TD>2</TD><TD>30-Mar-15</TD><TD>122</TD><TD>0</TD><TD>.</TD></TR><TR><TD>2</TD><TD>30-Mar-15</TD><TD>298.89</TD><TD>1</TD><TD>.</TD></TR><TR><TD>2</TD><TD>30-Mar-15</TD><TD>0</TD><TD>.</TD><TD>.</TD></TR><TR><TD>2</TD><TD>31-Mar-15</TD><TD>69.16</TD><TD>1</TD><TD>0</TD></TR><TR><TD>2</TD><TD>31-Mar-15</TD><TD>33.756624</TD><TD>0</TD><TD>.</TD></TR><TR><TD>2</TD><TD>31-Mar-15</TD><TD>51.072</TD><TD>1</TD><TD>1</TD></TR><TR><TD>2</TD><TD>31-Mar-15</TD><TD>62.62</TD><TD>1</TD><TD>.</TD></TR><TR><TD>2</TD><TD>31-Mar-15</TD><TD>0</TD><TD>.</TD><TD>.</TD></TR><TR><TD>2</TD><TD>31-Mar-15</TD><TD>14.025</TD><TD>1</TD><TD>.</TD></TR><TR><TD>2</TD><TD>30-Apr-15</TD><TD>10.35</TD><TD>1</TD><TD>.</TD></TR><TR><TD>2</TD><TD>30-Apr-15</TD><TD>85.92</TD><TD>1</TD><TD>.</TD></TR><TR><TD>2</TD><TD>30-Apr-15</TD><TD>26.555344</TD><TD>1</TD><TD>0</TD></TR><TR><TD>2</TD><TD>30-Apr-15</TD><TD>105.28</TD><TD>1</TD><TD>.</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>The final output wants only one raw per patid&nbsp;and date.&nbsp; Thank you for your suggestion.</P> Thu, 01 Nov 2018 17:36:44 GMT https://communities.sas.com/t5/SAS-Programming/cumulative-sum-by-group-on-different-conditions/m-p/509621#M137013 CHL0320 2018-11-01T17:36:44Z Re: cumulative sum by group on different conditions https://communities.sas.com/t5/SAS-Programming/cumulative-sum-by-group-on-different-conditions/m-p/509623#M137015 PROC MEANS + CLASS statement or PROC SQL. In general, PROC MEANS is more dynamic, while PROC SQL ends up being hard coded for your situation. Thu, 01 Nov 2018 17:37:45 GMT https://communities.sas.com/t5/SAS-Programming/cumulative-sum-by-group-on-different-conditions/m-p/509623#M137015 Reeza 2018-11-01T17:37:45Z