Tranwrd option to not leave space?

[Anotherdream]

Hello everyone. I am trying to remove one string (the letters TRD_ ) from a secondary string. The issue I have is that tranwrd always leaves a space in the resulting word, which I cannot have (I also can't string spaces because the words have other spaces I Need).

For example, I would like the following to happen.

CL_TRD_Borrower Name  =CL_Borrower Name.

TRD_Answer one  =Answer One.

What I am getting is

CL_TRD_Borrower Name  =CL_ Borrower Name.

TRD_Answer one  = Answer One.

Is there an option I am not aware of to do this?

Thanks!

Brandon

[data_null__ · Accepted solution]

TRANSTRN

data _null_;
   x = 'CL_TRD_Borrower Name';
   z = transtrN(x,'TRD_',trimn(' '));
   put (_all_)(=);
   run;

[Anotherdream]

Thank you kindly. I knew this was possible!

[data_null__]

You could also use TRANWRD to change to something unique and then compress the unique character.  TRANSTRN is better.

[Anotherdream]

yeah that's actually what I was doing. I was using tranwrd to put it to the hyphenated a in unicode, and then compressing that value, but I figured there HAD to be an easier way to do it so I figured I'd ask the experts.

Glad I did. Thanks again!