Hi everybody,
is there a function for following problem:
I have a string like "abc,def." and I want replace "," and "." with numbers or characters. I just want use the function once.
Regards,
Cons.
You cam do both replacement at same time by:
new_text = translate(old_text,'12',',.');
argument for translate are: input string, replace into chracters, repce from characters.
the order of chracters should fit;
The function you are looking for is tranwrd():
http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000215027.htm
A search for string functions will yield you many different types of string processing functions.
Example:
data want; text="abc,def."; /* replace comma with 1 */ new_text=tranwrd(text,",","1"); /* replace dot with A */ new_text=tranwrd(new_text,".","A"); run;
You cam do both replacement at same time by:
new_text = translate(old_text,'12',',.');
argument for translate are: input string, replace into chracters, repce from characters.
the order of chracters should fit;
You are correct translate is the preferred function to use when changing single characters.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.