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
TRANSTRN
TRANSTRN
Thank you kindly. I knew this was possible!
You could also use TRANWRD to change to something unique and then compress the unique character. TRANSTRN is better.
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!
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.