topic Re: How to remove double quote in a macro variable in SAS Programming

How to remove double quote in a macro variable

bmsampath — Wed, 28 Dec 2016 18:31:28 GMT

Hi,

I have the following issue in Macro code.

%let name = "sam'path";

Here I need to remove double quote and need to store the value sam'path in a new macro variable.

I tried many options and it is not wokring.

Please suggest a solution for this .

Thanks,

Sampath

Re: How to remove double quote in a macro variable

AhmedAl_Attar — Wed, 28 Dec 2016 18:33:10 GMT

Use %unquote(&name);

Re: How to remove double quote in a macro variable

AhmedAl_Attar — Wed, 28 Dec 2016 18:38:03 GMT

If previous tip did not work, try this
%let name = "sam'path";
%let name_unquoted = %qsysfunc(compress(&name,%str(%")));
%put name_unquoted =%superq(name_unquoted);

Re: How to remove double quote in a macro variable

bmsampath — Wed, 28 Dec 2016 18:47:53 GMT

Big Thanks for the solution.!!! Your 2nd solution fixed the issue.

Re: How to remove double quote in a macro variable

Ksharp — Thu, 29 Dec 2016 04:47:56 GMT

%let name = "sam'path";
%let name_unquoted = %qsysfunc(dequote(&name));

%put &name_unquoted;