Hi,
I have a peculiar situation.
I have a column in a dataset that can have values as below
002-0002==NON-FINAL/INTERNAL TEST|009-0004==CUSTOM/RELATIONSHIP
002-0002==NON-FINAL/INTERNAL TEST
What I want as output is to replace '==' with just one '='
so desired output
002-0002=NON-FINAL/INTERNAL TEST|009-0004=CUSTOMER/RELATIONSHIP
002-0002=NON-FINAL/INTERNAL TEST
What function can I use for the same ?
Thank you.
How about the TRANWRD function? Example:
newstring=tranwrd(oldstring,'==','=');
How about the TRANWRD function? Example:
newstring=tranwrd(oldstring,'==','=');
@PaigeMiller - thank you . that worked. I had tried translate but that did not treat the two == as one occurence ..
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.
Ready to level-up your skills? Choose your own adventure.