topic Re: Total per day in SAS Programming

Total per day

MarkusB — Fri, 10 Jan 2020 13:31:23 GMT

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.

Re: Total per day

PeterClemmensen — Fri, 10 Jan 2020 13:36:00 GMT

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;

Re: Total per day

novinosrin — Fri, 10 Jan 2020 13:41:16 GMT

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;

Re: Total per day

MarkusB — Fri, 10 Jan 2020 13:45:47 GMT

This works! Thanks a lot.