Blogs

Blogs

Advanced Analytics

Move beyond spreadsheets to data mining, forecasting, optimization – and more

Advanced Analytics

Rick WicklinJuly 28, 2014 0

Lexicographic combinations in SAS

In a previous blog post, I described how to generate combinations in SAS by using the ALLCOMB function in SAS/IML software. The ALLCOMB function in Base SAS is the equivalent function for DATA step programmers. Recall that a combination is a unique arrangement of k elements chosen from a set

Read More

Advanced Analytics | Analytics

Mike GillilandJuly 18, 2014 0

Forecasting and supply chain blogs

In the summer heat, when The BFD alone isn't quite quenching your thirst for forecasting know-how, here are several other sources: CatchBlog -- by Steve Morlidge of CatchBull From his 2010 book Future Ready (co-authored with Steve Player), to his recent 4-part series in Foresight dealing with the "avoidability" of forecast

Read More

Advanced Analytics

Jack HymansonJuly 17, 2014 0

Beyond sensing and shaping... Beyond supply and demand

What is your primary goal as a supply chain professional? It’s not about demand sensing, demand shaping or even supply planning and demand planning. At the end of the day, it’s about profit optimization. Albeit important, demand sensing and shaping are only a piece of the equation and if isolated, decisions

Read More

Advanced Analytics | Learn SAS | Programming Tips

Rick WicklinJuly 16, 2014 0

How to share SAS/IML programs with the world

Have you written a SAS/IML program that you think is particularly clever? Are you the proud author of SAS/IML functions that extend the functionality of SAS software? You've worked hard to develop, debug, and test your program, so why not share it with others? There is now a location for

Read More

Advanced Analytics | Analytics

Mike GillilandJuly 15, 2014 0

IIF/SAS grants to support research on forecasting

Again this year (for the 12th time), SAS Research & Development has funded two $5,000 research grants, to be awarded by the International Institute of Forecasters. Criteria for award of the grant will include likely impact on forecasting methods and business applications. Consideration will be given to new researchers in

Read More

Advanced Analytics

Rick WicklinJuly 14, 2014 0

A log transformation of positive and negative values

In my four years of blogging, the post that has generated the most comments is "How to handle negative values in log transformations." Many people have written to describe data that contain negative values and to ask for advice about how to log-transform the data. Today I describe a transformation

Read More

Advanced Analytics

David PopeJuly 9, 2014 0

How to dilute the value of analytics

Business Intelligence (BI) can mean many things to many people, but generally BI is associated with business reports. When you fold business analytics (BA), especially advanced analytics that are predictive or prescriptive, under the BI umbrella you inherently dilute the value proposition that analytics can provide to an organization. Why

Read More

Advanced Analytics | Analytics

Renee NockerJuly 8, 2014 0

What is a better decision worth?

The word “analytics” is widely misused and misunderstood. While SAS arguably invented the advanced analytics and predictive analytics categories more than 38 years ago, other software vendors have used the term to describe things like reporting, monitoring, and tracking what happened. The value of these more simple capabilities are easily

Read More

Advanced Analytics | Analytics

Mike GillilandJuly 3, 2014 0

Foresight/SAS webinar: forecasting on mobile devices

On July 24, 10am ET, Stavros Asimakopoulos delivers the next installment of the Foresight/SAS Webinar Series, "Forecasting 'In the Pocket': Mobile Devices Can Improve Collaboration." Based on his article (co-authored with George Boretos and Constantinos Mourlas) in the Winter 2014 issue of Foresight, Stavros will discuss how smartphones, tablet computers

Read More

Advanced Analytics | Analytics

Mike GillilandJune 27, 2014 0

Forecasting across a time hierarchy with temporal reconciliation

The BFD blog probably won't make you the best forecaster you can be. There are plenty of books and articles and world class forecasting researchers (many of them meeting next week in Rotterdam at the International Symposium on Forecasting), that can teach you the most sophisticated techniques to squeeze every last

Read More

Advanced Analytics

Annelies TjetjepJune 25, 2014 0

Treat Yourself with Text

Did you check your email and/or favourite social media site before leaving for work this morning? Did you do it before getting out of bed? Don’t worry, you’re not alone. I do it every morning as a little treat while I “wake up” and whether I realize it or not,

Read More

Advanced Analytics

Udo SglavoJune 18, 2014 0

Combined forecasts: what to do when one model isn’t good enough

My esteemed colleague and recently-published author Jared Dean shared some thoughts on how ensemble models help make better predictions. For predictive modeling, Jared explains the value of two main forms of ensembles --bagging and boosting. It should not be surprising that the idea of combining predictions from more than one

Read More

Advanced Analytics

Rick WicklinJune 18, 2014 0

Approximating a distribution from published quantiles

A colleague asked me an interesting question: I have a journal article that includes sample quantiles for a variable. Given a new data value, I want to approximate its quantile. I also want to simulate data from the distribution of the published data. Is that possible? This situation is common.

Read More

Advanced Analytics | Analytics

Mike GillilandJune 13, 2014 0

Weather forecasts: deterministic, probabilistic or both?

In 1965's Subterranean Homesick Blues, Bob Dylan taught us: You don't need a weatherman / To know which way the wind blows In 1972's You Don't Mess Around with Jim, Jim Croce taught us: You don't spit into the wind By combining these two teachings, one can logically conclude that:

Read More

Advanced Analytics

Rick WicklinJune 13, 2014 0

Geometry, sensitivity, and parameters of the lognormal distribution

Today is my 500th blog post for The DO Loop. I decided to celebrate by doing what I always do: discuss a statistical problem and show how to solve it by writing a program in SAS. Two ways to parameterize the lognormal distribution I recently blogged about the relationship between

