The SAS Output Delivery System and reporting techniques

Proc Report Headers

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 16
Accepted Solution

Proc Report Headers

Hi,

 

Is it possible for PROC REPORT to produce a table with different colours for different headings.

e.g. fieldheader1, fieldheader2 --> yellow, fieldheader3 -->blue.

 

Would it be something in the beginning of PROC REPORT syntax?

 

Proc report data= bigdata
Nowd Headline Headskip
Style(Summary)=[Foreground=Black Background=CXAEADD9 Font_Face=Arial]
Style(Header) =[Background=#0091C8
Foreground=White Font_Size=2 Font_Face=Arial Font_Weight=Bold
Just=Center whitespace=NOWRAP WIDTH=100% height=27pt tagattr='wrap:yes']
Style(Column) =[Foreground=Black Background=White Font_size=2 Font_Face=Arial whitespace=NOWRAP WIDTH = 100% ];

 

Thanks

David


Accepted Solutions
Solution
‎08-08-2017 07:24 PM
SAS Super FREQ
Posts: 708

Re: Proc Report Headers

See code sample below, you can control this in the DEFINE statement

 

proc report data=sashelp.class;
  column name age sex;
  define age / style(header)={background=red};
  define sex / 
    style(header)={background=yellow}
    style(column)={background=grey foreground=blue}
  ;
run;

View solution in original post


All Replies
Solution
‎08-08-2017 07:24 PM
SAS Super FREQ
Posts: 708

Re: Proc Report Headers

See code sample below, you can control this in the DEFINE statement

 

proc report data=sashelp.class;
  column name age sex;
  define age / style(header)={background=red};
  define sex / 
    style(header)={background=yellow}
    style(column)={background=grey foreground=blue}
  ;
run;
Occasional Contributor
Posts: 16

Re: Proc Report Headers

Posted in reply to Bruno_SAS

Thank you Bruno, that worked perfectly.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 294 views
  • 2 likes
  • 2 in conversation