topic Re: proc summary - only the total row in SAS Programming

proc summary - only the total row

ywon111 — Tue, 23 Nov 2021 07:34:16 GMT

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;

Re: proc summary

Reeza — Tue, 23 Nov 2021 04:52:45 GMT

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;

Re: proc summary - only the total row

Kurt_Bremser — Tue, 23 Nov 2021 07:43:25 GMT

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;

Re: proc summary - only the total row

andreas_lds — Tue, 23 Nov 2021 07:49:54 GMT

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

Re: proc summary - only the total row

Ksharp — Tue, 23 Nov 2021 12:04:12 GMT

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;

Re: proc summary - only the total row

PaigeMiller — Tue, 23 Nov 2021 12:20:52 GMT

Remove NWAY and use

class ethnicity;

instead of

by ethnicity;