I am working on this daily report and try to find a way to get what I want. So here is the example: If Today(the date I run SAS) is Monday, Sep 7, 2015 , then I need the 'Want' column. The challenge part is the Friday, September 04, 2015's want number, I need it to be the sum of Have column from Friday Sep 04 to Sunday Sep 06th.      Is it possible to get it?    Date Have  Want Tuesday, September 01, 2015 2 2 Wednesday, September 02, 2015 3 3 Thursday, September 03, 2015 4 4 Friday, September 04, 2015 5 12 Saturday, September 05, 2015 2 0 Sunday, September 06, 2015 5 0     Thanks ... View more