Data Intelligence, Business Analytics
Ever find yourself waiting for your data to appear and you start wondering if you are paying for sins from a past life? Dante must have been thinking of this situation as he created his Circles of Hell. There is no way the agony of waiting for data to appear with a looming deadline did not make his list!
Often it seems like the closer the deadline, the slower the connection. When working with data locally, the data appears…Continue
Posted on June 4, 2013 at 5:23am
Guest Post by Stig Eide
Stig Eide showed me a trick for using the Excel web query to look at SAS data. Very clever trick!
Want to view a SAS table in Excel but you don't have the Add-In for Microsoft Office installed? This post describes an alternative method. Excel has a nice feature where you are allowed to query a web page for data. I will describe how you can set up the query against a stored process, and how to pass parameters.
First, you need…Continue
Posted on February 21, 2013 at 5:30am
Written By Quentin McMullen
In 1986 the Beastie Boys released their classic debut album, License to Ill, and the last track posed a question: “What’s the time?” The Beasties answered with an anthem, “It’s time to get ill.” I think Peter Crawford, SAS programmer extraordinaire, would have answered more simply. What time is it? It’s %now.
%Now generates a timestamp. It’s a simple SAS macro, but despite its simplicity, it…Continue
Posted on December 20, 2012 at 4:22am
Last week while searching for a code snippet through several folders of information, I realized that the code was still on my old computer ... ugh! One of my weekend projects was to organize my code examples somewhere - I'm going to try Evernote, which I have been using to organize other items. Evernote uses an elephant for it's mascot - because elephants never forget. That's what I need!
Posted on December 17, 2012 at 4:34am