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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.