I previously wrote about the best way to suppress output from SAS procedures. Suppressing output is necessary in simulation and bootstrap analyses, and it is useful in other contexts as well. In my previous article, I wrote, "many programmers use ODS _ALL_ CLOSE as a way to suppress output, but
The final figures are in! This year there was a fierce battle for the top spot of the SAS Global Forum 2015 books bestseller list. In a nail biting finish, newcomer, Exchanging Data between SAS and Microsoft Excel: Tips and Techniques to Transfer and Manage Data More Efficiently, beat off
“Phew! That tip alone was a life saver,” said a student in one of my SAS SQL classes. “Before, I would have to read about ten Google search results before I could find that content of the sort you shared in class.” That student was referring to the tip I
In my last post, we examined the growing importance of event stream processing to predictive and prescriptive analytics. In the example we discussed, we looked at how all the event streams from point-of-sale systems from multiple retail locations are absorbed at a centralized point for analysis. Yet the beneficiaries of those
Das Big Data Lab von SAS - Big Data Strategie 1995 - World Wide Web. Erinnern Sie sich, wie komplex und kompliziert es für ein Unternehmen war, eine eigene Website aufzubauen, Anwendungen zu definieren, diese redaktionell zu betreuen und die nötige Infrastruktur zu betreiben – heute unvorstellbar! Und sogar das Surfen
I saw an interesting graph on dadaviz.com that claimed Italians had gone from drinking twice as much as Americans in 1970, to less than Americans in recent years. The data analyst in me just had to "independently verify" this factoid ... But before I get into the technical part of this
The real reason companies cleanse the historical demand is that traditional forecasting solutions were unable to predict sales promotions or correct the data automatically for shortages, or outliers. To address the short comings of traditional technology, companies embedded a cleansing process of adjusting the demand history for shortages, outliers, and
A proof of concept (POC) is smartest way for customers to evaluate if a product meets the required objectives, and the best way for vendors to demonstrate why they feel they are best placed to resolve the current outstanding problems. However, not all POCs are successful. Let’s explore why. What is
What prompted me to find a co-author and write a new edition of my original book on PROC TABULATE? It’s those inventive developers at SAS. They keep adding new features to make the product even better. There are too many new features and techniques in the book to name, but these are
SAS procedures can produce a lot of output, but you don't always want to see it all. In simulation and bootstrap studies, you might analyze 10,000 samples or resamples. Usually you are not interested in seeing the results of each analysis displayed on your computer screen. Instead, you want to
Recently I had the privilege of hearing Nathan Falkenborg, Head of Consulting & Analytics, North Asia at Visa speak at the SAS Executive Forum in Singapore. Nathan has also spoken at SAS Premier Business Leadership Series where he talked about how the analytics guy won over the marketers at Visa.
As we enter the era of “everything connected,” we cannot forget that gathering data is not enough. We need to process that data to gain new knowledge and build our competitive advantage. The Internet of Things is not just a consumer thing – it also makes our businesses more intelligent. Whenever
The cottage industry was based on workers buying raw materials, bringing them home and producing hand-crafted items to sell. The system worked, but was slow, tedious and expensive, producing goods that were affordable only by the rich. The Industrial Revolution changed all that. The factory system brought machines and workers
After acquiring personal IoT data in part 1 and cleaning it up in part 2 of this series, we are now ready to explore the data with SAS Visual Analytics. Let's see which answers we can find with the help of data visualization and analytics! I followed the general exploratory workflow
We have spent a good deal of time at the Analytic Hospitality Executive advocating for the value of big data for hospitality. Just a few months ago, for example, I wrote a two part series on how Big Data was a “big opportunity” for hotels and casinos. Our goal at
.@philsimon says that you shouldn't bring a knife to a gun fight.
The XLSX libname engine in SAS allows you to read and write Microsoft Excel files in the same way that you can work with other data sets and databases. This article describes the basic (and some limitations) of the XLSX engine.
(Otherwise known as Truncate – Load – Analyze – Repeat!) After you’ve prepared data for analysis and then analyzed it, how do you complete this process again? And again? And again? Most analytical applications are created to truncate the prior data, load new data for analysis, analyze it and repeat
Well OK, so there is an "i" in science, but being a data scientist is certainly not a lonesome job. Engagement with other team members is essential with data analytics work, so you never really work in isolation. Without the rest of the team, we would fail to ask all
This SAS tip is from Robert Virgile and his book “SAS Macro Language Magic: Discovering Advanced Techniques”. We hope you find this tip useful. You can also read an excerpt from Virgile’s book. When CALL SYMPUT creates a new macro variable, it places that variable in “the closest non-empty symbol
Event stream processing (ESP) and real-time processing (RTP) so often come up in the same conversation that it begs the question if they are one and the same. The short answer is yes and/or no. But since I don’t need the other kind of ESP to know that you won’t
The Two-Bin Inventory Control System So what is a two-bin inventory control system? Whether you realize it or not, you are probably very familiar with the concept. In fact, if you are reading this on a tablet or smartphone, you may be sitting next to one right now (see photo). According to
When I was an undergraduate physic major, my favorite professor would start each class with a joke or pun. One day he began class with a paraphrase of a famous quote from the movie Star Trek 4: The Voyage Home (the one with the whales). "Today," my professor said, imitating
As discussed in the last BFD post, sometimes a difficult and expensive problem doesn't have to be solved -- it can simply be avoided. When the teetering boulder threatened the baby below the cliff, we removed the baby and no longer had to worry about propping up the boulder. When it
Mount St. Helens volcano here in the US had a big eruption 35 years ago this week! Do you know exactly where it is located? Perhaps this SAS map can help... As you might have guessed, I'm a big fan of the awesome power of nature (hurricanes, tornadoes, lightning, earthquakes, and
We often hear questions like: Are the shared service chargebacks to my business units’ cost centers accurate and transparent? Will I save any money by using a centralized shared service? Why should I consider a centralized shared service? These are all good questions. To answer them, you need to understand
You are going to be spending proportionately more of your IT budget on security than you have previously spent or ever wanted to spend. Why? Because you and everyone else on this planet is engaged in the still early stages of an escalating information arms race, that, while you didn’t
In 1988 President Ronald Reagan proclaimed May as National Foster Care Month as a way to recognize foster parents for opening their homes to and caring for children in need. This annual celebration has grown to generate awareness of foster care and a recognition of all involved. The children, foster
What sends a data management product to the top of the “hot” list? In a word – speed. Especially when that speed can gracefully accommodate the huge world of streaming data from the Internet of Things. One of SAS’ hottest (and recently enhanced) products, SAS Event Stream Processing is an
It seems like everyone is searching for ‘best practice’ these days. We are constantly looking to learn from what is being held up as good, leading and perhaps even the best itself. While this is a valid exercise, I believe we are missing an opportunity to take a closer look
