topic Re: function unknown in SAS Programming

function unknown

cons — Tue, 23 Aug 2016 10:10:39 GMT

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.

Re: function unknown

RW9 — Tue, 23 Aug 2016 10:18:30 GMT

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;

Re: function unknown

Shmuel — Tue, 23 Aug 2016 10:27:46 GMT

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;

Re: function unknown

data_null__ — Tue, 23 Aug 2016 11:47:24 GMT

You are correct translate is the preferred function to use when changing single characters.