When creating reports with PROC REPORT, adding a summary line (grand total) is a common operation, usually performed via the RBREAK statement.
By default, this summary line adopts a standard style defined by the active ODS template (often a light gray or white background). However, for aesthetic or readability reasons, it is often desired that this total line looks exactly like the header row of the table (same background color, same bold font, same text color).
The natural first reaction is to open the ODS template's source code, identify the hexadecimal color codes for the header (e.g., cx112277 for the text and cxEDF2F9 for the background in the HTMLBlue style), and manually copy them into the statement.
1
| 1 | /* À éviter : Code rigide et difficile à maintenir */ |
| 2 | rbreak after / summarize style=[fontweight=bold color=cx112277 backgroundcolor=cxEDF2F9]; |
| 3 |
SAS© allows for direct referencing of existing style elements by their name, rather than redefining their attributes one by one. The style element that controls the appearance of column headers is simply named Header.
There are two simple ways to apply this style to your summary line.
RBREAK StatementThis is the most precise method if you wish to target only the grand total generated by RBREAK.
| 1 | PROC REPORT DATA=sashelp.class; |
| 2 | columns sex weight; |
| 3 | define sex / group; |
| 4 | define weight / analysis mean f=5.2; |
| 5 | |
| 6 | /* On applique directement le style 'Header' à la ligne de résumé */ |
| 7 | rbreak after / summarize style=Header; |
| 8 | RUN; |
STYLE OptionYou can also define this behavior at the level of the PROC REPORT statement itself. This instructs the procedure to use the "Header" style for any element of type "summary".
| 1 | PROC REPORT DATA=sashelp.class style(summary)=Header; |
| 2 | columns sex weight; |
| 3 | define sex / group; |
| 4 | define weight / analysis mean f=5.2; |
| 5 | |
| 6 | rbreak after / summarize; |
| 7 | RUN; |
The main advantage is portability. By using style=Header, you are telling SAS©: "Regardless of the ODS template I use (PDF, HTML, RTF), make my total look like my headers". If you change the overall style of your report, the total line will automatically adapt without you needing to modify a single line of code.
The codes and examples provided on WeAreCAS.eu are for educational purposes. It is imperative not to blindly copy-paste them into your production environments. The best approach is to understand the logic before applying it. We strongly recommend testing these scripts in a test environment (Sandbox/Dev). WeAreCAS accepts no responsibility for any impact or data loss on your systems.