Grand total in datastep or proc sql

[Q1983]

data have;

input Type $ State $ No;

datalines;

Failed AR 10

Failed AR 5

Passed MD 25

Failed MD 8

Passed MO 22

Passed MO 22

Failed NY 2

;

run;

Type	State	No
Failed	AR	10
Failed	AR	5
Passed	MD	25
Failed	MD	8
Passed	MO	22
Passed	MO	22
Failed	NY	2
desired results is
Type	State	No
Failed	AR	15
Passed	MD	25
Failed	MD	8
Passed	MO	44
Failed	NY	2
TOTAL	Affected	94

How can I get TOTAL in Type field, Affected in State field and the grand total at the end of No

[novinosrin]

Looking to create a report or dataset output?

[novinosrin · Accepted solution]

If report, numerous pseudo codes for proc report and proc print are avaliable online.

If dataset, then 

data have;

input Type $ State $ No;

datalines;
Failed AR 10
Failed AR 5
Passed MD 25
Failed MD 8
Passed MO 22
Passed MO 22
Failed NY 2

;

proc sql;
create table want as
select type,state, sum(no) as no_sum
from have
group by type,state
union 
select 'total' as type,'affected' as state, sum(no)  as no_sum
from have;
quit;