topic Need help in finding PRX documentation? in SAS Programming

Need help in finding PRX documentation?

MarkWik — Mon, 21 May 2018 22:21:00 GMT

I would like to learn PRX group of functions thoroughly and am in need of pointers to certain documentation with examples that starts and explains from the very basic to advanced regular expressions in sas. I have read the SAS documentation however I am unable to comprehend the concept to my satisfaction. Can somebody share plz?

Thanks so much in advance,

Mark

Re: Need help in finding PRX documentation?

Reeza — Mon, 21 May 2018 23:53:10 GMT

Regular expressions are not a SAS concept, it originates with Perl and can be used in a ton of places, I think there’s even Excel adding or default options that use it now.

The cheat sheet is a good day to day reference

https://support.sas.com/rnd/base/datastep/perl_regexp/regexp-tip-sheet.pdf

Maybe this site will help

https://regexr.com

Re: Need help in finding PRX documentation?

ChrisHemedinger — Mon, 21 May 2018 23:55:28 GMT

And for SAS specifics, check out this paper by David Cassell: The Basics of the PRX functions.

Re: Need help in finding PRX documentation?

FreelanceReinh — Tue, 22 May 2018 20:32:06 GMT

Hi @MarkWik,

In 2015 I was in a very similar situation. Eventually, I bought the e-book version of "Introduction to Regular Expressions in SAS®" by Matthew Windham and read the first three of its four chapters. I was a bit surprised that it doesn't cover all available metacharacters. Still, this book helped me familiarize myself with the more common ones as well as with the PRX functions and CALL routines.

However, I use regular expressions so rarely in my programs (more often in the Replace dialog box of the Enhanced Editor) that I usually need to look up the precise syntax again.