Over the past decade in insurance, the rise of the aggregators (organisations that compare quotes between different insurers) and direct channels has had a profound impact on personal lines distribution in the UK. However, personal lines brokers remain a critical route to market, especially at a time when many insurers
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
There has been much discussion on the SAS Communities page on usage of different symbols in a graph. The solutioin can vary based on the SAS release. New features have been added at SAS 9.4 releases to SG Procedures and GTL that make this very easy. With SAS 9.4M1, almost any combination is
When designing a SAS Grid Manager architecture, there is a requirement that has always been a critical component: a clustered file system. Over the years, vendors have released versions of these systems that are more robust and SAS has increased the minimum IO requirements, but the basic design has never changed—until now.
Healthier Alternatives to Quench Your Thirst With research linking sugar to heart disease, diabetes and GI imbalances, many of us are trying to reduce or eliminate sugar. And to add salt (or sugar) to the wound, new studies are suggesting that some artificial sweeteners ALSO have negative health consequences. When
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
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
.@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
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
With the growing use of SAS on commodity hardware, many organizations are running lots of SAS servers on separate instances of operating system in a SAS infrastructure. This configuration is great for optimizing resources, but when these SAS servers have to share data, then SAS recommends the use of a clustered
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
Most of us have volunteered in some capacity -- as a guinea pig in a magic show, as a helping hand with a charity, or perhaps as a coach for a child’s sports team. Why do we do it? I think the cliché holds true. We get as much, or
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.
Over the Christmas Holidays I saw an graph of agricultural exports to Russia in 2013. The part that caught my eye was the upper part of the graph, showing the breakdown of the trade with Russia as a horizontal stacked bar with custom labels. The value for each region / country
It is January. In the United States, this means NFL playoff time! A perfect time (if you are a geeky SAS/OR guy) to use PROC OPTGRAPH to rank the best teams in the NFL. Ranking Sports Teams Ranking of sports teams is a popular (and controversial) topic, especially in the
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
Last week a user expressed the need to create a graph like the one shown on the right using SAS. This seems eminently doable using GTL and I thought I would undertake making this graph using SAS 9.3. The source data required to create this graph is only the
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.
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
