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
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.
Test this...
text = "10^^6";OUTPUT;
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.