DATA Step, Macro, Functions and more

Proc report -Heading colors

Reply
Frequent Contributor
Posts: 91

Proc report -Heading colors

Hello

I am using proc report

I want that top header "ID info"  and top header "measurement info" will be in yellow background color with big font size.

I want that low header "x" "w" "y" will be with blue background color with small font size.

Can anyone help ?

 

data tbl;
input x w y;
cards;
1 2 3
4 5 6
7 8 9
;
run;

proc report data=tbl nowd headline headskip
STYLE(Header)={background=lightblue foreground=black }
STYLE(column)={background=lightgray foreground=black}
STYLE(report)=[rules=rows bordercolor=black];
/*Title 'גליון 1';*/
column ("ID info" x w) ("measurement info" y) ;
define x / display ;
define w / display ;
define y / display ;
run;

Contributor
Posts: 25

Re: Proc report -Heading colors

Try putting style option in the DEFINE statements, like such:

proc report data=tbl nowd headline headskip
STYLE(Header)={background=yellow foreground=black fontsize=14pt}
STYLE(column)={background=lightgray foreground=black}
STYLE(report)=[rules=rows bordercolor=black];
/*Title 'גליון 1';*/
column ("ID info" x w) ("measurement info" y) ;
define x / display style(hdr)=header{background=lightblue fontsize=10pt};
define w / display style(hdr)=header{background=lightblue fontsize=10pt};
define y / display style(hdr)=header{background=lightblue fontsize=10pt};
run;

See this thread for additional info:

https://communities.sas.com/t5/SAS-Procedures/How-do-I-Change-the-color-of-column-headers-under-an-a...

Ask a Question
Discussion stats
  • 1 reply
  • 68 views
  • 0 likes
  • 2 in conversation