topic Re: Escaping ODS ESCAPECHAR in data in SAS Programming

Escaping ODS ESCAPECHAR in data

KatjaGlass — Wed, 11 Mar 2020 15:16:52 GMT

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

Re: Escaping ODS ESCAPECHAR in data

tomrvincent — Wed, 11 Mar 2020 15:25:34 GMT

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

Re: Escaping ODS ESCAPECHAR in data

data_null__ — Wed, 11 Mar 2020 16:00:33 GMT

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.

Re: Escaping ODS ESCAPECHAR in data

data_null__ — Wed, 11 Mar 2020 16:12:08 GMT

Test this...

text = "10^^6";OUTPUT;