Here’s a great way to kill a conversation at the next cocktail party you attend. Start talking about the US budget deficit. You remember the deficit, right? It’s the difference between what the government collects and what it spends. In 2014, the US federal government spent $488 billion more than
Is this blog post about techniques to use on difficult graph legends, or is it about goats? The answer is both! But first, to get you into the proper mood, here is a picture my friend, Mark, took of some cute goats. And some links to YouTube videos about goats
The other day I was creating some histograms inside a loop in PROC IML. It was difficult for me to determine which histogram was associated with which value of the looping variable. "No problem," I said. "I'll just use a TITLE statement inside the loop so that each histogram has
Sudoku solvers have been written in SAS using a variety of methods (e.g., the DATA step, PROC SQL, and PROC CLP). Surprisingly, SAS/IML appears to have been overlooked for this purpose. On a challenge from a coworker, I wrote this blog post to demonstrate the flexibility of SAS/IML in the
Special Investigation Units (SIU) are extremely process-oriented and follow well-documented procedures to decide when a claim should be referred for investigation and what actions should be taken. Most of the staff are seasoned investigators who may be more inclined to trust their experience and tried-and-true processes than analytical techniques that
James Surowiecki wrote a book about The Wisdom of Crowds. Jeff Howe, who co-coined the term crowdsourcing, wrote a book about Why the Power of the Crowd Is Driving the Future of Business. In this blog series, I explore if it’s wise to crowdsource data improvement, and if the power of the crowd can
“Let’s assume a normal distribution …” Ugh! That was your first mistake. Why do we make this assumption? It can’t be because we want to be able to mentally compute standard deviations, because we can’t and don’t it that way in practice. No, we assume a normal distribution to simplify
I recently read an article that listed the 100 best restaurants in the US - but the article didn't have a map. I decided to use my SAS skills to change that! When it comes to restaurants, I eat out a lot (and by 'a lot' I mean I never
I began 2015 by compiling a list of popular articles from my blog in 2014. Although this "People's Choice" list contains many interesting articles, some of my favorites did not make the list. Today I present the "Editor's Choice" list of articles that deserve a second look. I've highlighted one
Zwischen den Jahren hat man Zeit für Familie, Freunde und Hobbies. Dass eines meiner Hobbies "TV-Serien" ist, hat vielleicht mit den in meiner Kindheit beliebten Weihnachtsserien zu tun. (Mein Favorit: Jack Holborn. Kennen Sie die Serie noch?) Aber die Zeiten ändern sich und wir uns mit: Die ZDF-Produktion war gestern, heute lebe das
.@philsimon on the different folks you'll encounter in many large organizations.
~ This article is co-authored by Binod Jha, Global Product Manager for Insurance Solutions at SAS, and Amol Kokane, Senior Development Manager for Insurance & Risk Management Solutions at SAS ~ How might insurance policies change if sensor data could be automatically transmitted and analyzed from your car, your home and even your
By now you have seen dozens of articles with trends and predictions for what the hospitality industry should expect in 2015. I’m not going to add to those, or rehash them exhaustively here. You’ve all probably read them yourself and gathered the highlights: optimism, more acquisitions, transaction volumes will stay
A popular DATA step programming technique frequently used by SAS users is the ability to identify the beginning and ending observation in by-groups. The way it works is whenever a BY statement is specified with a SET statement, two temporary variables are created in the Program Data Vector (PDV), FIRST.variable
I cannot speak from experience, but predominately an Insurance CEO has three primary objectives: Grow the business Reduce expenses Ensure compliance. Let’s individually consider each of these objectives in more detail. Grow the Business How does an insurance company grow from a $2bn to a $3bn organization? Essentially, insurance has
A SAS programmer recently posted a question to the SAS/IML Support Community about how to compute the kth smallest value in a vector of numbers. In the DATA step, you can use the SMALLEST function to find the smallest value in an array, but there is no equivalent built-in function
Can you guess the 5 most common New Year's resolutions? Compare your guesses to the survey results!... Being a data meister, I'm always on the lookout for seasonal data. I recently did a Web search for "new year's resolutions" and found an interesting article on the You Gov UK website.
Happy New Year to you, your families, and your colleagues! This is the time of year when people make all types of New Year's resolutions. According to the USA.Gov web site, the most popular resolutions are: Lose Weight Volunteer to Help Others Quit Smoking Get a Better Education Get a
I published 118 blog posts in 2014. This article presents my most popular posts from 2014 and late 2013. 2014 will always be a special year for me because it was the year that the SAS University Edition was launched. The University Edition means that SAS/IML is available to all
Since now is the time when we reflect on the past year and make resolutions for next year, in this post I reflect on my Data Roundtable posts from the past year and use them to offer a few New Year’s data resolutions for you and your organization to consider in
I have participated in many discussions about master data management (MDM) being “just” about improving the quality of master data. Although master data management includes the discipline of data quality, it has a much broader scope. MDM introduces a new approach for managing data that isn't in scope of traditional data quality
The last three parts of our conversion blog (see all of the posts here) go hand-in-hand and require the most time on the project plan. Development - During development of the conversion routines, you may want to consider using error handling standards based on corporate standards. This is where data
In Part 1 of this blog series, I touched on the problems created by the underground economy, and framed the size and scope. But important questions remain about the types of businesses that are part of the underground economy, how they do it, and what the driving forces behind this
.@philsimon on the relationship between metadata and unstructured data.
Probablemente usted recuerde la entrada masiva de los smartphones con pantalla táctil al mercado en el año 2006. En ese entonces, aún la conversación sobre transacciones móviles se daba entre unos pocos. Las actividades que están ahora firmemente arraigadas a nuestra vida presente, tal vez eran sólo ciencia ficción. Ahora,
Historically healthcare has been most ‘self’ motivated to improve its ‘cost containment’ processes and methods. This is evident from the significant gap that exists between the technology and process in finance versus healthcare. Many healthcare organizations (either government or commercial) are not ‘profit’ oriented – take the Blues for example,
As this is the week of Christmas, many, myself included, have Christmas songs stuck in their head. One of these jolly jingles is Santa Claus Is Coming To Town, which includes the line: “He knows if you’ve been bad or good, so be good for goodness sake!” The lyric is a
The physical and social costs of untreated mental illness are significant and have been discussed in detail in previous posts. Now let’s talk about the immense financial costs, then I’ll wrap up the series with a conclusion. The financial costs cover a broad cross-section of society, including government services and
There are some things every company should know about the nature of its business. Yet many organizations don't know these fundamentals -- either because they are short on resources, or their resources don't have the analytical skills to do the work. The summer research projects offered by the Lancaster Centre for Forecasting,
With our recent client engagements in which the organization is implementing one or more master data management (MDM) projects, I have been advocating that a task to design a demonstration application be added to the early part of the project plan. Many early MDM implementers seem to have taken the
