All Posts
A user who is a member of the "SAS Administrators" group and has been granted the role "Management Console: Advanced" can create a Metadata Backup job via SAS 9.2 Management Console. Right Click on 'Backup and Restore' Task under 'Metadata Utilities'. Then select the Backup task created and choose either
The SAS 9.2 XML engine is very very very slick. I created an xml map to generate a dataset from xml generated during a metadata getobjects job to then run call execute statements for a proc metalib update. "Wait, you did what??!@#?&" you ask? Here are my simple steps. This
Before we begin, I want to thank all of you readers who supported my righteous appeal for “THE BFD” license plate from the state of North Carolina. I am sad to report, however, that our efforts were in vain and the appeal was denied by Censorship Board of the Division
In case you haven't heard, the state of North Carolina needs money. Roads are falling apart, parks are left unkempt, prisoners are being released, and public school cafeterias can no longer afford to put anything surprising in their Chef's Surprise. In order to help assuage the crisis, and in my
Most modern programmer text editors allow you to see multiple views of the document you're working on. The SAS program editor within SAS Enterprise Guide is no exception, although we've done a pretty good job of hiding this feature. Read on and learn how to easily "divide and conquer" your
Would you buy something that doesn’t have demonstrable Return on Investment? Of course you would! Whether you realize it or not, you do this every time you buy software. There is no proven ROI. Maybe this is just a pet peeve of mine. Maybe I care too much about cause
I’m back from a week of vacation in Michigan and bursting with new topics, but will have to get to those next week (still playing catch-up in my day job). I do, however, have the pleasure to announce the publication of a new book by my friend and colleague Charlie
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
The SAS internal discussion boards are always full of fascinating topics, some of which are even decipherable to a non-Ph.D. in statistics like me. A recent topic involved how to calculate the benefits of good forecasting software, and my colleague Robin Way offered an interesting perspective that he allowed me
Personally, I don’t get Twitter. I have an account (mvgilliland) for anyone interested in not hearing any tweets from me. I follow a few people and have a few followers (including some that aren't porn bots) -- but what is the point? Does anyone really care that I’m out hanging
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
The Summer 2009 issue of Foresight is now available, and features a section on “Rethinking the Ways We Forecast.” Here is Editor Len Tashman’s preview: Are traditional forecasting tools suitable for predicting complex systems like the economy and the global climate? Basically, no, argue David Orrell and Patrick McSharry: such
On a Monday July 20 segment of consumer advocate Clark Howard’s radio show, Clark discussed the common practice of hidden payments to influential bloggers. Apparently these high-tech shills pocket the payola, and then make favorable postings about particular products or services. According to Clark, there are new rules to prevent
Aren’t the internets wonderful? Just today I was trying to find the antonym of “naïve” and came across several terrific choices (sophisticated, worldly, well-informed, and intelligent) and one that didn’t make any sense (svelte???). However, upon further review at Merriam-Webster.com, I discovered that in addition to slender, lithe, and sleek