Total per day

[MarkusB]

Hello,

I have some quantity data on a daily basis. The date is formatted as DDMMYYN10.:

Date              Quantity

01JAN2020   10

01JAN2020   20

02JAN2020   15

02JAN2020   25

02JAN2020   10

03JAN2020     5

03JAN2020   15

03JAN2020   20

Now I'd like to create a table with the total quantity per day (without proc time series). The resulting table should look like this:

Date              Total Quantity

01JAN2020   30

02JAN2020   50

03JAN2020   40

How do I get that? I have tried numerous approaches (including calculating totals for each by group) but couldn't produce the above table. Any help would be greatly appreciated.

[PeterClemmensen]

One way

data have;
input Date :date9. Quantity;
format Date date9.;
datalines;
01JAN2020   10
01JAN2020   20
02JAN2020   15
02JAN2020   25
02JAN2020   10
03JAN2020   5
03JAN2020   15
03JAN2020   20
;

proc sql;
    create table want as 
    select Date, Sum(Quantity) as TotalQuantity
    from have
    group by Date;
quit;

[novinosrin · Accepted solution]

HI @MarkusB   Master statsman @PaigeMiller would recommend PROC Summary

data have;
input Date :date9. Quantity;
format Date date9.;
datalines;
01JAN2020   10
01JAN2020   20
02JAN2020   15
02JAN2020   25
02JAN2020   10
03JAN2020   5
03JAN2020   15
03JAN2020   20
;

proc summary data=have nway;
class date;
var quantity;
output out=want(drop=_:) sum=total_quantity;
run;

[MarkusB]

This works! Thanks a lot.