topic Re: Tranwrd function in SAS Procedures

Tranwrd function

sam369 — Wed, 18 Mar 2015 20:04:59 GMT

Hi Experts,

this is have:

%let string=i need apostrophe instead of question mark?ed

want:

i need apostrophe instead of question mark'ed

i am using below

data t;

var="&string";

var1=tranwrd(trim(var),"?",",");

call symput("want",var1);

run;

%put &want;

i am getting error :Literal contains unmatched quote.

Thanks

Sam

Re: Tranwrd function

mohamed_zaki — Wed, 18 Mar 2015 20:29:01 GMT

Your code should work.

Please post the complete log

Re: Tranwrd function

data_null__ — Wed, 18 Mar 2015 20:58:02 GMT

If you are successful you will create a macro variable with and un-quoted single quote. This will need special attention depending on what you do next.

It is probably better to quote the unmatched single quote with %str((%');

32         %let string=i need apostrophe instead of question mark%str(%')ed;
33         %put NOTE: &=string;
NOTE: STRING=i need apostrophe instead of question mark'ed

%let string=i need apostrophe instead of question mark?ed;
 
data _null_; 
   var="&string"; 
   var1=transtrn(trim(var),"?","'");
   call symput("want",var1);
   run; 
 
%put %bquote(&want); 


32         %let string=i need apostrophe instead of question mark?ed;
35         data _null_;
36            var="&string";
37            var1=transtrn(trim(var),"?","'");
38            call symput("want",var1);
39            run;
40         
41         %put %bquote(&want); 
i need apostrophe instead of question mark'ed                                                                                       
                                                   

Re: Tranwrd function

sam369 — Wed, 18 Mar 2015 21:08:18 GMT

Thank you data _null_. I was not successful at first macro variable itself. so i am getting issue.

Thanks

Sam