How do you sum amounts in a separate column by date (ie. there are multiple rows for each day?

analyst97725 — Mon, 11 Apr 2022 18:22:41 GMT

I have data that looks like the following as a data set in SAS (goes on for multiple years):

Date	Dollar Amount
07/14/2020	50
07/14/2020	20
07/14/2020	10
07/15/2020	30
07/15/2020	5
07/15/2020	67

I want to sum the dollar amount for each date to return one summed amount for each date in a new table that looks like the following:

Date	Dollar Amount
07/14/2020	80
07/15/2020	102

How do I create this new table?

Re: How do you sum amounts in a separate column by date (ie. there are multiple rows for each day?

PeterClemmensen — Mon, 11 Apr 2022 18:55:35 GMT

data have;
input Date :mmddyy10. DollarAmount;
format Date mmddyy10.;
datalines;
07/14/2020 50
07/14/2020 20
07/14/2020 10
07/15/2020 30
07/15/2020 5
07/15/2020 67
;

proc summary data = have nway;
   class Date;
   var DollarAmount;
   output out = want(drop = _:) sum =;
run;

topic How do you sum amounts in a separate column by date (ie. there are multiple rows for each day? in SAS Programming

How do you sum amounts in a separate column by date (ie. there are multiple rows for each day?

Re: How do you sum amounts in a separate column by date (ie. there are multiple rows for each day?