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;
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:
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.