The holiday season is a wonderful time of year – steeped in tradition, family and friends, and giving. This time of year has also created a burgeoning shopping period with decorations appearing by Labor Day! In 2012, the 92nd Street Y in New York and the United Nations Foundation tried a new
English
I have probably touched on this topic many times before: accessing the data that has been loaded into a master data environment. In recent weeks some client experiences are really highlighting something that is increasingly apparent (and should be obvious) for master data management: the need to demonstrate that it
The holidays are sometimes chaotic, especially for those tasked with analyzing consumer shopping data! I would like to share a few tips on adding order to your chaotic data. SAS recently published an interesting article, sharing the results from a consumer survey. The infographics in the article showed high-level summary information, such as:
There are multiple types of data models, and some companies choose to NOT data model purchased software applications. I view this a bit differently. I think that any purchased application is part of our enterprise, thus it is part of our enterprise data model (or that concept is part of the
A common question on SAS discussion forums is how to compute the minimum and maximum values across several variables. It is easy to compute statistics across rows by using the DATA step. This article shows how to compute the minimum and maximum values for each observation (across variables) and, for
When you examine where most data quality defects arise from, you soon realise that your source applications are a prime culprit. You can argue that the sales team always enter incomplete address details, or the surgeons can't remember the correct patient type codes but in my experience the majority of
➤ DISCLOSURE! In June 2018 Google introduced changes to the way it handles its Maps platform. They now require API key in order to embed a map, plus Google Maps "projects" must now be associated with a billing account. Unless these new Google rules are met, Google maps described in
Calling All Forecasters Have you tried Forecast Value Added analysis? What did you find out? Are you willing to share your learnings (at least those that can be revealed publicly)?Would you like to be featured in a new blog series on FVA, published by the Institute of Business Forecasting? The IBF was
I generally don’t use this blog to air my personal experiences, but recent events have reminded me of a few things that I think would benefit our Analytic Hospitality Executives and their organizations to also be reminded of. This past week, I took my fifth trip to Asia this year.
Data. Our industry really loves that word, making it seem like the whole world revolves around it. We certainly enjoy revolving a lot of words around it. We put words like master, big, and meta before it, and words like management, quality, and governance after it. This spins out disciplines
Several new capabilities and components are available in SAS Environment Manager 2.4, the web-based administration solution for a SAS environment. For me, the most important enhancement is probably the SAS Environment Manager Service Management Architecture Framework, which provides features and functions that enable SAS Environment Manager to fit into a
I've written about how to generate a sample from a multivariate normal (MVN) distribution in SAS by using the RANDNORMAL function in SAS/IML software. Last week a SAS/IML programmer showed me a program that simulated MVN data and computed the resulting covariance matrix for each simulated sample. The purpose of
Having worked in analytics for over 25 years, I’ve never really felt part of the ‘cool gang’. However that’s changing and all of a sudden, at long last, it is "chic to be geek!" Research published by SAS UK and the Tech Partnership reveals that from 2013 to 2020, the
Last year, 50 companies came knocking on the doors of Rotman School of Management in Canada to recruit Masters of Business Administration (MBA) grads with SAS skills. This year, Rotman partnered with SAS to offer SAS Programming to interested candidates. Last Sunday, I had the amazing opportunity to teach SAS
As Sheldon Cooper would say, this is the first episode of "Fun with Charts". I did not find a cool term like "Vexillology" and "Cartography" is taken by map making, so let us go with "Chartology". Yesterday, I saw a couple of interesting bar charts as shown on the right. I thought
I'm not really into traveling and eating with family at Thanksgiving, but what are the local restaurant alternatives? The list was a bit overwhelming, so I used SAS to help analyze my options... My holiday meal fall-back has always been the Waffle House - they're open 24/7, 365 days a
A lack of mental health professionals is pushing the US mental health system to a crisis point. And even if a psychiatrist commits someone to a facility, there may not be a bed for them. A startling 55 percent of all US counties have zero psychiatrists, psychologists or social workers
The 2014 INFORMS Annual Conference in San Francisco was quite a success. Record attendance, diverse program, great city, lovely weather: who can ask for more? SAS and, in particular, SAS/OR was well-represented with a number of talks in all areas of operations research. Here is a somewhat arbitrary selection, please click
Can you spare a few minutes to assist researchers at the Lancaster Centre for Forecasting? We have been commissioned by the European Journal of Operational Research to write a review article on Supply Chain Forecasting. In undertaking this task, we would like to ensure that the topics covered reflect the priorities
For many industries, big data analytics have opened numerous doors for more employees to be groundbreaking and to challenge the corporate status quo. Prior to big data technologies, risk taking behaviors were primarily reserved for provocative souls who stretched organizational boundaries to disrupt industries, such as airline revenue management. There were winners and losers
Don't be shy! Interviewing people BEFORE or AFTER a facilitated session just takes a bit of confidence, and good preparation. Building your confidence gets easier and easier the more you participate in interviews. The objective is to prepare and not waste anyone’s valuable time. I like to prepare notes based on
With Turkey Day coming up in a couple days, one thing I know I'm looking forward to is help from my parents, so my husband and I can catch up on some much needed sleep....oh the joys of being parents of little guys! This week, I'm pleased to
SAS software contains a lot of features, and each release adds more.To make sure that you do not miss new features that appear in the SAS/IML language, the word cloud on the right sidebar of my blog contains numbers that relate to SAS or SAS/IML releases. For example, you can
Well, this is a kick to the giblets. I assumed when I was summoned to the White House it was in recognition of my tireless advocacy for turkey rights. I wasn’t expecting a press conference in the rose garden or anything, just a meet and greet with the prez and
Not all fraud originates from the dark underground of criminal enterprises. In fact, fraud could literally be right under our noses, or in the cubicle next to us. The “Insider Threat” has many names – internal fraud, occupational fraud, even espionage – and uses authorized internal access and knowledge to
Every day there are news stories of fraud perpetrated against federal government programs. Topping the list are Medicaid and Medicare schemes which costs taxpayers an estimated $100 billion a year. Fraud also is rampant in other important federal programs, including unemployment and disability benefits, health care, food stamps, tax collection,
Many managers still perceive data quality projects to be a technical endeavour. Data being the domain of IT and therefore an initiative that can be mapped out on a traditional project plan with well-defined exit criteria and a clear statement of requirements. I used to believe this myth too. Coming
Arrays are a powerful SAS programming tool. They can be used to simplify coding for repetitive calculations, to transpose data and to evaluate variables in a non-sequential manner. Sometimes users are intimidated by the term array, but in SAS, an array is simply a grouping of variables that lasts for
My colleagues at the SAS & R blog recently posted an example of how to program a permutation test in SAS and R. Their SAS implementation used Base SAS and was "relatively cumbersome" (their words) when compared with the R code. In today's post I implement the permutation test in
Last week I had the opportunity to attend the INFORMS Annual Meeting in San Francisco. For those of you not familiar with this organization or conference, the Institute for Operations Research and the Management Sciences (INFORMS) is the largest society in the world for professionals in the field of operations