proc summary - only the total row

[ywon111]

I have a simple code that creates this output but I need the total. Is there a way to get that added?

Ethnicity Clients
A 2822
B 929
C 383
D 471
E 179

Total 4784

proc summary data=want nway missing;
by ethnicity;
output out=test (drop=_type_ rename=(_freq_ = number));
run;

[Reeza]

Remove the NWAY and filter the results using the _TYPE_ column.
_TYPE_ = 0 is the total.

---

@ywon111 wrote:

I have a simple code that creates this output but I need the total. Is there a way to get that added?

Ethnicity Clients
A 2822
B 929
C 383
D 471
E 179

Total 4784

proc summary data=want nway missing;
by ethnicity;
output out=test (drop=_type_ rename=(_freq_ = number));
run;

---

[Kurt_Bremser]

An example using PROC REPORT off SASHELP.CARS:

proc report data=sashelp.cars;
column origin n;
define origin / group;
define n / "Number";
rbreak after / summarize;
compute after;
  origin = "Total";
endcomp;
run;

[andreas_lds]

Because you have only one by/class variable removing "nway" and adding "descendtypes" from/to the proc summary statement.

[Ksharp · Accepted solution]

proc sql;
create table want as
select bp_status length=40,count(*) as clients
 from sashelp.heart
  group by bp_status
union all
select 'Total',count(*) from sashelp.heart
;
quit;

[PaigeMiller]

Remove NWAY and use 

class ethnicity;

instead of 

by ethnicity;