summary output

[Solly7]

Hi, i need to output summary statistics of "Amount" variable, i need to print sum of amount for an each every month.  see my below data

table name = transactions_info

policy no    Amount     Date 

1                 300           201909

2                 600           201909

3                 900           201910

4                 100           201910

So i need summary output which looks like below

Date         Amount

201909    900

201910    1000

Thanks in advance

[PeterClemmensen · Accepted solution]

data have;
input policyno Amount Date : yymmn6.;
format Date yymmn6.;
datalines;
1 300 201909
2 600 201909
3 900 201910
4 100 201910
;

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

Result:

Date    Amount
201909  900
201910  1000

[Solly7]

Thank you so much

[Kurt_Bremser]

Alternate method, using SQL:

proc sql;
create table want as
select date, sum(amount) as amount
from have
group by date;
quit;

[Solly7]

thank you