A colleague asked, "How can I enumerate the levels of a categorical classification variable in SAS/IML software?" The variable was a character variable with n observations, but he wanted the following: A "look-up table" that contains the k (unique) levels of the variable. A vector with n elements that contains
Sometime very recently, probably while you weren't looking, I changed jobs at SAS (yes, again). This time it's a bigger change for me, because I'm no longer part of the SAS R&D organization, where I've worked for nearly 14 years. Instead, I'm part of the team known internally as Professional
One of the astonishing benefits of my job is getting to travel to beautiful places around the world to meet with customers and prospective customers at The Premier Business Leadership Series conferences. This year is no exception, the historical city of Antwerp as our backdrop, where hundreds have gathered to
Now that the flurry of SAS Global Forum 2011 in Las Vegas has died down, you can take a little time to catch up on some of the reading you said you'd get to. For instance, have you worked your way through the proceedings? They are located here. And I
My primary purpose in writing The DO Loop blog is to share what I know about statistical programming in general and about SAS programming in particular. But I also write the blog for various personal reasons, including the enjoyment of writing. The other day I encountered a concept on Ajay
No, BONEZONE is not the website of wayward legislators. It is, however, a trade journal of the orthopaedic devices industry, and the Summer 2011 issue features a nice mention of Forecast Value Added (FVA) analysis in an article by Tom Wallace. In "Forecasting: It's Getting Better," Tom refers to FVA
Policing has profoundly changed over the last several decades and its evolution will continue as long as there are crimes to commit and communities to serve. The very nature of policing is dynamic – it always has been and always will be. Those dynamics are driven by many things –
Over at the SAS/IML Discussion Forum, there have been several posts about how to call a Base SAS functions from SAS/IML when the Base SAS function supports a variable number of arguments. It is easy to call a Base SAS function from SAS/IML software when the syntax for the function
Writing efficient SAS/IML programs is very important. One aspect to efficient SAS/IML programming is to avoid unnecessary DO loops. In my book, Statistical Programming with SAS/IML Software, I wrote (p. 80): One way to avoid writing unnecessary loops is to take full advantage of the subscript reduction operators for matrices.
There is nothing the gambler, investor, forecaster, or Match.com dater likes as much as the sure thing. Don't we all? Back in April I stated what I claimed to be a sure thing forecast: In any group of 2 or more people, there is at least one pair of people
In a previous blog post, I presented a short SAS/IML function module that implements the trapezoidal rule. The trapezoidal rule is a numerical integration scheme that gives the integral of a piecewise linear function that passes through a given set of points. This article demonstrates an application of using the
In a previous article I discussed the situation where you have a sequence of (x,y) points and you want to find the area under the curve that is defined by those points. I pointed out that usually you need to use statistical modeling before it makes sense to compute the
While school is out (for most) for the summer, many will find this week's SAS Author's tip to be a good primer or refresher about the WHERE statement. Our featured author Sandra Schlotzhauer draws on her extensive career teaching basic statistics to non-statisticians in sharing lessons for grown-ups in her
As organizations confront the limits of forecasting, they finally realize the folly in a blind pursuit of unachievable levels of forecast accuracy. The best accuracy we can ever hope to achieve is limited by the nature -- the forecastability -- of what we are trying to forecast. Anything better than
I was under the impression that Black Swans were supposed to be rare. Rare enough to be effectively non-computable by standard methods. Nassim Taleb’s formulation of the Black Swan Theory is comprised of the three traits of: outlier (rarity), extreme impact, and retrospective predictability (i.e. 20/20 hindsight). I write this
The other day I was asked, "Given a set of points, what is the area under the curve defined by those points?" As stated, the problem is not well defined. The problem is that "the curve defined by those points" doesn't have a precise meaning. However, after gathering more information,
Are you a SAS Enterprise Guide user? If so, you are in luck. SAS Press author Neil Constable provides the inspiration for this week's SAS Author's tip. And this book is more than just a pretty face (the cover photographs very nicely). You'll find rich content from beginning to end.
SAS Enterprise Guide has about 150 options that you can customize in the Tools->Options window. With each release, the development team adds a few more options that have been asked for by customers, and they rarely decommission any existing options. It's getting quite crowded on some of those options windows!
Recently I had to compute the trace of a product of square matrices. That is, I had two large nxn matrices, A and B, and I needed to compute the quantity trace(A*B). Furthermore, I was going to compute this quantity thousands of times for various A and B as part
SAS is the underwriter of a MeriTalk study released today that focuses on “The Federal Efficiency Opportunity”. The study uncovered meaningful insights into how federal managers and professionals are trying to meet their goals while facing enormous budget cuts. The study was done after President Obama’s Deficit Commission suggested in
The basic big data problem is simple to understand: we create too much data to store and analyze it all. The problem gets bigger, however, when you consider the related factors: our problems themselves are getting bigger, the analytics needed to solve them are more complex and the data is
Did you know that you can display a list of all the SAS/IML variables (matrices) that are defined in the current session? The SHOW statement performs this useful task. For example, the following statements define three matrices: proc iml; fruit = {"apple", "banana", "pear"}; k = 1:3; x = j(1E5,
This week's featured book comes from author A. John Bailer. We published John's book last summer and it continues to be one of our most popular titles. Following the tip below, you may want to visit John's SAS Talks on-demand webinar for some free training! The following excerpt is from
Have you ever wanted to look like George Clooney and get all the money, fame, and dates? I have long aspired to this. But in the great poker hand of life, I wasn't dealt an inside straight or even a nice pair. So I make do with what I've got.
As I write my first blog entry for SAS State and Local Government, I thought it would be prudent to provide a little personal background. I grew up in a family of artists- with 5 musicians, 2 painters, 1 sculptor, 1 dancer, and 1 composer. I studied business, became a
Many people know that the SGPLOT procedure in SAS 9.2 can create a large number of interesting graphs. Some people also know how to create a panel of graphs (all of the same type) by using the SGPANEL procedure. But did you know that you can also create a panel
I’m an avid reader and was not happy when ebook prices went from $3-4 to $9-12. However, being in publishing at SAS, I realize a book is priced based on its value and not the format. Shifting the cost from paper to digital is not as easy as you might
I hope that the following statement is not too controversial...but here it goes: Microsoft Excel is not a database system. That is, I know that people do use it as a database, but it's not an application that supports the rigor and discipline of managing data in the same way
As editor of the SAS Business Report, I constantly analyze what’s “clicking” for readers and what’s not. So far in 2011, the following articles have been the biggest hitters: Advanced Analytics for the Modern Business Analyst SAS Placed in Leaders Quadrant for BI Top Five Big Ideas in Analytical Data
This article shows how to randomly access data in a SAS data set by using the READ POINT statement in SAS/IML software. I have previously discussed how to use the READ NEXT and READ CURRENT statements to sequentially access each observation in a SAS data set from PROC IML. Reading
