topic Re: summary output in SAS Programming

summary output

Solly7 — Thu, 09 Jan 2020 06:54:30 GMT

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

Re: summary output

PeterClemmensen — Thu, 09 Jan 2020 07:10:38 GMT

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

Re: summary output

Kurt_Bremser — Thu, 09 Jan 2020 07:21:05 GMT

Alternate method, using SQL:

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

Re: summary output

Solly7 — Thu, 09 Jan 2020 11:02:07 GMT

Thank you so much

Re: summary output

Solly7 — Thu, 09 Jan 2020 11:02:36 GMT

thank you