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 🙂