Proc report

[ywon111]

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

[Cynthia_sas · Accepted solution]

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