https://communities.sas.com/t5/Statistical-Procedures/Sum-across-month-date-and-recurring-item-code/m-p/410670#M21462 <P>hi</P><P>&nbsp;</P><P>&nbsp;</P><P>i attached my dataset as i printed only 20 observation out of thousand.</P><P>&nbsp;</P><P>appreciate</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><P><STRONG>Obs</STRONG></P></TD><TD><P><STRONG>Acctno</STRONG></P></TD><TD><P><STRONG>actdt</STRONG></P></TD><TD><P><STRONG>deactdt</STRONG></P></TD><TD><P><STRONG>deactreason</STRONG></P></TD><TD><P><STRONG>goodcredit</STRONG></P></TD><TD><P><STRONG>rateplan</STRONG></P></TD><TD><P><STRONG>dealertype</STRONG></P></TD><TD><P><STRONG>AGE</STRONG></P></TD><TD><P><STRONG>Province</STRONG></P></TD><TD><P><STRONG>sales</STRONG></P></TD></TR><TR><TD><P><STRONG>1</STRONG></P></TD><TD><P>1176913194483</P></TD><TD><P>06/20/1999</P></TD><TD><P>01/20/2001</P></TD><TD><P>&nbsp;</P></TD><TD><P>0</P></TD><TD><P>1</P></TD><TD><P>A1</P></TD><TD><P>58</P></TD><TD><P>BC</P></TD><TD><P>$128.00</P></TD></TR><TR><TD><P><STRONG>2</STRONG></P></TD><TD><P>1176914599423</P></TD><TD><P>10/04/1999</P></TD><TD><P>10/15/1999</P></TD><TD><P>NEED</P></TD><TD><P>1</P></TD><TD><P>1</P></TD><TD><P>A1</P></TD><TD><P>45</P></TD><TD><P>AB</P></TD><TD><P>$72.00</P></TD></TR><TR><TD><P><STRONG>3</STRONG></P></TD><TD><P>1176951913656</P></TD><TD><P>07/01/2000</P></TD><TD><P>01/20/2001</P></TD><TD><P>&nbsp;</P></TD><TD><P>0</P></TD><TD><P>1</P></TD><TD><P>A1</P></TD><TD><P>57</P></TD><TD><P>BC</P></TD><TD><P>$593.00</P></TD></TR><TR><TD><P><STRONG>4</STRONG></P></TD><TD><P>1176954000288</P></TD><TD><P>05/30/2000</P></TD><TD><P>01/20/2001</P></TD><TD><P>&nbsp;</P></TD><TD><P>1</P></TD><TD><P>2</P></TD><TD><P>A1</P></TD><TD><P>47</P></TD><TD><P>ON</P></TD><TD><P>$83.00</P></TD></TR><TR><TD><P><STRONG>5</STRONG></P></TD><TD><P>1176969186303</P></TD><TD><P>12/13/2000</P></TD><TD><P>01/20/2001</P></TD><TD><P>&nbsp;</P></TD><TD><P>1</P></TD><TD><P>1</P></TD><TD><P>C1</P></TD><TD><P>82</P></TD><TD><P>BC</P></TD><TD><P>.</P></TD></TR><TR><TD><P><STRONG>6</STRONG></P></TD><TD><P>1176991056273</P></TD><TD><P>08/31/1999</P></TD><TD><P>09/18/2000</P></TD><TD><P>MOVE</P></TD><TD><P>1</P></TD><TD><P>1</P></TD><TD><P>C1</P></TD><TD><P>92</P></TD><TD><P>QC</P></TD><TD><P>$1041.00</P></TD></TR><TR><TD><P><STRONG>7</STRONG></P></TD><TD><P>1176991866552</P></TD><TD><P>05/24/2000</P></TD><TD><P>01/20/2001</P></TD><TD><P>&nbsp;</P></TD><TD><P>1</P></TD><TD><P>1</P></TD><TD><P>A1</P></TD><TD><P>77</P></TD><TD><P>ON</P></TD><TD><P>.</P></TD></TR><TR><TD><P><STRONG>8</STRONG></P></TD><TD><P>1176992889500</P></TD><TD><P>11/28/2000</P></TD><TD><P>01/20/2001</P></TD><TD><P>&nbsp;</P></TD><TD><P>1</P></TD><TD><P>1</P></TD><TD><P>C1</P></TD><TD><P>68</P></TD><TD><P>AB</P></TD><TD><P>$72.00</P></TD></TR><TR><TD><P><STRONG>9</STRONG></P></TD><TD><P>1177000067271</P></TD><TD><P>12/23/1999</P></TD><TD><P>01/20/2001</P></TD><TD><P>&nbsp;</P></TD><TD><P>0</P></TD><TD><P>1</P></TD><TD><P>B1</P></TD><TD><P>75</P></TD><TD><P>ON</P></TD><TD><P>$134.00</P></TD></TR><TR><TD><P><STRONG>10</STRONG></P></TD><TD><P>1177010940613</P></TD><TD><P>12/09/1999</P></TD><TD><P>01/20/2001</P></TD><TD><P>&nbsp;</P></TD><TD><P>1</P></TD><TD><P>2</P></TD><TD><P>A1</P></TD><TD><P>42</P></TD><TD><P>NS</P></TD><TD><P>$11.00</P></TD></TR><TR><TD><P><STRONG>11</STRONG></P></TD><TD><P>1177025997013</P></TD><TD><P>11/09/1999</P></TD><TD><P>01/20/2001</P></TD><TD><P>&nbsp;</P></TD><TD><P>1</P></TD><TD><P>1</P></TD><TD><P>A1</P></TD><TD><P>26</P></TD><TD><P>BC</P></TD><TD><P>$154.00</P></TD></TR><TR><TD><P><STRONG>12</STRONG></P></TD><TD><P>1177027515760</P></TD><TD><P>10/19/1999</P></TD><TD><P>01/20/2001</P></TD><TD><P>&nbsp;</P></TD><TD><P>1</P></TD><TD><P>1</P></TD><TD><P>B1</P></TD><TD><P>73</P></TD><TD><P>BC</P></TD><TD><P>$16.00</P></TD></TR><TR><TD><P><STRONG>13</STRONG></P></TD><TD><P>1177028996676</P></TD><TD><P>09/21/2000</P></TD><TD><P>01/20/2001</P></TD><TD><P>&nbsp;</P></TD><TD><P>0</P></TD><TD><P>1</P></TD><TD><P>C1</P></TD><TD><P>.</P></TD><TD><P>QC</P></TD><TD><P>$179.00</P></TD></TR><TR><TD><P><STRONG>14</STRONG></P></TD><TD><P>1177038747105</P></TD><TD><P>03/14/2000</P></TD><TD><P>01/20/2001</P></TD><TD><P>&nbsp;</P></TD><TD><P>0</P></TD><TD><P>1</P></TD><TD><P>C1</P></TD><TD><P>41</P></TD><TD><P>ON</P></TD><TD><P>$705.00</P></TD></TR><TR><TD><P><STRONG>15</STRONG></P></TD><TD><P>1177045857516</P></TD><TD><P>06/22/2000</P></TD><TD><P>01/20/2001</P></TD><TD><P>&nbsp;</P></TD><TD><P>1</P></TD><TD><P>1</P></TD><TD><P>A1</P></TD><TD><P>53</P></TD><TD><P>QC</P></TD><TD><P>$83.00</P></TD></TR><TR><TD><P><STRONG>16</STRONG></P></TD><TD><P>1177057406016</P></TD><TD><P>09/21/2000</P></TD><TD><P>01/20/2001</P></TD><TD><P>&nbsp;</P></TD><TD><P>0</P></TD><TD><P>1</P></TD><TD><P>C1</P></TD><TD><P>50</P></TD><TD><P>ON</P></TD><TD><P>$529.00</P></TD></TR><TR><TD><P><STRONG>17</STRONG></P></TD><TD><P>1177066422248</P></TD><TD><P>04/26/1999</P></TD><TD><P>01/15/2001</P></TD><TD><P>NEED</P></TD><TD><P>0</P></TD><TD><P>1</P></TD><TD><P>A2</P></TD><TD><P>55</P></TD><TD><P>NS</P></TD><TD><P>$44.00</P></TD></TR><TR><TD><P><STRONG>18</STRONG></P></TD><TD><P>1177089399155</P></TD><TD><P>08/17/2000</P></TD><TD><P>01/20/2001</P></TD><TD><P>&nbsp;</P></TD><TD><P>1</P></TD><TD><P>3</P></TD><TD><P>A1</P></TD><TD><P>56</P></TD><TD><P>BC</P></TD><TD><P>$548.00</P></TD></TR><TR><TD><P><STRONG>19</STRONG></P></TD><TD><P>1177113886410</P></TD><TD><P>09/13/2000</P></TD><TD><P>01/08/2001</P></TD><TD><P>COMP</P></TD><TD><P>0</P></TD><TD><P>1</P></TD><TD><P>C1</P></TD><TD><P>45</P></TD><TD><P>ON</P></TD><TD><P>$63.00</P></TD></TR><TR><TD><P><STRONG>20</STRONG></P></TD><TD><P>1177128264924</P></TD><TD><P>12/10/1999</P></TD><TD><P>01/20/2001</P></TD><TD><P>&nbsp;</P></TD><TD><P>1</P></TD><TD><P>1</P></TD><TD><P>B1</P></TD><TD><P>38</P></TD><TD><P>ON</P></TD><TD><P>$178.00</P></TD></TR></TBODY></TABLE><P>&nbsp;</P> Sun, 05 Nov 2017 14:04:51 GMT Azhar_ca 2017-11-05T14:04:51Z https://communities.sas.com/t5/Statistical-Procedures/Sum-across-month-date-and-recurring-item-code/m-p/410665#M21460 <P>Hi Folks</P><P>&nbsp;</P><P>looking for some smart tip .</P><P>&nbsp;</P><P>i have a dataset for customers which has a numeric variable containing customer accounts deactivation dates (2 years data).</P><P>&nbsp;</P><P>how can i sum total number of deactivation in each month for two years.</P><P>your kind response will be appreciated.</P><P>&nbsp;</P><P>thanks kindly.</P> Sun, 05 Nov 2017 12:33:09 GMT https://communities.sas.com/t5/Statistical-Procedures/Sum-across-month-date-and-recurring-item-code/m-p/410665#M21460 Azhar_ca 2017-11-05T12:33:09Z https://communities.sas.com/t5/Statistical-Procedures/Sum-across-month-date-and-recurring-item-code/m-p/410667#M21461 <P>Show some example data to get a code answer <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Sun, 05 Nov 2017 13:17:00 GMT https://communities.sas.com/t5/Statistical-Procedures/Sum-across-month-date-and-recurring-item-code/m-p/410667#M21461 PeterClemmensen 2017-11-05T13:17:00Z https://communities.sas.com/t5/Statistical-Procedures/Sum-across-month-date-and-recurring-item-code/m-p/410670#M21462 <P>hi</P><P>&nbsp;</P><P>&nbsp;</P><P>i attached my dataset as i printed only 20 observation out of thousand.</P><P>&nbsp;</P><P>appreciate</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><P><STRONG>Obs</STRONG></P></TD><TD><P><STRONG>Acctno</STRONG></P></TD><TD><P><STRONG>actdt</STRONG></P></TD><TD><P><STRONG>deactdt</STRONG></P></TD><TD><P><STRONG>deactreason</STRONG></P></TD><TD><P><STRONG>goodcredit</STRONG></P></TD><TD><P><STRONG>rateplan</STRONG></P></TD><TD><P><STRONG>dealertype</STRONG></P></TD><TD><P><STRONG>AGE</STRONG></P></TD><TD><P><STRONG>Province</STRONG></P></TD><TD><P><STRONG>sales</STRONG></P></TD></TR><TR><TD><P><STRONG>1</STRONG></P></TD><TD><P>1176913194483</P></TD><TD><P>06/20/1999</P></TD><TD><P>01/20/2001</P></TD><TD><P>&nbsp;</P></TD><TD><P>0</P></TD><TD><P>1</P></TD><TD><P>A1</P></TD><TD><P>58</P></TD><TD><P>BC</P></TD><TD><P>$128.00</P></TD></TR><TR><TD><P><STRONG>2</STRONG></P></TD><TD><P>1176914599423</P></TD><TD><P>10/04/1999</P></TD><TD><P>10/15/1999</P></TD><TD><P>NEED</P></TD><TD><P>1</P></TD><TD><P>1</P></TD><TD><P>A1</P></TD><TD><P>45</P></TD><TD><P>AB</P></TD><TD><P>$72.00</P></TD></TR><TR><TD><P><STRONG>3</STRONG></P></TD><TD><P>1176951913656</P></TD><TD><P>07/01/2000</P></TD><TD><P>01/20/2001</P></TD><TD><P>&nbsp;</P></TD><TD><P>0</P></TD><TD><P>1</P></TD><TD><P>A1</P></TD><TD><P>57</P></TD><TD><P>BC</P></TD><TD><P>$593.00</P></TD></TR><TR><TD><P><STRONG>4</STRONG></P></TD><TD><P>1176954000288</P></TD><TD><P>05/30/2000</P></TD><TD><P>01/20/2001</P></TD><TD><P>&nbsp;</P></TD><TD><P>1</P></TD><TD><P>2</P></TD><TD><P>A1</P></TD><TD><P>47</P></TD><TD><P>ON</P></TD><TD><P>$83.00</P></TD></TR><TR><TD><P><STRONG>5</STRONG></P></TD><TD><P>1176969186303</P></TD><TD><P>12/13/2000</P></TD><TD><P>01/20/2001</P></TD><TD><P>&nbsp;</P></TD><TD><P>1</P></TD><TD><P>1</P></TD><TD><P>C1</P></TD><TD><P>82</P></TD><TD><P>BC</P></TD><TD><P>.</P></TD></TR><TR><TD><P><STRONG>6</STRONG></P></TD><TD><P>1176991056273</P></TD><TD><P>08/31/1999</P></TD><TD><P>09/18/2000</P></TD><TD><P>MOVE</P></TD><TD><P>1</P></TD><TD><P>1</P></TD><TD><P>C1</P></TD><TD><P>92</P></TD><TD><P>QC</P></TD><TD><P>$1041.00</P></TD></TR><TR><TD><P><STRONG>7</STRONG></P></TD><TD><P>1176991866552</P></TD><TD><P>05/24/2000</P></TD><TD><P>01/20/2001</P></TD><TD><P>&nbsp;</P></TD><TD><P>1</P></TD><TD><P>1</P></TD><TD><P>A1</P></TD><TD><P>77</P></TD><TD><P>ON</P></TD><TD><P>.</P></TD></TR><TR><TD><P><STRONG>8</STRONG></P></TD><TD><P>1176992889500</P></TD><TD><P>11/28/2000</P></TD><TD><P>01/20/2001</P></TD><TD><P>&nbsp;</P></TD><TD><P>1</P></TD><TD><P>1</P></TD><TD><P>C1</P></TD><TD><P>68</P></TD><TD><P>AB</P></TD><TD><P>$72.00</P></TD></TR><TR><TD><P><STRONG>9</STRONG></P></TD><TD><P>1177000067271</P></TD><TD><P>12/23/1999</P></TD><TD><P>01/20/2001</P></TD><TD><P>&nbsp;</P></TD><TD><P>0</P></TD><TD><P>1</P></TD><TD><P>B1</P></TD><TD><P>75</P></TD><TD><P>ON</P></TD><TD><P>$134.00</P></TD></TR><TR><TD><P><STRONG>10</STRONG></P></TD><TD><P>1177010940613</P></TD><TD><P>12/09/1999</P></TD><TD><P>01/20/2001</P></TD><TD><P>&nbsp;</P></TD><TD><P>1</P></TD><TD><P>2</P></TD><TD><P>A1</P></TD><TD><P>42</P></TD><TD><P>NS</P></TD><TD><P>$11.00</P></TD></TR><TR><TD><P><STRONG>11</STRONG></P></TD><TD><P>1177025997013</P></TD><TD><P>11/09/1999</P></TD><TD><P>01/20/2001</P></TD><TD><P>&nbsp;</P></TD><TD><P>1</P></TD><TD><P>1</P></TD><TD><P>A1</P></TD><TD><P>26</P></TD><TD><P>BC</P></TD><TD><P>$154.00</P></TD></TR><TR><TD><P><STRONG>12</STRONG></P></TD><TD><P>1177027515760</P></TD><TD><P>10/19/1999</P></TD><TD><P>01/20/2001</P></TD><TD><P>&nbsp;</P></TD><TD><P>1</P></TD><TD><P>1</P></TD><TD><P>B1</P></TD><TD><P>73</P></TD><TD><P>BC</P></TD><TD><P>$16.00</P></TD></TR><TR><TD><P><STRONG>13</STRONG></P></TD><TD><P>1177028996676</P></TD><TD><P>09/21/2000</P></TD><TD><P>01/20/2001</P></TD><TD><P>&nbsp;</P></TD><TD><P>0</P></TD><TD><P>1</P></TD><TD><P>C1</P></TD><TD><P>.</P></TD><TD><P>QC</P></TD><TD><P>$179.00</P></TD></TR><TR><TD><P><STRONG>14</STRONG></P></TD><TD><P>1177038747105</P></TD><TD><P>03/14/2000</P></TD><TD><P>01/20/2001</P></TD><TD><P>&nbsp;</P></TD><TD><P>0</P></TD><TD><P>1</P></TD><TD><P>C1</P></TD><TD><P>41</P></TD><TD><P>ON</P></TD><TD><P>$705.00</P></TD></TR><TR><TD><P><STRONG>15</STRONG></P></TD><TD><P>1177045857516</P></TD><TD><P>06/22/2000</P></TD><TD><P>01/20/2001</P></TD><TD><P>&nbsp;</P></TD><TD><P>1</P></TD><TD><P>1</P></TD><TD><P>A1</P></TD><TD><P>53</P></TD><TD><P>QC</P></TD><TD><P>$83.00</P></TD></TR><TR><TD><P><STRONG>16</STRONG></P></TD><TD><P>1177057406016</P></TD><TD><P>09/21/2000</P></TD><TD><P>01/20/2001</P></TD><TD><P>&nbsp;</P></TD><TD><P>0</P></TD><TD><P>1</P></TD><TD><P>C1</P></TD><TD><P>50</P></TD><TD><P>ON</P></TD><TD><P>$529.00</P></TD></TR><TR><TD><P><STRONG>17</STRONG></P></TD><TD><P>1177066422248</P></TD><TD><P>04/26/1999</P></TD><TD><P>01/15/2001</P></TD><TD><P>NEED</P></TD><TD><P>0</P></TD><TD><P>1</P></TD><TD><P>A2</P></TD><TD><P>55</P></TD><TD><P>NS</P></TD><TD><P>$44.00</P></TD></TR><TR><TD><P><STRONG>18</STRONG></P></TD><TD><P>1177089399155</P></TD><TD><P>08/17/2000</P></TD><TD><P>01/20/2001</P></TD><TD><P>&nbsp;</P></TD><TD><P>1</P></TD><TD><P>3</P></TD><TD><P>A1</P></TD><TD><P>56</P></TD><TD><P>BC</P></TD><TD><P>$548.00</P></TD></TR><TR><TD><P><STRONG>19</STRONG></P></TD><TD><P>1177113886410</P></TD><TD><P>09/13/2000</P></TD><TD><P>01/08/2001</P></TD><TD><P>COMP</P></TD><TD><P>0</P></TD><TD><P>1</P></TD><TD><P>C1</P></TD><TD><P>45</P></TD><TD><P>ON</P></TD><TD><P>$63.00</P></TD></TR><TR><TD><P><STRONG>20</STRONG></P></TD><TD><P>1177128264924</P></TD><TD><P>12/10/1999</P></TD><TD><P>01/20/2001</P></TD><TD><P>&nbsp;</P></TD><TD><P>1</P></TD><TD><P>1</P></TD><TD><P>B1</P></TD><TD><P>38</P></TD><TD><P>ON</P></TD><TD><P>$178.00</P></TD></TR></TBODY></TABLE><P>&nbsp;</P> Sun, 05 Nov 2017 14:04:51 GMT https://communities.sas.com/t5/Statistical-Procedures/Sum-across-month-date-and-recurring-item-code/m-p/410670#M21462 Azhar_ca 2017-11-05T14:04:51Z https://communities.sas.com/t5/Statistical-Procedures/Sum-across-month-date-and-recurring-item-code/m-p/410690#M21463 <P>I think you are looking for this:</P> <P>&nbsp;</P> <P>proc freq data=have;</P> <P>tables deactdt;</P> <P>format deactdt monyy7.;</P> <P>run;</P> <P>&nbsp;</P> <P>If that's not it, you might need to add some detail about the outcome you are seeking.</P> Sun, 05 Nov 2017 17:59:43 GMT https://communities.sas.com/t5/Statistical-Procedures/Sum-across-month-date-and-recurring-item-code/m-p/410690#M21463 Astounding 2017-11-05T17:59:43Z https://communities.sas.com/t5/Statistical-Procedures/Sum-across-month-date-and-recurring-item-code/m-p/410738#M21477 Thats astounding solution, simple and smart<BR />Thanks again for sharing the code.<BR /><BR />Thanks Mon, 06 Nov 2017 01:50:10 GMT https://communities.sas.com/t5/Statistical-Procedures/Sum-across-month-date-and-recurring-item-code/m-p/410738#M21477 Azhar_ca 2017-11-06T01:50:10Z