Summing by ID and date

PetePatel — Fri, 12 Oct 2018 08:30:53 GMT

Hi,

I have a dataset in a similar format to below:

I would like to sum by ID and date, and where negative default to 0 as follows:

How can I easily create 'New_Amount' as I am grouping by 2 variables?

Thanks

Re: Summing by ID and date

Kurt_Bremser — Fri, 12 Oct 2018 08:37:08 GMT

Simple in SQL:

proc sql;
create table want as
select id, date, max(sum(amount),0) as new_amount
from have
group by id, date;
quit;