BookmarkSubscribeRSS Feed
devarayalu
Fluorite | Level 6

data _null_;

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

   put string1=;

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

   put string2=;

run;

string1=* x *

string2=* x *

1 REPLY 1
shivas
Pyrite | Level 9

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

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

How to choose a machine learning algorithm

Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 982 views
  • 0 likes
  • 2 in conversation