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.
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;
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;
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.