Proc report

ywon111 — Sat, 25 Apr 2020 14:31:50 GMT

Trying to create a table like this:

Region	Gender	Number
A	f	2
	m	2
B	f	2
	m	2
C	f	2
	m	2
Total	f	6
	m	6

Have tried this, but not getting the total by gender (last two rows in the table)

proc report data=final style(summary)=header;

column region gender n;
define region/group style (column)=Header;
define gender/group;
define n / 'Total';
break after region / summarize ;

rbreak after/summarize;

run;

Thanks

Re: Proc report

Cynthia_sas — Sat, 25 Apr 2020 21:37:17 GMT

Hi:

PROC REPORT will not give you a total line like you want without manipulating the data in advance or perhaps using a more advanced COMPUTE block. But PROC TABULATE will easily do what you want:

Hope this helps,

Cynthia

topic Proc report in SAS Programming

Proc report

Re: Proc report