topic Tranwrd option to not leave space? in SAS Programming

Tranwrd option to not leave space?

Anotherdream — Tue, 03 Dec 2013 15:39:36 GMT

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

Re: Tranwrd option to not leave space?

data_null__ — Tue, 03 Dec 2013 15:53:46 GMT

TRANSTRN

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

Re: Tranwrd option to not leave space?

Anotherdream — Tue, 03 Dec 2013 15:58:25 GMT

Thank you kindly. I knew this was possible!

Re: Tranwrd option to not leave space?

data_null__ — Tue, 03 Dec 2013 16:01:21 GMT

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

Re: Tranwrd option to not leave space?

Anotherdream — Tue, 03 Dec 2013 16:04:46 GMT

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!