I am trying to write a code that would calculate the Cycle_Demand (Sum of demand for each item_id between the delivery_day and the day before the next delivery_day). Can you please provide any ideas on how to address in SAS? Thank you for your expertise and insight. Item Day_of_Week Delivery_Date Date Demand Cycle_Demand xds1 Monday Monday 5/14/2018 12 22 xds1 Tuesday 5/15/2018 10 xds1 Wednesday Wednesday 5/16/2018 14 14 xds1 Thursday 5/17/2018 0 xds1 Friday Friday 5/18/2018 15 33 xds1 Saturday 5/19/2018 9 xds1 Sunday 5/20/2018 9 xds1 Monday Mon 5/21/2018 8 16 xds1 Tuesday 5/22/2018 8 xds1 Wednesday Wed 5/23/2018 7 14 xds1 Thursday 5/24/2018 7 xds1 Friday Fri 5/25/2018 7 38 xds1 Saturday 5/26/2018 6 xds1 Sunday 5/27/2018 12 xds1 Monday 5/28/2018 13 ses2 Tuesday Tue 5/15/2018 10 24 ses2 Wednesday 5/16/2018 14 ses2 Thursday Thu 5/17/2018 0 41 ses2 Friday 5/18/2018 15 ses2 Saturday 5/19/2018 9 ses2 Sunday 5/20/2018 9 ses2 Monday 5/21/2018 8 ses2 Tuesday Tue 5/22/2018 8 15 ses2 Wednesday 5/23/2018 7 ses2 Thursday Thu 5/24/2018 7 44 ses2 Friday 5/25/2018 7 ses2 Saturday 5/26/2018 6 ses2 Sunday 5/27/2018 15 ses2 Monday 5/28/2018 9
... View more