topic Tranwrd a single quotation mark in Macro Var in SAS Programming

Tranwrd a single quotation mark in Macro Var

sburnos — Fri, 26 Apr 2019 14:27:32 GMT

Dear SAS community,

Struggling with an issue to add a single quote symbol into a macro var by function twanwrd and add it to a label of a variable.

The idea, that I want to have a label of a var as "Smith' car". At the moment I have a macro var "SmithZZZ car".

This is the code I am using:

%let have=SmithZZZ car;

data temp;
var1="have";
var2="want";
label var1="&have";

%let want=%sysfunc(tranwrd(%bquote(&have),%str(ZZZ),%str(%')));
label var2="&want";

run;

this code does not work, and I tried many ways to solve the issue, but without success.

Could anyone propose a solution?

Re: Tranwrd a single quotation mark in Macro Var

PaigeMiller — Fri, 26 Apr 2019 14:39:13 GMT

So, I can't see any purpose for your data step. The following ought to work:

%let have=SmithZZZ car;
%put &=have;

%let want=%qsysfunc(tranwrd(&have,ZZZ,%str(%')));
%put &=want;

or even simpler, without macro variables

data a;
    have='SmithZZZ car';
    want=tranwrd(have,'ZZZ',"'");
run;

Re: Tranwrd a single quotation mark in Macro Var

sburnos — Fri, 26 Apr 2019 14:48:58 GMT

Thank you a lot. Have spent a day on searching for a solution. You replied within 10 minutes.

For the future will use the help of SAS community more frequently.

Regarding data step, my ultimate goal was to assign the value of macro variable to a label. Therefore I needed that.

Re: Tranwrd a single quotation mark in Macro Var

Ksharp — Fri, 26 Apr 2019 15:12:58 GMT

%let have=SmithZZZ car;
%let want=%bquote(%sysfunc(prxchange(s/Z+\b/%str(%')/i,1,&have)));

%put &have;
%put &want;

title "&want";
proc print data=sashelp.class;run;