Using regular expressions to verify the pattern of character data

Wait!  Don’t close this window.  I understand that regular expressions can be very complicated (yes, there are many books on the subject), but some basic expressions to test patterns such as zip codes or telephone numbers are not that difficult.  In addition, you can sometimes use Google to search for […]

The post Using regular expressions to verify the pattern of character data appeared first on SAS Learning Post.

Create and run SAS code in SAS Add-In for Microsoft Office

When SAS Add-In for Microsoft Office was first created over a decade ago, SAS programmers were told to check their skills at the door. This new product was for non-programmers only. SAS programmers were invited to contribute to the experience by packaging their code in SAS stored processes, which end […]

The post Create and run SAS code in SAS Add-In for Microsoft Office appeared first on The SAS Dummy.

Standardizing phone numbers using SAS

How many times have you entered a phone number on a web page, only to be told that you did not type it the “correct” form? I find that annoying. Don’t you? In my latest book, Cody’s Data Cleaning Techniques, 3rd edition, I show how to convert a phone n…