Trimn retruns a null string of zero-length string. But here it is returning one blank character. Why?

devarayalu — Wed, 04 Jul 2012 05:06:47 GMT

data _null_;

string1='*' || tranwrd('abcxabc', 'abc', trimn('')) || '*';

put string1=;

string2='*' || tranwrd('abcxabc', 'abc', '') || '*';

put string2=;

run;

string1=* x *

string2=* x *

Re: Trimn retruns a null string of zero-length string. But here it is returning one blank character. Why?

shivas — Wed, 04 Jul 2012 06:06:03 GMT

Hi,

From SAS documentation,

The TRANWRD function replaces all occurrences of a given substring within a character string. The TRANWRD function does not remove trailing blanks in the target string and the replacement string.

TRANWRD uses a single blank instead when the replacement string has a length of zero.

Try using compress to remove all the blank spaces,if you want.

data _null_;

string1='*' || compress(tranwrd('abcxabc', 'abc', trimn(''))) || '*';

put string1=;

string2='*' || compress('abcxabc', 'abc', '') || '*';

put string2=;

run;

Thanks,

Shiva

topic Trimn retruns a null string of zero-length string. But here it is returning one blank character. Why? in SAS Data Science

Trimn retruns a null string of zero-length string. But here it is returning one blank character. Why?

Re: Trimn retruns a null string of zero-length string. But here it is returning one blank character. Why?