BookmarkSubscribeRSS Feed
rawindar
Calcite | Level 5

name=j** ney

in the above data value there is a two * are there after J.Using compress we can remove this *.But i need to remove only 1 *.How can i write the code.

3 REPLIES 3
Hoz
Calcite | Level 5 Hoz
Calcite | Level 5

How about use "prxchange".

name="j** ney";

txt = prxchange('s/\*\*/*/',-1,name);

put txt=;

Best Regards,

Keith
Obsidian | Level 7

I agree with Hoz, prxchange is the way to do this.  A slight modification to Hoz's code will replace any number of consecutive * to a single *.

txt = prxchange('s/\*+/*/',-1,name);

Patrick
Opal | Level 21

Using a regular expression with prxchange() is for sure a very powerful way of modifying a string.

Considering that it's such a simple text pattern and the question is asked in the "Getting started" forum using a function like TRANSTRN() is also acceptable.

data _null_;

  myVariable='name=j** ney';

  myVariable=TRANSTRN(myVariable,'**','*');

  put myVariable=;

run;

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1077 views
  • 0 likes
  • 4 in conversation