DATA Step, Macro, Functions and more

replace " with '

Reply
Contributor
Posts: 60

replace " with '

How to replace " with ' in marcovariable?

Contributor
Posts: 49

Re: replace " with '

tranwrd

Contributor
Posts: 60

Re: replace " with '

ok, but how use special characters " ' with tranwrd

Super User
Posts: 5,254

Re: replace " with '

Try %BQUOTE

Data never sleeps
Super User
Posts: 9,662

Re: replace " with '

EXAMPLE:

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

%put %bquote(&new);

Ksharp

Ask a Question
Discussion stats
  • 4 replies
  • 243 views
  • 0 likes
  • 4 in conversation