topic Re: i tryed to remove two spl character at a time using tranwrd in SAS Programming

i tryed to remove two spl character at a time using tranwrd

teja5959 — Mon, 20 Mar 2017 12:51:54 GMT

Hi i am trying remove spl char at a time . but it's not work proparly .

exp;

data exp;
a='i will try to removie spl char @ and another spl $';
a1=tranwrd(a,'@$' , '' );
run;

i want a1 varibel with out spl char;

Re: i tryed to remove two spl character at a time using tranwrd

data_null__ — Mon, 20 Mar 2017 12:54:07 GMT

To REMOVE characters use COMPRESS funtion. TRANWRD is the wrong funtion for your problem.

Re: i tryed to remove two spl character at a time using tranwrd

ballardw — Mon, 20 Mar 2017 14:29:26 GMT

Or translate may be what you were thinking of.

data exp;
   a='i will try to removie spl char @ and another spl $';
   a1=translate (a,'','@$' );
run;

Re: i tryed to remove two spl character at a time using tranwrd

data_null__ — Mon, 20 Mar 2017 15:06:07 GMT

@ballardw wrote:

Or translate may be what you were thinking of.
data exp;
   a='i will try to removie spl char @ and another spl $';
   a1=translate (a,'','@$' );
run;

Translate doesn't remove the characters you are replacing with blanks.

Re: i tryed to remove two spl character at a time using tranwrd

ballardw — Mon, 20 Mar 2017 19:34:14 GMT

Understood @data_null__ but since the OP started with one of the translate functions I was hoping to point him to the slightly more correct option.

And since there was not actual desired output posted ...