topic Re: Using escapechar with put function? in ODS and Base Reporting

Using escapechar with put function?

SAS93 — Wed, 19 Jan 2022 19:37:38 GMT

I have the following code:

Data year3_insur;
Set year2_insur;	

length newvar $20;

newvar=cat(put(Row_Percent, 4.1),' [',put(Lower_CL, 4.1),'-',put(Upper_CL, 4.1),']');

DROP RowPercent RowLowerCL RowUpperCL ;

Label newvar="% [95% CL]";
Run;

It concatenates 3 numeric variables into a single string that is put into a Proc Report; the string looks like: 90.0 [88.8-99.99].

I want to bold the 90.0 numbers (Row_Percent variable). I've tried using the ODS escapechar feature, but can't get it to work. I'm currently writing it as:

newvar=cat(put(Row_Percent, 4.1)^{style [font_weight=bold],' [',put(Lower_CL, 4.1),'-',put(Upper_CL, 4.1),']');

What am I doing wrong and how can I make this work?

Re: Using escapechar with put function?

Reeza — Wed, 19 Jan 2022 19:51:26 GMT

I see an opening curly brace (before SYTLE) but no closing one and it's not part of the text?

Full example to test?

Similar to this question I believe:
https://communities.sas.com/t5/ODS-and-Base-Reporting/Applying-superscript-to-a-variable-instead-of-text/td-p/789371

Re: Using escapechar with put function?

ballardw — Wed, 19 Jan 2022 21:06:34 GMT

I want to bold the 90.0 numbers (Row_Percent variable). I've tried using the ODS escapechar feature, but can't get it to work.

It appears than you are attempting to add characteristics to the value of a variable.

You do not get to have properties like "bold" as part of the value of a SAS variable. You have to add instructions elsewhere, such as with a Format or style option override.

Trivial if you left the 90.0 as a separate variable. Once you make variables holding multiple values then things get very difficult for such.

Re: Using escapechar with put function?

Reeza — Wed, 19 Jan 2022 21:09:35 GMT

And what's the final output format? This can make a difference.

Re: Using escapechar with put function?

Reeza — Wed, 19 Jan 2022 21:11:47 GMT

@ballardw wrote:

You do not get to have properties like "bold" as part of the value of a SAS variable.

I think it may be possible as in the linked example with the superscript added in to the variable value.

EDIT: Not within a data set, but as output to an Excel file, PDF, HTML, Word doc should be possible.

Re: Using escapechar with put function?

Ksharp — Thu, 20 Jan 2022 12:18:22 GMT

data have;
input v lower upper;
newvar=cat(put(v,4.1),'~S={font_weight=bold} [',put(Lower, 4.1),'-',put(Upper, 4.1),']');
cards;
0.12  0.01 0.24
0.22  0.12 0.54
;

ods escapechar='~';
ods rtf file='c:\temp\temp.rtf' style=journal bodytitle;
proc report data=have nowd;
run;
ods rtf close;