Andrew Ratcliffe posted a fine article titled "Inadequate Mends" in which he extols the benefits of including the name of a macro on the %MEND statement. That is, if you create a macro function named foo, he recommends that you include the name in two places: %macro foo(x); /** define
A fundamental operation in data analysis is finding data that satisfy some criterion. How many people are older than 85? What are the phone numbers of the voters who are registered Democrats? These questions are examples of locating data with certain properties or characteristics. The SAS DATA step has a
“Our performance last month was 46.” Oh, you don’t have to thank me, I was just doing my job. Not very well, I might add. 46? 46 what? Or 46 who’s? Without context, 46 is just a number, just data. In context, perhaps that’s 46 out of 48 (not too
For years I've been making presentations about SAS/IML software at conferences. Since 2008, I've always mentioned to SAS customers that they can call R from within SAS/IML software. (This feature was introduced in SAS/IML Studio 3.2 and was added to the IML procedure in SAS/IML 9.22.) I also included a
Dear SAS users and excellent blog readers, this week's sort of randomly selected tip comes from esteemed SAS author Art Carpenter. Many of you are probably familiar with Art's work and may have had the pleasure of hearing him speak at a user group conference. He's a great communicator and
When Charlie H. posted an interesting article titled "Top 10 most powerful functions for PROC SQL," there was one item on his list that was unfamiliar: the COALESCE function. (Edit: Charlie's blog no longer exists. The article used to be available at http://www.sasanalysis.com/2011/01/top-10-most-powerful-functions-for-proc.html) Ever since I posted my first response,
Last week the Flowing Data blog published an excellent visualization of the flight patterns of major US airlines. On Friday, I sent the link to Robert Allison, my partner in the 2009 ASA Data Expo, which explored airline data. Robert had written a SAS program for the Expo that plots
Are we oversimplifying customer segmentation and treatment strategies? SAS Marketing Director Jonathan Hornby thinks so. He also believes customer lifetime value should include an understanding of sentiment, influence and the value of collaboration with your customers. In fact, if you're not factoring these items into your customer segmentations, you're probably
It's a simple task to use SAS to compute the number of weekdays between two dates. You can use the INTCK function with the WEEKDAY interval to come up with that number. diff = intck('WEEKDAY', start_date, end_date); If you want to compute the number of working days between two dates,
When I was at the annual SAS Global Forum conference, I had the pleasure of discussing statistical programming and SAS/IML software with dozens of SAS customers. I was asked at least ten times, "How do I get started with SAS/IML software?" or "How can I learn PROC IML?" Here is
This blog post shows how to numerically integrate a one-dimensional function by using the QUAD subroutine in SAS/IML software. The name "quad" is short for quadrature, which means numerical integration. You can use the QUAD subroutine to numerically find the definite integral of a function on a finite, semi-infinite, or
I recently conducted a financial planning exercising to focus on savings – after all, college tuition rates are climbing and by the time my son goes to school in 18 years or so, I may be looking at $60,000 a year for a public university. Now is the time to
A midsize regional health insurer with approximately 3,000 employees across 10 locations in the Western United States created a role for a business continuity manager (BCM) reporting to the chief operating officer. In this organization, the enterprise risk management (ERM) functions, established in 2004, are owned by the chief legal
Dear readers, I’m trying out something new that I hope you’ll like. Once a week, for the next couple of months, I’ll post a short excerpt or tip from one of our books. To make things fun, I’m going to randomly select the book by walking into the SAS Press
More than a month ago I wrote a first article in response to an interesting article by Charlie H. titled Top 10 most powerful functions for PROC SQL. In that article I described SAS/IML equivalents to the MONOTONIC, COUNT, N, FREQ, and NMISS Functions in PROC SQL. In this article,
The Spring 2011 issue of Foresight is now available. Here is Editor Len Tashman's preview: For forecasters, “being wrong” is the expectation; the hope is that we’re not too wrong. But admitting to our failures is never easy. The Spring 2011 issue leads off with Marcus O’Connor’s book review of
SAS Enterprise Guide is best known as an interactive interface to SAS, but did you know that you can use it to run batch-style programs as well? SAS Enterprise Guide has always offered an automation object model, which allows you to use scripting languages (such as VBScript or Windows PowerShell)
At the SAS analyst event in Steamboat, CO, in March, SAS CEO Jim Goodnight shared some interesting stats with attendees: Even in 2010's tough economy, SAS experienced 5.2 percent worldwide growth in US dollars. On top of that, SAS is still building new facilities, still winning workplace awards, and this
The most common way to read observations from a SAS data set into SAS/IML matrices is to read all of the data at once by using the ALL clause in the READ statement. However, the READ statement also has options that do not require holding all of the observations in
The Credit Card Accountability, Responsibility and Disclosure Act (CARD) of 2009 was triggered by the financial crisis and designed to protect subprime borrowers by forcing lenders to provide more transparency and more reasonable, fairer rates and fees to borrowers. This has proven a costly burden for US lenders as they
Congratulations to Curt Hinrichs and Chuck Boiler! Their book, JMP Essentials: An Illustrated Step-by-Step Guide for New Users, has won an Award of Distinguished Technical Communication in this year’s International Summit Awards presented by the Society for Technical Communication. The award goes to a project that “applies the principles of
In last week's article on how to create a funnel plot in SAS, I wrote the following comment: I have not adjusted the control limits for multiple comparisons. I am doing nine comparisons of individual means to the overall mean, but the limits are based on the assumption that I'm
Greg Nelson and Neil Howard presented a lunchtime keynote talk at SAS Global Forum, and they produced this video, "Revenge of the Semi-Colon People", to go along with it. The video features many people from the SAS community, including customers and SAS employees. Watch it and see if you know
The log transformation is one of the most useful transformations in data analysis. It is used as a transformation to normality and as a variance stabilizing transformation. A log transformation is often used as part of exploratory data analysis in order to visualize (and later model) data that ranges over
I've been walking around the last few days with what looks like a dollop of chocolate syrup or grape jelly on my chin. Alas, it is just a bruise from getting elbowed in the mouth at basketball last Thursday night. (Church leagues may be the only dirtier place to play
Director of Business Strategy for the Orlando Magic, Anthony Perez, recently spoke at the SAS Global Forum Executive Conference on how analytics is molding the NBA - both on and off the court. The Orlando Magic is currently one of the top teams in the NBA, and that is no
Walking to work this sign caught my eye. I was moved as I’m sure you will be too – to see the lot of students universally. Like most folks, I’ve played different roles in life. Of them I would say that my part-time student role was the most challenging. My
One of the advantages of programming in the SAS/IML language is its ability to transform data vectors with a single statement. For example, in data analysis, the log and square-root functions are often used to transform data so that the transformed data have approximate normality. The following SAS/IML statements create
When I encounter an ERROR, WARNING, or NOTE in my SAS log that I don't understand, my first recourse is to ask my friend (we'll call him "Google") what it could mean. I copy the entire message (or at least 5 or 6 consecutive words from it) into the search
Last week I showed how to create a funnel plot in SAS. A funnel plot enables you to compare the mean values (or rates, or proportions) of many groups to some other value. The group means are often compared to the overall mean, but they could also be compared to
