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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.