CASE statements are a powerful mechanism in SQL code to analysis, recode, etc data. In Information Map Studio, you can utilize this CASE statement via the Expression Editor Window.
Create a new data item and click edit in the ‘Expression Settings’ area…
Resources for SAS Customers (video)
I use this blog to talk about all of the great information that is available to you on support.sas.com. I point out features that you may have missed (like the RSS feeds or Discussion Forums); I answer questions that you send via our feedback for…
Example 8.1: Digits of Pi
Do the digits of Pi appear in a random order? If so, the trillions of digits of Pi calculated can serve as a useful random number generator. This post was inspired by this entry on Matt Asher’s blog. Generating pseudo-random numbers is a key piece o…
Strategies to Address Locked Files Issue
So you’ve got a nightly process that updates a file somewhere. Unfortunetly, something still has it locked and the update fails, the nightly process crashes & burns, and someone at 8am upon arriving decides to blast you for not having updated data …
Rested & Refreshed…
… from my vacation,and ready for some exciting new developments in the SAS world!As those of you who regularly attend regional user group meetings can attest, SAS Canada has been quickly joining the social media frenzy. You will have heard myself – o…
Zero to SAS Certified Base Programmer in 3 months (Part 1)
I’m happy to report that I have achieved my SAS Certified Base Programmer credential. w00t!. I took my first SAS programming course on March 10th and passed my exam on June 18th (so I guess a more accurate title would say 3 months and 8 days!).
…