It seemed like an easy task. A SAS user asked me how to use the SGPLOT procedure to create a bar chart where the vertical axis shows percentages instead of counts. I assumed that there was some simple option that would change the scale of the vertical axis from counts
There are two activities which, when taken in combination, have occupied the vast majority of my working hours for the past 20 years: writing computer programs and writing...well, just writing. During my college years I completed my degree with a double-major: Computer Science and English. (My English degree has a
Blogger Dylan Jones offers 3 tips for more effective data profiling.
If you haven’t heard of an APCD, it’s one of those acronyms you need to know. All-Payer Claims Databases are simply databases that consist of claims data from all health care payers in a given state. This includes private payers such as Blue Cross Blue Shield, and public payers such
Frequently someone will post a question to the SAS Support Community that says something like this: I am trying to do [statistical task]and SAS issues an error and reports that my correlation matrix is not positive definite. What is going on and how can I complete [the task]? The statistical
Several weeks ago, South Carolina was the victim of what some experts believe to be the largest cyber-attack against a state tax department in history. Approximately 3.6 million personal South Carolina income tax returns were exposed, and nearly 657,000 businesses compromised, in an international hacking attack. Coincidentally, SAS and the SC
Last week I wrote about using acceptance-rejection algorithms in vector languages to simulate data. The main point I made is that in a vector language it is efficient to generate many more variates than are needed, with the knowledge that a certain proportion will be rejected. In last week's article,
This week's SAS tip is from Susan Slaughter and Lora Delwiche's bestselling The Little SAS Book for Enterprise Guide 4.2. Susan and Lora are revered in the user community. And their work continues to help SAS users throughout the world. I hope you'll also find value in this week's excerpt. The following excerpt is from
Data governance as an MDM program planning task, part 2.
The ODS DOCUMENT and the DOCUMENT procedure give you the ability to save ODS output. Once saved, you can print that same work, as many times as you want, to any ODS destination. But what does this mean for you? With PROC DOCUMENT, you can: Make changes to the appearance
Have you heard the expression "Talk Turkey"? Well then, what better (tongue-in-cheek) thing to do around the Thanksgiving holiday, than talk some turkey using SAS Graphs! ;) I don't usually decorate my graphs with images and pictures (they typically make the graph more difficult to read), but when it comes
The LOC function is one of the most important functions in the SAS/IML language. The LOC function finds elements of a vector or matrix that satisfy some condition. For example, if you are going to apply a logarithmic transform to data, you can use the LOC function to find all
Most custom tasks need to access SAS data in some way. Since custom tasks are built using Microsoft .NET, and the .NET Framework is object-oriented, it would be convenient if we had an object-oriented method for navigating SAS data sources. That was the thinking behind the "SasData"-namespace classes within the
As the holidays approach, we’ll all have some down-time to catch up on personal and professional reading, hopefully cozied up by a fire with a cup of hot chocolate in hand. While most books regarding data-driven decision making and value-added analyses can be pretty heavy, I’d like to suggest two
Analytics maturity is a hot topic right now. Many come to SAS for answers on how to assess their analytics maturity and advance their use of analytics, especially at a corporate level. I want to share the highlights of what we usually prescribe from a best practices perspective regarding advancing
A few days ago on the SAS/IML Support Community, there was an interesting discussion about how to simulate data from a truncated Poisson distribution. The SAS/IML user wanted to generate values from a Poisson distribution, but discard any zeros that are generated. This kind of simulation is known as an
SAS Publishing has been offering eBooks through partners like Amazon, Apple, and Google, for a number of years. Our content is also available through subscription-based companies like Books 24x7, Safari, and EBSCO. We have learned that taking content developed for hardcopy and turning it into an ebook is not a
Does data governance make a difference? See what @davidloshin has to say.
How do you hire a Chief Data Scientist? That's not a hypothetical question: I know of at least three companies that are actively looking for a "Chief Data Scientist" at the moment. Hiring the right person is harder than you'd think. Whether or not a Chief Data Scientist is a
I was recently asked, "Does SAS support computing inverse hyperbolic trigonometric functions?" I was pretty sure that I had used the inverse hyperbolic trig functions in SAS, so I was surprised when I read the next sentence: "I ask because I saw a Usage Note that says these functions are
We are careening towards the holiday season, and this year more than ever before it's going to mean one thing: Online Shopping. As you enter your credit card number over and over to complete your many purchases, you might occasionally transpose or mistype your account number. Does it surprise you
Hot off the press and debuting at NESUG is Michael Tuchman's new book, PROC DOCUMENT by Example Using SAS. Tuchman's book demonstrates the practical uses of the DOCUMENT procedure, a part of the Output Delivery System, in SAS 9.3. The DOCUMENT procedure allows general SAS users to store and manage
Two enduring principles of forecasting are that simple methods can work as well as fancy methods, and that combining (averaging) forecasts, also known as "ensemble forecasting," will usually result in more accurate predictions than the individual methods being averaged. We saw a good demonstration of these principles in Tuesday's election
The other day I was constructing covariance matrices for simulating data for a mixed model with repeated measurements. I was using the SAS/IML BLOCK function to build up the "R-side" covariance matrix from smaller blocks. The matrix I was constructing was block-diagonal and looked like this: The matrix represents a
Disasters like Hurricane Sandy, by and large, shine a positive light on humanity, with the heroic actions of first responders and volunteers, and the massive outpouring of support from across the nation. They also present fraud opportunities for the shady operators and criminals among us. Hurricanes leave behind a lot
The 2012 US Presidential race comes to a close today (thankfully), and there is no shortage of wacky indicators predicting the winner: Iowa Electronic Markets FiveThirtyEight PollyVote University of Colorado In primitive times a diviner could foretell the future by poisoning a chicken -- whether it lived or died provided
Read David Loshin's latest blog post: "Innovation in Creating Information Products."
In the U.S. we have a presidential election every 4 years - and as luck would have it, 2012 is an election year! I see a lot of election maps & graphs in the news, and I'm always subconsciously critiquing them in my mind and thinking to myself, "How would I graph this
Editor Len Tashman's Preview of Foresight The importance of trust in the dissemination of forecasts through an organization cannot be overstated. Lack of trust, due in no small measure to the biases arising from “silo mentalities” and misplaced incentives, can and too often does undermine the forecasting process. Foresight has
Each spring and fall, I start clearing out the kid's small clothes, old toys, etc. It can sometimes go too far and reach into my "digital pack-rat" issues. (Wait, what does that mean? Well, just ask the person who last week requested detail on a project I worked 3 years
