replace " with '

Obsidian | Level 7

replace " with '

Posted 06-13-2012 04:49 AM (1866 views)

How to replace " with ' in marcovariable?

4 REPLIES 4

Calcite | Level 5

Re: replace " with '

Posted 06-13-2012 05:35 AM (1760 views) | In reply to tom12122

tranwrd

Obsidian | Level 7

Re: replace " with '

Posted 06-13-2012 05:46 AM (1760 views) | In reply to MikeTurner

ok, but how use special characters " ' with tranwrd

Tourmaline | Level 20

Re: replace " with '

Posted 06-13-2012 08:34 AM (1760 views) | In reply to tom12122

Try %BQUOTE

Data never sleeps

Super User

Re: replace " with '

Posted 06-13-2012 10:38 PM (1760 views) | In reply to tom12122

EXAMPLE:

%let old= %str( Everyone%" is %"here. old%"s one. ) ;
%let new=%qsysfunc(translate(&old,%str(%'),%str(%")));

%put %bquote(&new);

Ksharp

April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Call for Content EXTENDED

Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.

Submit your proposal!

replace " with '

Re: replace " with '

Re: replace " with '

Re: replace " with '

Re: replace " with '

Registration is open

Call for Content EXTENDED

SAS Training: Just a Click Away