topic tranwrd in sysfunc in SAS Programming

tranwrd in sysfunc

deleted_user — Thu, 28 Aug 2008 18:27:20 GMT

Hi,
I am trying to use the code below to get the required result. when I use tranwrd in data _null_ I get the right result.

%let m=apple martini;
%let m=%sysfunc(tranwrd(&m," ",", "));
%put &m;

returns: apple martini

require : apple, martini

Re: tranwrd in sysfunc

Patrick — Thu, 28 Aug 2008 19:45:13 GMT

Try this:
%let m=apple martini;
%let m=%sysfunc(tranwrd(&m,%str( ),%str(, ) ));
%put &m;

And here the explanation:
http://www.listserv.uga.edu/cgi-bin/wa?A2=ind0105D&L=sas-l&P=29776

HTH
Patrick

Re: tranwrd in sysfunc

deleted_user — Fri, 29 Aug 2008 13:24:55 GMT

Thanks, that was really helpful