topic Re: Proc Report Headers in ODS and Base Reporting

Proc Report Headers

davidbao — Tue, 08 Aug 2017 04:34:37 GMT

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

Re: Proc Report Headers

BrunoMueller — Tue, 08 Aug 2017 07:03:23 GMT

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;

Re: Proc Report Headers

davidbao — Tue, 08 Aug 2017 23:25:24 GMT

Thank you Bruno, that worked perfectly.