topic @R/RTF'\qc remove the single quote in title string? in SAS Programming

@R/RTF'\qc remove the single quote in title string?

tinaz5012 — Wed, 22 Sep 2021 17:06:51 GMT

Hi All,

I am using title&t"@R/RTF'\qc %str(%bquote(&&myheader&k))"; to set the content of my title in report.

There is a single quote mark in string &&myheader&k, when I use %put to print this macro variable, the output is fine, single quote mark is there, or if I delete @R/RTF'\qc, the title in output also contains single quote.

but if I use title&t"@R/RTF'\qc %str(%bquote(&&myheader&k))", the title in output removed the single quote in my original title. I guess it is caused by single quote in @R/RTF'\qc.

can anyone please advise how to resolve this problem?

Many thanks

Re: @R/RTF'\qc remove the single quote in title string?

sbxkoenk — Wed, 22 Sep 2021 19:31:59 GMT

Hello,

Is this solving your problem (%-sign !!);

%LET t=1;
%LET k=2;
%LET myheader2=%nrstr(a%'bc);
title; footnote;
title&t. "@R/RTF'\qc %str(%nrbquote(&&myheader&k))";
proc print data=sashelp.class(obs=5); run;

Koen

Re: @R/RTF'\qc remove the single quote in title string?

tinaz5012 — Thu, 23 Sep 2021 19:14:51 GMT

Awesome! Thank you very much!