2011 saw incredible change in the states as more than half of the governorships changed hands. As expected, that caused significant turnover at the State CIO level, as well. So while executive and technology policies changed in many ways, the dismal budget situation reinforced the need to allocate tax pay
Bad customer service experiences burn into our brains, creating permanent recall. And although we rightfully expect good customer service across the board, truly exceptional customer care is also unforgettable. This month, I featured an interview with SAS Publishing sales representative Sharon Brandon in the new issue of SAS Publishing News.
You’ve got your raw data visualized, you need a graph that shows the results of a custom analysis, you have a mental image of the graph you want to create, but…you don’t know the procedure needed to create what you want. Sanjay Matange and Dan Heath have written a book
In Simple maps can go a long way, we discussed some techniques to create simple outline maps from map datasets in the MAPS library using GTL. Now, let us take this a step further to do something more useful with this feature. For some graphs, the map information is an essential part of the
On the heels of the release of the popular SAS macro variable viewer from last month, I'm providing another custom task that I hope will prove just as useful. This one is a SAS options viewer, similar in concept to the OPTIONS window in SAS display manager. You can download
Managing expectations for forecast accuracy is very important, as often those expectations are extreme after management invests in a new system. Software vendors have also been known to make overly (choose one: optimistic? sanguine? idyllic?) accuracy claims as part of their sales pitch. Of course, there is no arbitrary level of accuracy
A few colleagues and I were exchanging short snippets of SAS code that create Christmas trees and other holiday items by using the SAS DATA step to arrange ASCII characters. For example, the following DATA step (contributed by Udo Sglavo) creates a Christmas tree with ornaments and lights: data _null_;
A new book from SAS Press, "Statistical Graphics Procedures by Example" co-authored by Dan Heath and I has now been published (phew!). For both Dan and I, this was our first foray into writing a book, so it was highly educational to say the least. The key idea behind the presentation
After my November blog post about achievement gaps between affluent and poor students, Newt Gingrich cast some renewed energy on the topic with his inflammatory comments about poor children at a Dec 1st GOP debate. In case you missed his remarks, here is the quote that sent the media into
My daughter's math lessons this year have included the concept of negative numbers (that is, numbers that are less than zero, not numbers that have a bad attitude). She has used number lines such as this one to help her while she completes her homework: Notice that in this number
Since this is a blog about statistical programming and analysis, I am always looking for data to analyze. As 2011 ends, I look back on the 165 blog entries that I published since 01JAN2011. This article presents the 10 most popular posts, as determined by the number of people who
On his SAS and R blog, Ken K. recently posted an example of a visualization technique called "small multiples". In this exercise, Ken shows the programming technique for replicating a particular series of pie charts in R as well as in SAS. It's a useful exercise to learn from, but
SAS Press prides itself on being a place where users come to help other users. Collaboration is key here—not just between authors and the SAS Press team, but among authors alike. So we asked two of our authors, one experienced and one currently working on his first book, to share
My Google Alert on "forecastability" paid off with a gem this weekend, in the blog post "Forecastability and Over Fitting" by Shaun Snapp on SCM Focus. I was not previously familiar with Shaun or this site, but found a lot to like -- in content and attitude. In his post, Shaun kindly
Since joining SAS, I no longer run screaming from social media, blogs, etc. In fact, I embrace exploring different mediums to highlight how SAS is assisting today’s law enforcement. To that end, and in recognition that sometimes less is more, I give you this short intro. SAS continues to push
The SAS Output Delivery System (ODS) enables you to manage and customize tables (and graphics!) that are created by SAS procedures. I like to use the ODS SELECT statement to display only part of the output of a SAS procedure. For example, the UNIVARIATE procedure produces five tables by default,
Some SAS products such as SAS/IML Studio (which is included FREE as part of SAS/IML software) have interactive graphics. This makes it easy to interrogate a graph to determine values of "hidden" variables that might not appear in the graph. For example, in a scatter plot in SAS/IML Studio, you
In one minute (and 10 seconds, but are you measuring that?) you can add a custom measure (also known as calculated members) to your OLAP cube. Watch this video to create a simple calculation multiplying units * price. Remember that this mechanism is not just used for multiplications, you can
“Do you really serve M&Ms every Wednesday? Tell us the story!” clamored a wide-eyed class after sampling the M&Ms lighting up the breakout area. Seeing how hard they worked on their exercises, it seemed ok to have a slight diversion from technology. Besides as you’ll find out, the story has
Yesterday, December 7, 1941, a date which will live in infamy... - Franklin D. Roosevelt Today is the 70th anniversary of the Japanese attack on Pearl Harbor. The very next day, America declared war. During a visit to the Smithsonian National Museum of American History, I discovered the results of
Water and wastewater treatment plants are among the most complex facilities built and maintained by utility companies, whether public or private. Each facility contains thousands of pieces of equipment worth millions of dollars that must operate in concert for the many complex treatment processes to function effectively. The consequences of these assets
In simulation studies, the response variable is often a binary (or Bernoulli) variable. Often 1 is used to indicate "success" (or the occurrence of an event) whereas 0 indicates "failure" (or the absence of an event). For example, the following SAS/IML statements define a vector x of zeros and ones:
Consultant Frederick Pratter continues his winning streak with this third edition of Web Development with SAS by Example. Web programmers of all levels will appreciate Frederick's many real-world examples and clean delivery. Speaking of delivery, I'd encourage those of you who attend SAS Global Forum and regional user group conferences to seek out Frederick if
When I was a teenager in the 1980s I purchased my first computer: a TI-99/4A. (Wow, TI's version numbers are more confusing than ours!) I had several friends who had other brands of computers, including the TRS-80 (affectionately known as the "trash 80") and the Commodore 64. Despite our divisions
Recently the "SAS Sample of the Day" was a Knowledge Base article with an impressively long title: Sample 42165: Using a stored process to eliminate duplicate values caused by multiple group memberships when creating a group-based, identity-driven filter in SAS® Information Map Studio "Wow," I thought. "This is the longest
26.2! If you smiled when you read that number, then you are likely one of the cognoscenti who ran a marathon or know somebody that ran a marathon. If you didn’t recognize that number, then by now you may have guessed that it is the number of miles in a
On this blog, I've delivered a few tips about using SAS formats to stratify your data values "in place" without having to actually change your data. The most recent example addressed date and datetime variables. My previous examples included simple SAS programs that you can run in SAS display manager
The other day someone posted the following question to the SAS-L discussion list: Is there a SAS PROC out there that takes a multi-category discrete variable with character categories and converts it to a single numeric coded variable (not a set of dummy variables) with the character categories assigned as
I got an email asking the following question: In the following program, I don't know how many variables are in the data set A. However, I do know that the variable names are X1–Xk for some value of k. How can I read them all into a SAS/IML matrix when
I have previously written about how to create funnel plots in SAS software. A funnel plot is a way to compare the aggregated performance of many groups without ranking them. The groups can be states, counties, schools, hospitals, doctors, airlines, and so forth. A funnel plot graphs a performance metric
