Thank you all for your responses,   All the solution provided are 100% working.   Thank you again @PaigeMiller  @Kurt_Bremser  @ballardw  ... View more

Thank you for your response, Unfortunately, this solution is giving me the sum of all operations for each store, and not only the outstanding living amount per date,    I'll try explaining the problem differently,   let's think of each operation as a loan, in which each store toke an amount from the bank, that goes from start_date to end_date;    the data I have is this :  Operation Star_date End_Date Store Amount operation 1 01/01/2019 09/01/2019 LA 200 operation 1 01/01/2019 09/01/2019 LB 1500 operation 1 01/01/2019 09/01/2019 LZ 1600 operation 1 01/01/2019 09/01/2019 LO 1300 operation 1 01/01/2019 09/01/2019 LU 1400 operation 1 01/01/2019 09/01/2019 LF 600           operation 2 05/01/2019 09/01/2019 LH 800 operation 2 05/01/2019 09/01/2019 LC 2200 operation 2 05/01/2019 09/01/2019 LG 2200 operation 2 05/01/2019 09/01/2019 LL 2000 operation 2 05/01/2019 09/01/2019 LD 2000 operation 2 05/01/2019 09/01/2019 LK 1300         600 operation 3 10/01/2019 19/01/2019 LB 1500 operation 3 10/01/2019 19/01/2019 LG 2800 operation 3 10/01/2019 19/01/2019 LC 2900 operation 3 10/01/2019 19/01/2019 LD 2600 operation 3 10/01/2019 19/01/2019 LF 2700 operation 3 10/01/2019 19/01/2019 LL 1900   Now, I want to calculate, for each store, the outstanding loan amount per day between 01JAN2019 and 31DEC2019;   so the Data I want should look like this:    Date LA LB LC 01/01/2019          200,00        1 500,00                     -     02/01/2019          200,00        1 500,00                     -     03/01/2019          200,00        1 500,00                     -     04/01/2019          200,00        1 500,00                     -     05/01/2019          200,00        1 500,00        2 200,00   06/01/2019          200,00        1 500,00        2 200,00   07/01/2019          200,00        1 500,00        2 200,00   08/01/2019          200,00        1 500,00        2 200,00   09/01/2019                   -                       -                       -     10/01/2019                   -          1 500,00        2 900,00   11/01/2019                   -          1 500,00        2 900,00   12/01/2019                   -          1 500,00        2 900,00   13/01/2019                   -          1 500,00        2 900,00   14/01/2019                   -          1 500,00        2 900,00   15/01/2019                   -          1 500,00        2 900,00   16/01/2019                   -          1 500,00        2 900,00   17/01/2019                   -          1 500,00        2 900,00   18/01/2019                   -          1 500,00        2 900,00   19/01/2019                   -                       -                       -     20/01/2019                   -                       -                       -     21/01/2019                   -                       -                       -     22/01/2019                   -                       -                       -       I provided an excel file below with the calculations done using formulas, I hope it helps;   Thank you again. ... View more

Thank you for your help,   The data want for store LA should look like this :     LA 01/01/2019 200 02/01/2019 200 03/01/2019 200 04/01/2019 200 05/01/2019 620 06/01/2019 620 07/01/2019 620 08/01/2019 620 09/01/2019 1200 10/01/2019 1200 11/01/2019 1200 12/01/2019 1200 13/01/2019 1200 14/01/2019 1200 15/01/2019 1200 16/01/2019 0   The amount shown in each date in the want data set is : the sum of amount in have, if the start_date is less or equal to date, and if the end_date is greater than date   in other words, the amount for a given date is the sum of operations that are alive at that date   an operation is alive if its end_date is after the current date, if not it's a finished operation.   for example, in the 8th January, the amount shown is the sum of 200 and 420, because the start date for these two operations is before the 8th, and their end date is after the 8th, the next day ( the 9th january), these twp operations will die, and the amount will become 1200 ( equal to the sum of operations alive : 3rd operation) ... View more

Thank you for your help,   The data want for store LA should look like this :     LA 01/01/2019 200 02/01/2019 200 03/01/2019 200 04/01/2019 200 05/01/2019 620 06/01/2019 620 07/01/2019 620 08/01/2019 620 09/01/2019 1200 10/01/2019 1200 11/01/2019 1200 12/01/2019 1200 13/01/2019 1200 14/01/2019 1200 15/01/2019 1200 16/01/2019 0   The amount shown in each date in the want data set is : the sum of amount in have, if the start_date is less or equal to date, and if the end_date is greater than date   in other words, the amount for a given date is the sum of operations that are alive at that date an operation is alive if its end_date is after the current date, if not it's a finished operation.   for example, in the 8th January, the amount shown is the sum of 200 and 420, because the start date for these two operations is before the 8th, and their end date is after the 8th,  the next day ( the 9th january), these twp operations will die, and the amount will become 1200 ( equal to the sum of operations alive : 3rd operation)   ... View more

Thank you for your prompt response, My output should be a SAS data table as well,   So in explanation to the data set, for each store there is a buying operation that lasts from the start_date to the end_date; in each buying operation we can have different stores ( not necessarily all stores will buy) also, we can have multiple buying operations overlapping;   What I want to do is to calculate, for each store, the daily amount that have been bought, and is always withstanding;   for this I will need to use a conditional sum, by store, and by date for example, in 01jan2019, for store1, the withstanding amount is the sum of the amount variable, for all operations that have a starting date before 01jan2019, and an end_date after 01jan2019   if I were to write this in excel for example, i would use a sumifs with multiple conditions as follow :   for each date in the want data set    =sumif(amount ;  store ; store1 ;  start_date  ;  "<="&"date"  ; end_date  ; ">"&"date"  )   I hope this is clear, Thank you again for your response     ... View more