The SAS Output Delivery System and reporting techniques

proc REPORT column's label style

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 11
Accepted Solution

proc REPORT column's label style

hello,

I'm trying to style an independent column label. I understand how to style in define sections, but how about a label? Let me explain by example what I mean:

proc report data=sashelp.class

style(header)=[color=blue background=aliceblue];

column ("Section" (""((name))))

        ("Another section"("Subsection"(sex age))) ;

define name / group style(header)=[backgroundcolor=alicegreen foreground=green fontweight=light];

define sex / group style(header)=[backgroundcolor=alicegreen foreground=green fontweight=light];

define age / group style(header)=[backgroundcolor=alicegreen foreground=green fontweight=light];

run;

a.png

And I'd like to style "Subsection" same as name,sex,age.


Accepted Solutions
Solution
‎01-07-2015 05:21 AM
Esteemed Advisor
Esteemed Advisor
Posts: 7,190

Re: proc REPORT column's label style

Hi,

You don't indicate ods destination.  I will assume RTF:

ods escapechar="^" noresults;

ods rtf file="s:\temp\rob\test.rtf";

proc report data=sashelp.class  nowd

style(header)=[color=blue background=aliceblue]; 

column ("Section" (""((name))))  

        ("Another section"("^S={color=green}Subsection" (sex age))) ; 

define name / group style(header)=[backgroundcolor=alicegreen foreground=green fontweight=light];  

define sex / group style(header)=[backgroundcolor=alicegreen foreground=green fontweight=light];  

define age / group style(header)=[backgroundcolor=alicegreen foreground=green fontweight=light]; 

run;  

ods rtf close;

Note the escaped style before Subsetcion where I change the color.  You can put fonts, sizes etc.

View solution in original post


All Replies
Solution
‎01-07-2015 05:21 AM
Esteemed Advisor
Esteemed Advisor
Posts: 7,190

Re: proc REPORT column's label style

Hi,

You don't indicate ods destination.  I will assume RTF:

ods escapechar="^" noresults;

ods rtf file="s:\temp\rob\test.rtf";

proc report data=sashelp.class  nowd

style(header)=[color=blue background=aliceblue]; 

column ("Section" (""((name))))  

        ("Another section"("^S={color=green}Subsection" (sex age))) ; 

define name / group style(header)=[backgroundcolor=alicegreen foreground=green fontweight=light];  

define sex / group style(header)=[backgroundcolor=alicegreen foreground=green fontweight=light];  

define age / group style(header)=[backgroundcolor=alicegreen foreground=green fontweight=light]; 

run;  

ods rtf close;

Note the escaped style before Subsetcion where I change the color.  You can put fonts, sizes etc.

Occasional Contributor
Posts: 11

Re: proc REPORT column's label style

Thank you!

☑ This topic is SOLVED.

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

Discussion stats
  • 2 replies
  • 368 views
  • 0 likes
  • 2 in conversation