Escaping ODS ESCAPECHAR in data

[KatjaGlass]

Hi,

is there a way to escape the ODS ESCAPECHAR?

We have a validated SAS Macro to create RTF reports which uses "^" as ODS Escapechar and now CDISC has changed the controlled terminology to use "10^6" instead of "10E6". So in our data we have "^" which we must print in the report. It is not possible to change the macro and not possible to omit the value. But we can update the input dataset as long as "^" is printed to the output. Can I somehow escape it? Using ASCII codes or anything?

Here a simplyfied example:

DATA content;

text = "hallo";OUTPUT;

text = "10^6";OUTPUT;

text = "world";OUTPUT;

RUN;

ODS ESCAPECHAR="^";

ODS RTF FILE="escapechar.rtf";

TITLE "Table Example";

PROC REPORT DATA=content;

RUN;

ODS RTF CLOSE;

Thanks and best regards,

Katja

[tomrvincent]

Wouldn't it be easier to translate ^ back to E in the data before doing the proc report?

[data_null__]

Seems like the validation process for "a validated SAS Macro to create RTF reports which uses "^" as ODS Escapechar"

would have turned-up the need for way to changed the ESCAPECHAR.   Have you look at the parameters of the "validated" macro to see what options you may have in place to solve this problem.

[data_null__ · Accepted solution]

Test this...

text = "10^^6";OUTPUT;