As I was preparing for a customer introduction to using SAS Enterprise Guide, I asked them to send me all the questions they had regarding the Enterprise Guide usage. It turned out that many of their questions can be answered with a single feature called an autoexec, or automatically executable
Solving the mystery of Malaysia Airlines Flight 370 hinges on the finding the plane's black boxes, or flight data and cockpit voice recorder. An airplane’s black box is something we hope never has to be used, but when there’s a problem, we sure are glad that it’s there. The black
I’ve been to a fair number of SAS User Group International (SUGI) and SAS Global Forum conferences over the years, but I don’t think I’ve been to one as productive, well-organized and fun as this year’s conference in Washington DC. Part of what made the conference very relevant for many
“My goal is to constantly improve the quality and stability of our software while at the same time innovating,” said Vice President of SAS Resarch and Development Armistead Sapp yesterday at the SAS Global Forum Technology Connection. Hosted by Product Management Director Michele Eggers, the Technology Connection focused not only on
Well, if I were asked to name the most intriguing spot in the SAS Support and Demo Area, it would probably be The Catalyst Café sponsored by SAS R&D. This exciting new area at SAS Global Forum 2014 is aptly name: a informal meeting place dedicated to jump-starting ideas for
Yesterday, I was on a phone call with a disappointed SAS user who won't be attending SAS Global Forum 2014. Like many others, her organization is facing another year of reduced travel and conference budgets. While there's no substitute for attending in person, live webcasts from SAS Global Forum make
We can watch games on TV, rent a movie from Redbox, and Google our favorite SAS procedures when we’ve forgotten how something works. There are a myriad of ways to get entertained or educated in a second-hand way. But, whether it’s being at the ballpark, in a theater, or at
SAS Global Forum starts for me in the fall of the prior year. This is when you submit your ideas for papers and then wait patiently for many months to learn if it was selected. I enjoy writing and presenting ideas, so here are my topics and what inspired them.
My teenage daughter is a self-appointed anglophile. She's a big fan of British movies and TV shows such as Doctor Who and Sherlock, and although she has not yet visited the UK (an injustice for which she blames her father), she considers the place to be her homeland. In an
It's true: you can use the Microsoft Visual Studio Express tools to build custom tasks for SAS Enterprise Guide and the SAS Add-In for Microsoft Office. And I said as much in my book, Custom Tasks for SAS Enterprise Guide Using Microsoft .NET. I even provided step-by-step instructions for how
In my previous post, I outlined the main components needed for a phased approach to MDM. Now, let's talk about some of the other issues around approaching MDM: data governance and the move to enterprise MDM. Where does governance come in? Throughout your MDM program, it's important that deep expertise
As we near the heights of this festive holiday season, children have thoughts of sugar plums dancing in their heads and adults look forward to a long winter’s nap, but we elves of the SAS media relations team reflect on the fruits of a year’s worth of labor. This is
Being so close before Christmas I thought it would be a good idea to see what route Santa Claus is planning this year. Not just because I'm living in Australia and Santa usually comes in t-shirts & shorts but also because it's a long way to get down here. So
Richard Zink’s desire to win strategy board games like Axis and Allies and Fortress America in college got him started on the path to a career in statistics. “I wanted to better understand the rules of probability to make me a better player,” recalled Zink, a Principal Research Statistician Developer in
Instituting an analytics program in which actionable insight is delivered to a business consumer will be successful if those consumers are aware of what they need to do to improve their processes and reap the benefits. As we have explored over the past few posts, success in the use of
The holiday season is here, and you're probably wondering how to shop for that picky SAS Enterprise Guide user on your gift list. I've got a few ideas for you, and the price is right! Here are links to 11 custom tasks that are free to download, easy to install,
Wow did the summer fly by! Now that grad school is over, it’s about time to resume the “it’s all about the data” series. In the last several posts, I tried to lay a foundation for understanding how SAS stores and manages data for use in business intelligence and analytic
I was looking at someone else's SAS/IML program when I saw this line of code: y = sqrt(x<>0); The statement uses the element maximum operator (<>) in the SAS/IML language to make sure that negative value are never passed to the square root function. This little trick is a real
With Data Stewards Day fast approaching I started to reminisce about the many data stewards I’ve had the pleasure of working with in the past. What struck me was just how many people take on the role of data steward - but under the guise of conventional roles. For example,
Typically, business success results from a series of decisions and strategies that continue to move the business forward and build on past successes. Choosing SAS 9.4 helps you build on past success and supports your strategy for the future. How? I'll give you four reasons, from four perspectives. SAS 9.4: Simplifies
A couple of years ago I shared a method for copying any file within a SAS program. It was a simple approach, copying the file byte-by-byte from one fileref (SAS file reference) to another. My colleague Bruno Müller, a SAS trainer in Switzerland, has since provided a much more robust
SAS 9 has supported calling R from the SAS/IML language since 2009. The interface to R is part of the SAS/IML language. However, there have been so many versions of SAS and R since 2009, that it is hard to remember which SAS release supports which versions of R. The
This week's SAS tip is from Kevin D. Smith and his new book PROC TEMPLATE Made Easy: A Guide for SAS Users. Kevin is a software developer at SAS with extensive experience supporting PROC TEMPLATE and underlying ODS technologies. We're excited that Kevin decided to write his book and hope
If you're a software developer, you're probably already familiar with these terms: I18N and L10N. Internationalization (I + 18 letters + N = I18N) The discipline of preparing your software to run correctly in different languages with different culture settings. For example, the software must be able to accommodate multibyte
Previously I've described how you can use SAS Enterprise Guide to send an e-mail message using Gmail as your e-mail provider. In the article, I mentioned that you can also write SAS programs that send e-mail messages, but at the time you could not reach Gmail using the FILENAME EMAIL
The DELETE procedure is probably the most well-known and most-used SAS procedure that isn't actually documented or officially supported. That is, that was the case before the release of SAS 9.4, when PROC DELETE returns with more features than ever -- including a production-quality status. In his SAS Global Forum
Every programmer may dread the thought of a colleague peeking over his or her shoulder, double-checking code, but SAS Global Forum paper winner David Scocca has offered his tips for making code reviews a painless process. His paper, Communicating Standards: A Code Review Experience, is a must-read. Here’s a peek
John Heaton is no stranger to the often frustrating process of migrating code between environments after software updates. While release management and version control may often be afterthoughts, Heaton cautions that ignoring them could be “time consuming and disastrous should errors occur.” His winning SAS Global Forum paper SAS® Release
At SAS, one of our core values is to be swift and agile. So it makes sense that our software development be Agile too. The Agile methodology has been around for more than 10 years and was designed with software development in mind. Today, it is still used predominately for
As we have seen my previous post "Seeing SAS data through metadata", there is a fundamental difference between accessing a SAS library using a physical reference or a metadata reference to that library. By now, you should now be an expert on the nuances of physical references to SAS data
