SAS Jedi

12月 052017

Finding a pattern like a phone number or national ID number embedded in text can be difficult and time consuming. The traditional DATA step has a family of functions (collectively referred to as PRX functions) that allow using Perl regular expressions in your SAS programs to make pattern search easier. [...]

The post Jedi SAS Tricks: Pattern Search in DS2 appeared first on SAS Learning Post.

8月 292017

I hate hard-coding variable lists in my SAS code. I love the special variable lists SAS provides, like name:, _numeric_, etc. But back in 2011, I wrote a post titled Jedi SAS Tricks - Building a Name Suffix variable list lamenting the lack of a special variable list in base [...]

The post Jedi SAS Tricks - Variable Lists by Text Pattern appeared first on SAS Learning Post.

8月 162017

I frequently get asked about my favorite book on a particular topic, how to find free SAS learning materials online, how to get help with SAS issues, etc. This lead me to compile a "Great Resources for SAS Programmers" document which I freely share with my students upon request. So [...]

The post Jedi SAS Tips - Favorite Resources for SAS Programmers appeared first on SAS Learning Post.

6月 232017

Dictionary tables are one of the things I love most about SQL! What a useful thing it is to be able to programmatically determine what your data looks like so you can write self-modifying and data-driven programs. While PROC SQL has a great set of dictionary tables, they all rely [...]

The post Jedi SAS Tricks - FedSQL Dictionary Tables appeared first on SAS Learning Post.

12月 292016

This SAS Jedi is very excited about the SAS 9.4 M4 release, which brought many wonderful gifts just in time for Christmas. So in the interest of extending the Christmas spirit, I'm going to blog about some of my favorites! I've long loved the SAS DO statement variant which allows […]

The post SAS Jedi Christmas - SAS 9.4 M4 DS2 Do Loop Upgrade appeared first on SAS Learning Post.

7月 212016

One of the things I’ve come to love most about DS2 is the tight integration with SQL which makes so many data prep chores so much less onerous. An example is DATA program BY group processing. With a traditional DATA step, you must first sort or index the source data […]

The post Jedi SAS Tricks: Explicit SQL Pass-through in DS2 appeared first on SAS Learning Post.

6月 072016

A reader posed a question in the comments to an earlier Jedi SAS Trick, asking how to write the results of a DS2 DATA _NULL_ program to a text file. It's an interesting question, as DS2 currently has no text file handling statements or capabilities. Take, for example, this traditional […]

The post Jedi SAS Tricks: Writing to Text Files from DS2 appeared first on SAS Learning Post.

5月 302016

Have you been kicking around ideas for a great SAS book, but don’t know how to get started? Don’t wait another day – connect with the Author with SAS community and let those amazing folks at SAS Press help you get your project rolling. You won’t regret it! I’m SO […]

The post Are you a SAS Jedi? Why not share your knowledge? appeared first on SAS Learning Post.