Read More

Advanced Analytics | Analytics

Mike GillilandJune 12, 2014 0

Guest blogger: Len Tashman previews Summer 2014 issue of Foresight

Our tradition from Foresight’s birth in 2005 has been to feature a particular topic of interest and value to practicing forecasters. These feature sections have covered a wide range of areas: the politics of forecasting, how and when to judgmentally adjust statistical forecasts, forecasting support systems, why we should

Read More

Advanced Analytics | Learn SAS

Rick WicklinJune 9, 2014 0

How to generate a grid of points in SAS

In many areas of statistics, it is convenient to be able to easily construct a uniform grid of points. You can use a grid of parameter values to visualize functions and to get a rough feel for how an objective function in an optimization problem depends on the parameters. And

Read More

Advanced Analytics

Rick WicklinJune 4, 2014 0

Simulate lognormal data with specified mean and variance

In my book Simulating Data with SAS, I specify how to generate lognormal data with a shape and scale parameter. The method is simple: you use the RAND function to generate X ~ N(μ, σ), then compute Y = exp(X). The random variable Y is lognormally distributed with parameters μ

Read More

Advanced Analytics | Analytics

Mike GillilandJune 3, 2014 0

Upcoming forecasting conferences

We're entering the busy season for forecasting events, and here is the current calendar: Analytics2014 - Frankfurt The European edition of Analytics2014 kicks off tomorrow in Frankfurt, Germany. Five hundred of the leading thinkers and doers in the analytics profession hook up for two full days of interaction and learning.

Read More

Advanced Analytics

Rick WicklinMay 12, 2014 0

How to create a string of a specified length in SAS/IML

In my recent post on how to understand character vectors in SAS/IML, I left out an important topic: How can you allocate a character vector of a specified length? In this article, "length" means the maximum number of characters in an element, not the number of elements in a vector.

Read More

Advanced Analytics

Rick WicklinMay 7, 2014 0

This article is actually fastidious: How spammers generate random comments for blogs

Last week Chris Hemedinger posted an article about spam that is sent to SAS blogs and discussed how anti-spam software helps to block spam. No algorithm can be 100% accurate at distinguishing spam from valid comments because of the inherent trade-off between specificity and sensitivity in any statistical test. Therefore,

Read More

Advanced Analytics | Learn SAS

Rick WicklinMay 5, 2014 0

Blanks and lengths: Understanding SAS/IML character vectors

SAS programmers are probably familiar with how SAS stores a character variable in a data set, but how is a character vector stored in the SAS/IML language? Recall that a character variable is stored by using a fixed-width storage structure. In the SAS DATA step, the maximum number of characters

Read More

Advanced Analytics

Michael ThomasMay 2, 2014 0

Big data in your face

If you've followed technology news in the last few weeks, you've probably seen a proliferation of awestruck faces wearing blacked out goggles, similar to the image I'm using here. The goggles are Oculus Rift immersive VR headsets, and the news is the $2 billion dollar acquisition of Oculus by Facebook.

Read More

Advanced Analytics

examples of mixed rice

Jared DeanMay 1, 2014 0

How ensemble models help make better predictions

My oldest son is in the school band, and they are getting ready for their spring concert. Their fall concert was wonderful; hearing dozens of students with their specific instruments playing together creates beautiful, rich sounding music. The depth of sound from orchestral or symphonic music is unmatched. In data

Read More

Advanced Analytics | Analytics

Mike GillilandApril 30, 2014 0

A naive forecast is not necessarily bad

As we saw in Steve Morlidge's study of forecast quality in the supply chain (Part 1, Part 2), 52% of the forecasts in his sample were worse than a naive (random walk) forecast. This meant that over half the time, these companies would have been better off doing nothing and

Read More

Advanced Analytics | Analytics | Customer Intelligence

Carl FarrellApril 28, 2014 0

Baskets full of benefits from analytics

With as much as I travel, I have to confess that I’ve become a bit of a food snob. And for good reason, I might add. Two days in a Chilean hospital will make anyone stick with what they know and trust. After that experience, it was just me and

Read More

Advanced Analytics | Analytics

Mike GillilandApril 24, 2014 0

Forecast quality in the supply chain (Part 2)

As we saw last time with Steve Morlidge's analysis of the M3 data, forecasts produced by experts under controlled conditions with no difficult-to-forecast series still failed to beat a naive forecast 30% of the time. So how bad could it be for real-life practitioners forecasting real-life industrial data? In two words:

Read More

Advanced Analytics | Analytics

Mike GillilandApril 23, 2014 0

Forecast quality in the supply chain (Part 1)

The Spring 2014 issue of Foresight includes Steve Morlidge's latest article on the topic of forecastability and forecasting performance. He reports on sample data obtained from eight business operating in consumer (B2C) and industrial (B2B) markets. Before we look at these new results, let's review his previous arguments: 1. All

Read More

Advanced Analytics

Rick WicklinApril 21, 2014 0

Local functions (not!) in the SAS/IML language

I have previously written about the scope of local and global variables in the SAS/IML language. You might wonder whether SAS/IML modules can also have local scope. The answer is no. All SAS/IML modules are known globally and can be called by any other modules. Some object-oriented programming languages support

Read More

Advanced Analytics | Analytics

Mike GillilandApril 17, 2014 0

Guest blogger: Len Tashman previews Spring 2014 issue of Foresight

Here is editor Len Tashman's preview of the new Spring 2014 issue of Foresight. In particular note the new article by Steve Morlidge of CatchBull, reporting on an analysis of eight B2B and B2C companies, which we'll discuss in a separate post. An organization’s collaboration in forecasting and planning has

Read More