topic Grand total in datastep or proc sql in SAS Programming

Grand total in datastep or proc sql

Q1983 — Tue, 25 Sep 2018 23:26:31 GMT

data have;

input Type $ State $ No;

datalines;

Failed AR 10

Failed AR 5

Passed MD 25

Failed MD 8

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

Re: Grand total in datastep or proc sql

novinosrin — Tue, 25 Sep 2018 23:30:47 GMT

Looking to create a report or dataset output?

Re: Grand total in datastep or proc sql

novinosrin — Tue, 25 Sep 2018 23:34:02 GMT

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;