The SAS Dummy
A SAS® blog for the rest of us
Have you ever submitted a SAS program or query only to immediately regret it? It usually happens just as you finish clicking the mouse or lift your finger from the F8 key: you realize that your program has a horrible flaw that's going to make it run for hours or
In a previous posting I showed an example of how you can use the GKPI procedure in SAS 9.2 to create dashboard-quality charts. Here's a more formal sample that you can use, including a custom task that you can use in SAS Enterprise Guide 4.2 to point-and-click your way the
Geoff posted a nice article on his blog about how you can read and write Microsoft Excel spreadsheets programmatically from within SAS, without using DDE. I've previously written about how it's difficult to continue using DDE from SAS when you have a distributed environment (SAS on a server machine, Excel
"DEV/TEST/PROD": If that term means something to you, then you are probably among our many customers that use SAS software across different environments. You might have one SAS environment for playing around ("dev" for "development"), another for testing candidate changes ("test"), and yet another for production processes ("prod"). Or, you
You might be the sort of person who loves to wait indefinitely. You visit the DMV regularly to tweak your auto registration. You queue up in the supermarket checkout line behind the customer most likely to require "price checks". You map your daily commute along the routes that offer the
Recoding values is one of the most common data prep tasks that folks need to do before they can analyze and report on data. In SAS, the most elegant way to handle this is by applying a SAS format. A SAS format allows you to "bucket" a bunch of raw