Put total count on proc report

mmea — Mon, 08 Mar 2021 13:52:29 GMT

Hi I have this code for a proc report;


proc report data=data style(header) = {background = white color = black};
	    columns year week COUNT ;
	    define year/  group style(column)= [background = white font_size=10pt font_weight = bold] style(header) = {background = white frame=void};
		compute after year / style={bordertopcolor=black borderbottomcolor=black height=1px cellpadding=0};
        line ' '; 
        endcomp;
	    define week/  group style(column)= [background = white font_size=8pt] style(header) = {background = white frame=void} ;
		define COUNT/  group style(column)= [background = white font_size=8pt] style(header) = {background = white frame=void};	run;

This give me this kind of table (without the total):

Year	week	count
2020	1	1
	2	3
	3	4
	4	1
2021	1	1
	2	1
	3	1
*Total*		12

I need a total at the end of the table (as shown in the table in bold) - how can I add that? I export to Excel 🙂

Re: Put total count on proc report

andreas_lds — Tue, 09 Mar 2021 08:11:13 GMT

You can find the documentation of proc report here.

The rbreak statement is used to create summary lines.

topic Re: Put total count on proc report in New SAS User

Put total count on proc report

Re: Put total count on proc report