topic how to replace two double quote by a single double quote using tranwrd in SAS Enterprise Guide

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

alepage — Thu, 07 Sep 2023 18:50:47 GMT

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 — Thu, 07 Sep 2023 19:06:25 GMT

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.