Calcite | Level 5

## Total per day

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Tourmaline | Level 20

## Re: Total per day

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;
``````
3 REPLIES 3
Tourmaline | Level 20

## Re: Total per day

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;``````
Tourmaline | Level 20

## Re: Total per day

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;
``````
Calcite | Level 5

## Re: Total per day

This works! Thanks a lot.
Discussion stats
• 3 replies
• 903 views
• 1 like
• 3 in conversation