https://communities.sas.com/t5/New-SAS-User/Data-for-rolling-sum/m-p/541531#M7384 <P>Any rules involved in this description?</P> <P>I really am not sure what you want to do.</P> <P>I don't see any sum involved much less "rolling sum" in the title.</P> Fri, 08 Mar 2019 18:56:40 GMT ballardw 2019-03-08T18:56:40Z https://communities.sas.com/t5/New-SAS-User/Data-for-rolling-sum/m-p/541458#M7372 <P>Hi</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Input</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Date</TD><TD>dest_id</TD><TD>qty</TD><TD>Case_Qty</TD></TR><TR><TD>03Mar2019</TD><TD>12305</TD><TD>0</TD><TD>12</TD></TR><TR><TD>04Mar2019</TD><TD>12305</TD><TD>0</TD><TD>0</TD></TR><TR><TD>05Mar2019</TD><TD>12305</TD><TD>0</TD><TD>0</TD></TR><TR><TD>06Mar2019</TD><TD>12305</TD><TD>0</TD><TD>0</TD></TR><TR><TD>07Mar2019</TD><TD>12305</TD><TD>0</TD><TD>0</TD></TR><TR><TD>08Mar2019</TD><TD>12305</TD><TD>5</TD><TD>0</TD></TR><TR><TD>09Mar2019</TD><TD>12305</TD><TD>0</TD><TD>0</TD></TR><TR><TD>10Mar2019</TD><TD>12305</TD><TD>0</TD><TD>0</TD></TR><TR><TD>11Mar2019</TD><TD>12305</TD><TD>0</TD><TD>0</TD></TR><TR><TD>12Mar2019</TD><TD>12305</TD><TD>0</TD><TD>0</TD></TR><TR><TD>13Mar2019</TD><TD>12305</TD><TD>0</TD><TD>0</TD></TR><TR><TD>14Mar2019</TD><TD>12305</TD><TD>0</TD><TD>0</TD></TR><TR><TD>15Mar2019</TD><TD>12305</TD><TD>6</TD><TD>0</TD></TR><TR><TD>16Mar2019</TD><TD>12305</TD><TD>0</TD><TD>0</TD></TR><TR><TD>17Mar2019</TD><TD>12305</TD><TD>0</TD><TD>0</TD></TR><TR><TD>18Mar2019</TD><TD>12305</TD><TD>0</TD><TD>0</TD></TR><TR><TD>19Mar2019</TD><TD>12305</TD><TD>0</TD><TD>0</TD></TR><TR><TD>20Mar2019</TD><TD>12305</TD><TD>0</TD><TD>0</TD></TR><TR><TD>21Mar2019</TD><TD>12305</TD><TD>0</TD><TD>0</TD></TR><TR><TD>22Mar2019</TD><TD>12305</TD><TD>4</TD><TD>12</TD></TR><TR><TD>23Mar2019</TD><TD>12305</TD><TD>0</TD><TD>0</TD></TR><TR><TD>03Mar2019</TD><TD>12913</TD><TD>0</TD><TD>12</TD></TR><TR><TD>04Mar2019</TD><TD>12913</TD><TD>0</TD><TD>0</TD></TR><TR><TD>05Mar2019</TD><TD>12913</TD><TD>2</TD><TD>0</TD></TR><TR><TD>06Mar2019</TD><TD>12913</TD><TD>0</TD><TD>0</TD></TR><TR><TD>07Mar2019</TD><TD>12913</TD><TD>0</TD><TD>0</TD></TR><TR><TD>08Mar2019</TD><TD>12913</TD><TD>1</TD><TD>0</TD></TR><TR><TD>09Mar2019</TD><TD>12913</TD><TD>0</TD><TD>0</TD></TR><TR><TD>10Mar2019</TD><TD>12913</TD><TD>0</TD><TD>0</TD></TR><TR><TD>11Mar2019</TD><TD>12913</TD><TD>0</TD><TD>0</TD></TR><TR><TD>12Mar2019</TD><TD>12913</TD><TD>4</TD><TD>0</TD></TR><TR><TD>13Mar2019</TD><TD>12913</TD><TD>0</TD><TD>0</TD></TR><TR><TD>14Mar2019</TD><TD>12913</TD><TD>0</TD><TD>0</TD></TR><TR><TD>15Mar2019</TD><TD>12913</TD><TD>0</TD><TD>0</TD></TR><TR><TD>16Mar2019</TD><TD>12913</TD><TD>0</TD><TD>0</TD></TR><TR><TD>17Mar2019</TD><TD>12913</TD><TD>0</TD><TD>0</TD></TR><TR><TD>18Mar2019</TD><TD>12913</TD><TD>0</TD><TD>0</TD></TR><TR><TD>19Mar2019</TD><TD>12913</TD><TD>2</TD><TD>0</TD></TR><TR><TD>20Mar2019</TD><TD>12913</TD><TD>0</TD><TD>0</TD></TR><TR><TD>21Mar2019</TD><TD>12913</TD><TD>0</TD><TD>0</TD></TR><TR><TD>22Mar2019</TD><TD>12913</TD><TD>5</TD><TD>12</TD></TR><TR><TD>23Mar2019</TD><TD>12913</TD><TD>0</TD><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;</P><TABLE><TBODY><TR><TD>&nbsp;Output</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Date</TD><TD>dest_id</TD><TD>qty</TD><TD>FCQ</TD></TR><TR><TD>03Mar2019</TD><TD>12305</TD><TD>0</TD><TD>0</TD></TR><TR><TD>04Mar2019</TD><TD>12305</TD><TD>0</TD><TD>0</TD></TR><TR><TD>05Mar2019</TD><TD>12305</TD><TD>0</TD><TD>0</TD></TR><TR><TD>06Mar2019</TD><TD>12305</TD><TD>0</TD><TD>0</TD></TR><TR><TD>07Mar2019</TD><TD>12305</TD><TD>0</TD><TD>0</TD></TR><TR><TD>08Mar2019</TD><TD>12305</TD><TD>5</TD><TD>12</TD></TR><TR><TD>09Mar2019</TD><TD>12305</TD><TD>0</TD><TD>0</TD></TR><TR><TD>10Mar2019</TD><TD>12305</TD><TD>0</TD><TD>0</TD></TR><TR><TD>11Mar2019</TD><TD>12305</TD><TD>0</TD><TD>0</TD></TR><TR><TD>12Mar2019</TD><TD>12305</TD><TD>0</TD><TD>0</TD></TR><TR><TD>13Mar2019</TD><TD>12305</TD><TD>0</TD><TD>0</TD></TR><TR><TD>14Mar2019</TD><TD>12305</TD><TD>0</TD><TD>0</TD></TR><TR><TD>15Mar2019</TD><TD>12305</TD><TD>6</TD><TD>0</TD></TR><TR><TD>16Mar2019</TD><TD>12305</TD><TD>0</TD><TD>0</TD></TR><TR><TD>17Mar2019</TD><TD>12305</TD><TD>0</TD><TD>0</TD></TR><TR><TD>18Mar2019</TD><TD>12305</TD><TD>0</TD><TD>0</TD></TR><TR><TD>19Mar2019</TD><TD>12305</TD><TD>0</TD><TD>0</TD></TR><TR><TD>20Mar2019</TD><TD>12305</TD><TD>0</TD><TD>0</TD></TR><TR><TD>21Mar2019</TD><TD>12305</TD><TD>0</TD><TD>0</TD></TR><TR><TD>22Mar2019</TD><TD>12305</TD><TD>4</TD><TD>12</TD></TR><TR><TD>23Mar2019</TD><TD>12305</TD><TD>0</TD><TD>0</TD></TR><TR><TD>03Mar2019</TD><TD>12913</TD><TD>0</TD><TD>0</TD></TR><TR><TD>04Mar2019</TD><TD>12913</TD><TD>0</TD><TD>0</TD></TR><TR><TD>05Mar2019</TD><TD>12913</TD><TD>2</TD><TD>12</TD></TR><TR><TD>06Mar2019</TD><TD>12913</TD><TD>0</TD><TD>0</TD></TR><TR><TD>07Mar2019</TD><TD>12913</TD><TD>0</TD><TD>0</TD></TR><TR><TD>08Mar2019</TD><TD>12913</TD><TD>1</TD><TD>0</TD></TR><TR><TD>09Mar2019</TD><TD>12913</TD><TD>0</TD><TD>0</TD></TR><TR><TD>10Mar2019</TD><TD>12913</TD><TD>0</TD><TD>0</TD></TR><TR><TD>11Mar2019</TD><TD>12913</TD><TD>0</TD><TD>0</TD></TR><TR><TD>12Mar2019</TD><TD>12913</TD><TD>4</TD><TD>0</TD></TR><TR><TD>13Mar2019</TD><TD>12913</TD><TD>0</TD><TD>0</TD></TR><TR><TD>14Mar2019</TD><TD>12913</TD><TD>0</TD><TD>0</TD></TR><TR><TD>15Mar2019</TD><TD>12913</TD><TD>0</TD><TD>0</TD></TR><TR><TD>16Mar2019</TD><TD>12913</TD><TD>0</TD><TD>0</TD></TR><TR><TD>17Mar2019</TD><TD>12913</TD><TD>0</TD><TD>0</TD></TR><TR><TD>18Mar2019</TD><TD>12913</TD><TD>0</TD><TD>0</TD></TR><TR><TD>19Mar2019</TD><TD>12913</TD><TD>2</TD><TD>0</TD></TR><TR><TD>20Mar2019</TD><TD>12913</TD><TD>0</TD><TD>0</TD></TR><TR><TD>21Mar2019</TD><TD>12913</TD><TD>0</TD><TD>0</TD></TR><TR><TD>22Mar2019</TD><TD>12913</TD><TD>5</TD><TD>12</TD></TR><TR><TD>23Mar2019</TD><TD>12913</TD><TD>0</TD><TD>0</TD></TR></TBODY></TABLE> Fri, 08 Mar 2019 16:33:41 GMT https://communities.sas.com/t5/New-SAS-User/Data-for-rolling-sum/m-p/541458#M7372 hcbn 2019-03-08T16:33:41Z https://communities.sas.com/t5/New-SAS-User/Data-for-rolling-sum/m-p/541531#M7384 <P>Any rules involved in this description?</P> <P>I really am not sure what you want to do.</P> <P>I don't see any sum involved much less "rolling sum" in the title.</P> Fri, 08 Mar 2019 18:56:40 GMT https://communities.sas.com/t5/New-SAS-User/Data-for-rolling-sum/m-p/541531#M7384 ballardw 2019-03-08T18:56:40Z