The SAS Output Delivery System and reporting techniques

byvariable grouping and selective bold text

Accepted Solution Solved
Reply
Contributor
Posts: 35
Accepted Solution

byvariable grouping and selective bold text

[ Edited ]

I am using the following sas statement for grouping my by variables, which is color type ;

 

TITLE bold    f= Calibri j=c h=12pt    "#byval(Type)";

i get result:

 

Type: yellow

 

Type: Orange

 

What i want is :

 

Type: yellow

 

Type: orange

 

so the values are not bold but the grouping variable is.

 

Any suggestions !

 

 

 

 


Accepted Solutions
Solution
‎01-02-2017 05:02 PM
SAS Super FREQ
Posts: 8,864

Re: byvariable grouping and selective bold text

Hi:

  Using ODS ESCAPECHAR should be able to do that for you. You'll have to take the instruction for BOLD out of your title statement and move it inside a style override. Something like this (used color so you could see how each ODS ESCAPECHAR style override impacted the title string):

ods escapechar='^';
proc sort data=sashelp.class out=class;
where age in (12 13 14);
by age name;
run;

options nobyline;

ods html(id=ht) file='c:\temp\style_byline_info.html';
TITLE f=Calibri j=c h=12pt '^{style[fontweight=bold color=navy] #byvar(Age):} ^{style[fontweight=medium color=purple]#byval(Age)}';
proc print data=class;
by age;
var name age height weight sex;
run;
ods html(id=ht) close;

 

The code uses SASHELP.CLASS, so you should be able to run it.

 

cynthia

View solution in original post


All Replies
Solution
‎01-02-2017 05:02 PM
SAS Super FREQ
Posts: 8,864

Re: byvariable grouping and selective bold text

Hi:

  Using ODS ESCAPECHAR should be able to do that for you. You'll have to take the instruction for BOLD out of your title statement and move it inside a style override. Something like this (used color so you could see how each ODS ESCAPECHAR style override impacted the title string):

ods escapechar='^';
proc sort data=sashelp.class out=class;
where age in (12 13 14);
by age name;
run;

options nobyline;

ods html(id=ht) file='c:\temp\style_byline_info.html';
TITLE f=Calibri j=c h=12pt '^{style[fontweight=bold color=navy] #byvar(Age):} ^{style[fontweight=medium color=purple]#byval(Age)}';
proc print data=class;
by age;
var name age height weight sex;
run;
ods html(id=ht) close;

 

The code uses SASHELP.CLASS, so you should be able to run it.

 

cynthia

Contributor
Posts: 35

Re: byvariable grouping and selective bold text

Posted in reply to Cynthia_sas
ods escapecar is life saver
☑ This topic is solved.

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

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