Hi Patrick,
i managed to use your prxchange and prxparse within my proc sql query and it works like a dream. Just wanted to say thank you for this.
Would you mind explaining the arguments for prxparse('s/(.)\1+/$1/io')?
DISCLOSURE: I realize that this is not a timely reply, but since this post comes up in Google searches for "remove duplicate characters in a SAS string", I have decided to inform readers who stumble upon this post through their search about the following new development:
I recently published a blog post Removing repeated characters in SAS strings in which I create a new user-defined function UNDUPC that removes duplicate characters from SAS strings effectively expanding functionality of the COMPBL function to all other characters.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.