From the public debate over Amazon’s workplace culture to the Security and Exchange Commission’s approval of the CEO-to-worker rule, it’s been an interesting few weeks for those of us who care about sustainable organizations. Clearly people have strong feelings about what companies owe society and how front-line workers should be
The title of this blog post might seem strange, but I occasionally need to compute the number of digits in a number, usually because I am trying to stuff an integer value into a string. Each time, I have to derive the formula from scratch, so I am writing this
How long have you been reading SAS blogs? And do you have thoughts on how we can improve them? In 2007, we launched the SAS blog program with just one blog and a handful of bloggers. Today, we have more than 30 blogs and hundreds of active bloggers. As we
You may not be in London on October 7 to take advantage of the Lancaster Centre for Forecasting's free workshop on promotional forecasting. However, there are still plenty of forecasting educational opportunities coming up this fall: SAS Business Knowledge Series Best Practices in Demand-Driven Forecasting (Chicago, September 24-25) My colleague
In a little more than two weeks, I will be in one of my favorite places, San Diego, California, recruiting potential SAS Press authors at the JMP Discovery Summit, which will be held at the beautiful Paradise Point Resort and Spa from 14 September to 17 September 2015. I’m especially
This post is the second in a series that illustrates three different solutions to "flattening" hierarchical data. Solution 1, from my previous post, created one observation per header record, summarizing the detail data with a COUNT variable, like this: Summary Approach: One observation per header record Obs Family Count
While much of what they say is over my non-technical head, one thing is clear: SAS research and development team members are clearly excited by the new capabilities they have added to the newest release of SAS Analytics. Their pride of accomplishment is plain to see -- even by me
While not on the same level of Rush, I do fancy myself a fan of The Who. I'm particularly fond of the band's 1973 epic, Quadrophenia. From the track "5:15": Inside outside, leave me alone Inside outside, nowhere is home Inside outside, where have I been? The inside-outside distinction is rather apropos
Ugh! Your favorite regression procedure just printed a warning to the SAS log. Something is wrong, and your attempt to fit a model to the data has not succeeded. A typical message is "WARNING: The validity of the model fit is questionable," perhaps followed by some additional diagnostic messages about
A family and its members represent a simple hierarchy. For example, the Jones family has four members: A text file might represent this hierarchy with family records followed by family members' records, like this: The PROC FORMAT step below defines the codes in Column 1: proc format; value $type
Are you eager to explore and understand your data? Do you want to improve processes and drive more revenue? Do you want to work with data using an intuitive, easy-to-use interface? This is now possible with visual analytics, technology which combines analytics with interactive visualizations. As published in a recent
Do you use an array of tools to perform predictive analytics on your data? Is your current tool not flexible enough to accommodate some of your requirements? SAS Enterprise Miner may be your solution. With growing number of data mining applications, having a tool which can do variety of analysis
In my last post, I noted that the flexibility provided by the concept of the schema-on-read paradigm that is typical of a data lake had to be tempered with the use of a metadata repository so that anyone wanting to use that data could figure out what was really in
One of my presentations at SAS Global Forum 2015 was titled "Ten Tips for Simulating Data with SAS". The paper was published in the conference proceedings several months ago, but I recently recorded a short video that gives an overview of the 10 tips: If your browser does not support
Our friends at the Lancaster Centre for Forecasting have announced their next free practitioner workshop. It will be held Wednesday October 7,1:00-5:15pm, at BMA House, Tavistock Square, London WC1H. This session's top is: Promotional Modelling and Forecasting Understanding and forecasting the effects of a promotion for both retailers and manufacturers
No matter where I go in the world, I’m constantly amazed by the similarities in business challenges facing organizations around the globe. One of the most common is getting business users to actually adopt and use the insights gained from the great work performed by analytics teams and IT organizations.
As a linguist, I am fascinated with words, their meanings and use. So when I recently saw the words “learning analytics” in a conference paper title, I started thinking about the prevalence of the word “analytics” itself. In the last decade, we have preceded “analytics” with many modifiers referring to
The term “disruptive technologies” frightens many organizations, but to companies like Alibaba, Uber, Airbnb and Facebook, it’s the secret to their success. These four companies from unrelated industries have one major commonality: They don’t “own” anything, at least not in the traditional sense. What they provide is a digital service,
I recently saw an article on washingtonpost.com showing what methods are used to generate electricity in each state. The data was interesting enough that I decided to try my hand at graphing and mapping it with our SAS software. Read along to see what I kept the same, and what
So you think you can outsmart your statistical forecast? Apparently, lots of people do. In "Judgmental Adjustments to Forecasts in the New Economy" (Foresight, Issue 38 (Summer 2015), 31-36), Manzoor Chowdhury and Sonia Manzoor argue that forecasters are becoming more dependent on judgmental adjustments to a statistical forecast. Sometimes this
Our new book, Exercises and Projects for The Little SAS® Book Fifth Edition, includes a variety of exercises to help people learn SAS programming. Rebecca Ottesen, Lora Delwiche and I designed this book so that it can be used either in a classroom setting or by individual readers working alone.
I wanna be an airborne ranger, Live the life of guts and danger.* If you are an 80's movie buff, you might remember the scene in The Breakfast Club where Bender, the juvenile delinquent played by Judd Nelson, distracts the principal by running through the school singing this song. Recently,
The intersection of data governance and analytics doesn’t seem to get discussed as often as its intersection with data management, where data governance provides the guiding principles and context-specific policies that frame the processes and procedures of data management. The reason for this is not, as some may want to
In my first blog post in the Education meets Big Data blog series, I explained the need for Statewide Longitudinal Data Systems(SLDS). In the blog post following, I shared an interview with Armistead Sapp, one of the authors of the book, "Implement, Improve and Expand Your Statewide Longitudinal Data System." In this
Machine learning is all about automating the development process for analytical models. One way to extend the use of machine learning is to broaden your library of machine learning algorithms. Another way is to scale your machine learning process by reducing the time required to process machine learning algorithms on
10 Gründe, warum Sie das Big Data Analytics Forum am 6.10. in Frankfurt besuchen sollten Big Data ist in Deutschland angekommen. Das ist die wesentliche Veränderung des letzten Jahres. Das sagen nicht nur diverse Analysten oder Studien (wie die jüngste BARC-Studie zu "Big Data Use Cases"), sondern zeigen auch meine
I've spent a great deal of time in my consulting career railing against multiple systems of record, data silos and disparate versions of the truth. In the mid-1990s, I realized that Excel could only do so much. To quickly identify and ultimately ameliorate thorny data issues, I had to up
Are you thinking about completing a fall race? Whether it’s a 5K, 10K, or half or full marathon, it’s going to be here before you know it. I’ve been running for years, and I can tell you, there’s nothing like the motivation of signing up for a race to get
Typically a correlation analysis reports the correlations between all pairs of variables, including the variables with themselves. The resulting correlation matrix is square, symmetric, and has 1s on the main diagonal. But suppose you are interested in only specific combinations of variables. Perhaps you want the pairwise correlations between one
The Wall Street Journal recently published a study of the top 17 medical areas (or body parts) that venture capitalist investments are likely to benefit. They used graphs to summarize the results, but "the graph guy" in me just couldn't resist trying to improve them. Did my improvements help? -
