All Posts
Are you a SAS programmer who does not yet use SAS Enterprise Guide? If so, what are you missing? That's the topic of my SAS Presents paper at SAS Global Forum: Find Out What You're Missing: Programming with SAS Enterprise Guide. From the introduction: More and more SAS programmers are
~ Contributed by Hope Squires ~ Daniel Schorr is one of my favorite NPR reporters. I just hope he doesn’t mind me announcing that in a blog. Schorr has some strong opinions about what blogging has done to the news industry. In a recent Q&A with The Sacramento Bee, he
It's only January, and SAS Global Forum 2008 isn't until March, but folks around here have already been preparing for months. For my part, I'm on the hook for two papers: one "invited" (submitted and accepted by the SAS Global Forum committee) and one as a "SAS Presents" (topics that
I was reading an article in Project Manager Today magazine (more interesting than it might sound) about 'Unknown Unknowns and Risk' and it made reference to Donald Rumsfeld's infamous comment about "we know there are some things we do not know". Actually, he was making sense in a garbled sort
Even if you don't use Microsoft Office 2007, you might have noticed more ".xlsx" files floating around lately. Perhaps you've been sent one or two that you can't open. XLSX is one of the new Microsoft Excel 2007 file formats. (Others include XLSB and XLSM.) Like many software applications, SAS
A reader from Bejing commented on a recent post with a question about data lengths and formats. While that wasn't really related to my post, I thought I'd attempt to answer in a new entry, here. The question is basically this: when I combine two data sets with a common-named
SAS tip-meister Phil Mason shares a veritable cornucopia of tips at the CMG 2007 conference. Check it out, and learn how a healthy diet of flexible DATE formats can keep your Perl expressions regular.
In his blog, Jared details the hoops one must jump through to convince SAS to run system shell commands (such as the X command and SYSTASK) from SAS Enterprise Guide. Here is the explanation: SAS Enterprise Guide is a client application, and SAS runs as a server application. When launched
"Cut him in half and count the number of rings?" Some folks on the discussion forum share a better method to calculate someone's age from SAS Enterprise Guide.
If you deploy the SAS 9 environment on Windows, you may have multiple SAS processes running on a single box (metadata process, OLAP server, multiple workspace servers). Windows Task Manager doesn't provide a great way to distinguish one sas.exe process from another, but Process Explorer does. Process Explorer lets you
My new favorite typeface for programming is Consolas, a font designed for use with Microsoft Visual Studio 2005. I use it there, but I now also use it for SAS programming. It uses ClearType technology, so the "crisp and clean" benefits kick in only when you have ClearType smoothing enabled.
How much time should be devoted to preparing for an important challenge? Depends on the challenge, I hear you say. From my experience, it is important to be aware of the challenges to be confronted when completing a significant project. Not under-estimating the real effort required, often depends on fitness
A colleague asked me to run a certain SAS program and then try to view the output in SAS Enterprise Guide. The output contained an SQL VIEW, and darn it, the application refused to open it, reporting only that the data "could not be opened." There was nothing wrong with
Let's say you use SAS Report format, the latest tagset supported by ODS. After all, it's the lingua franca of SAS BI applications, since it's also used by SAS Web Report Studio, SAS Add-In for Microsoft Office, and SAS Enterprise Guide. You've discovered how to use the report builder in
In the SAS BI-ogsource, Angela posts some sample SAS code for updating library definitions using the METALIB procedure. SAS Enterprise Guide users can make use of a friendlier interface to do the same job. Now available for download, the Update Library Metadata task plugs right into SAS Enterprise Guide and