The SAS Dummy
A SAS® blog for the rest of us
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
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