how to replace two double quote by a single double quote using tranwrd

[alepage]

Imagine that we have ""Name"":""Alain"" in a variable called info.

I would like to replace "" for ", so I will get "Name":"Alain"

I have tried this but it does not works

		Data Info_1;
		set Info_1 ;
		Info=tranwrd(Info,"""",""");
		run;

How do we do that ?

[Amir · Accepted solution]

Hi,

Have you tried surrounding the text with single quotes instead?

Data Info_1;
  set Info_1 ;
  Info=tranwrd(Info,'""','"');
run;

Thanks & kind regards,

Amir.