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

[teja5959]

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;

[data_null__ · Accepted solution]

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

[ballardw]

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;

[data_null__]

---

@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.

[ballardw]

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 ...