I was struggling with a calculated member that completes a distinctcount of members in a dimension, the performance was simply unacceptable. After attempting several other measures such as count(), processing changes on the source data, etc, I sent out a msg on Twitter asking for advice. Once again, why aren't
I found this excellent example of What Not To Do on graphjam.com. I was inspired to see if I could recreate something similar in SAS. You see the result here. Yes, the PIE3D statement is ready to do your bidding. If that's what you really want.
There are some things about forecasting that you may only discover by being a forecaster. Simply managing a forecasting process, or being a downstream consumer of the forecast, isn't always enough. If you have something to say to your management about forecasting, but would rather avoid the confrontation, maybe we
Along with hundreds of SAS users, Alison (of sas.com fame) is attending the MidWest SAS User Group meeting. She recently "live-blogged" the keynote presentation from Suzanne Gordon, our CIO. Suzanne does us proud every time. Check out what she had to say to the MWSUG attendees about her start at
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
Update 10Jun2010: the most recent distributions of SAS 9.2 and SAS Enterprise Guide 4.2 are now officially supported on Windows 7 (and have been for a while), and the details are in this SAS note. You can still use these instructions for interesting background information, but the install steps documented
We recently ran into a situation where a customer, with metadata and compute servers on Linux and mid-tier on windows, was trying to leverage the out-of-the-box Pluggable Authentication Module (PAM) support of SAS 9.1.3. PAM allows SAS customers to keep their user management simple by granting users on a Linux
When I said the release was imminent, I wasn't kidding. It's now available. With SAS 9.2 Maintenance 2 we now have support for Windows Server 2008 (in addition to what we already had for SAS 9.1.3). This 9.2 Maintenance release also has various fixes and improvements not only to the
Hello Knowledge Thirsters, Today I discovered that the NOTE: newsletter (pronounced /note colon/) has migrated to the blogosphere. I'm pleased and humbled to admit I've already learned a few things by reading it. This site and others like Angela's SAS BI blog, the "SAS Tips" site, and the cacophony of
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 SAS Management Console, administrators have the ability to include multiple user authentication models (ie user name/pwd combinations) for a single Metadata user account in the 'Accounts' tab. Administrators would then organize these by the Authentication Domain definition in SAS Management Console. The 'DefaultAuth' is the initial account used (unless
I get this question all of the time on the discussion forum and this blog, so I feel I should help to spread the news. SAS now supports SAS 9.1.3 SP4 on Windows 2008 (32-bit edition). Here is the official statement. Update 07Oct2009: I changed this to indicate that the
At least, they will love us when they see that we've translated the SAS Enterprise Guide 4.2 tutorial into Japanese and put it on the SAS support site. We've also got three flavors of Chinese (zh-TW, zh-CN, zh-HK) and Korean now available. These new editions join the Italian, German, Spanish,
Almost daily, I hear reports of scientific studies in which the researchers have used SAS for the data analysis. Typically I don't dig into the details because, frankly, the studies are usually way over my head. But this one about the effect of nut storage, nut size, and nut soaking
Thanks to the folks who support our web presence, this blog page has just received a facelift (but alas, the blogger has not). New colors, easier navigation with the breadcrumbs up top, and a new banner image that shows the SAS for Dummies cover (as if to say, "really, he's
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
Read how Stacey and Christine are working to join the ranks of the certified (and not the certifiable, we hope). I'm sure that PROC CERTIFY (as they've dubbed it) is an example of one proc that won't end with a QUIT; but with a RUN;
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 was recently reviewing our most popular samples that we publish on support.sas.com, and I came across this one showing unusual uses for the ROUND function. As well as gathering lots of visits, this sample has also earned a very respectable rating by you, the readers. I note that we
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
This is one of the coolest uses of SAS I've seen: optimizing school reassignments. I spoke with paper coauthor Rob Pratt before SAS Global Forum this year about this topic. I found the project's origin interesting: CEO Jim Goodnight was chatting with the Wake County Schools superintendant at a cocktail
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
From SAS/ACCESS (for working with databases) to SAS/ZODIAC* (for cranking out horoscopes), you'll be able to learn all you need to know about SAS products with the new product pages on support.sas.com. As of today, we're featuring just a handful of popular products within these pages. The product pages serve
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
Can a crowd of thousands produce better answers than a few experts? That's the question that Sir Francis Galton asked in the 19th century and sought to statistically prove, one way or another. I recently watched an entertaining and informative segment about Galton and the so-called "wisdom of crowds" on
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
