Hi Folks,
I have a list of surnames in a string and I need to replace say O'Con or O'S with O Con or O S.
I've tried to this and I'm struggling so any help welcome.
All the best,
Sean
Have you tried TRANSLATE function?
surname_no_apostrophe = translate(surname, " ", "'");
Last parameter is single quote/apostrophe, wrapped in double quotes.
@Sean_OConnor wrote:
Hi Folks,
I have a list of surnames in a string and I need to replace say O'Con or O'S with O Con or O S.
I've tried to this and I'm struggling so any help welcome.
All the best,
Sean
Have you tried TRANSLATE function?
surname_no_apostrophe = translate(surname, " ", "'");
Last parameter is single quote/apostrophe, wrapped in double quotes.
@Sean_OConnor wrote:
Hi Folks,
I have a list of surnames in a string and I need to replace say O'Con or O'S with O Con or O S.
I've tried to this and I'm struggling so any help welcome.
All the best,
Sean
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.