topic Re: 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. in SAS Procedures

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 — Mon, 21 Apr 2014 13:21:34 GMT

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.

Re: 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 — Mon, 21 Apr 2014 13:28:26 GMT

proc sql;

select

product,

sum(amount) as transaction_amount

from

work.have

where

DateAdded >= date()-7

group by product;

quit;

Re: 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.

Ksharp — Mon, 21 Apr 2014 13:32:24 GMT

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