1. We have a data set where every day new data will be appended to the data set. He wants the last week total transaction amount by the product, however, it should be dynamic.

[chittamsri1_gmail_com]

1. We have a data set where every day new data will be appended to the data set. He wants the last week total transaction amount by the product, however, it should be dynamic.

[DBailey]

proc sql;

select

product,

sum(amount) as transaction_amount

from

     work.have

where

     DateAdded >= date()-7

group by product;

quit;

[Ksharp]

You can use %sysfunc(today()) to get last week number and get the amount of transaction .