About once a month, a customer approaches SAS and asks a question of significance. By "significance", I don't necessarily mean "of great importance", but instead I mean "of how SAS handles large numbers, or floating-point values with many significant digits". In response, we always first ask why they asked. This
In the previous post, “Roses are red, violets are blue…”, I discussed the general problem of getting style attributes to line up with specific group values and some ways to overcome the problem. In this installment, I want to elaborate on the attribute map functionality in the Graph Template Language
Sometimes in matrix computations you need to obtain the values of certain submatrices such as the diagonal elements or the super- or subdiagonal elements. About a year ago, I showed one way to do that: convert subscripts to indices and vice-versa. However, a tip from @RLangTip on Twitter got me
This question came up while helping my presales colleague with a client’s question: “Is Microsoft Excel in direct competition with SAS?” Not really. I like to think of SAS as partnering with Excel. Because of the following Excel benefits and its synergy with SAS. Excel has been around for years.
Usually when you hear the expression "That's gonna leave a mark!", it's a bad thing! ... But, in this case, it's actually good! Since many of you SAS Global Forum attendees and/or your family members might be visiting the Disney park, I thought it would be fun to use SAS/GRAPH®
I recently saw a SAS Knowledge Base article called "How to stop processing your code if a certain condition is met." The article discusses the use of the %RETURN macro statement to abort the execution of a SAS program if some condition occurs. The "condition" is usually an error that
This classic start to a romantic poem assumes that the correct colors are always assigned to the correct flowers; but, for those who create graphs for reports, consistent color assignment can be more of a challenge than an assumption. This challenge is particularly true for the display of group values.
How are you determining customer satisfaction? How do you move the needle? This SAS user mines the unstructured data in patient surveys with SAS Text Miner.
Here is the promised follow up on the Dashboard graph. In the previous article, I posted the code to create a panel of bullet KPIs displaying three different metrics. For each KPI, I used 5 columns of data which resulted in a wide and inconvenient structure. A more convenient data structure is
Do you want your report to look good on the web, or to look good when you print it? Pick one. Before the SAS Report file format, that was the choice that you faced. HTML is perfect for the web browser. It's easy to scroll through tables, to apply an
Unlike BASE SAS tables, OLAP cubes must exist in within the metadata in order to access from any of the OLAP Viewers. In addition to having some metadata OLAP cubes have a physical file structure presence (at least for MOLAP/HOLAP because it's a different story for ROLAP). When you refresh
TO: SAS Global Users Group FROM: Chair, Nominations Committee of the SAS Global Users Group Executive Board SUBJECT: Conference Chair SAS Global Forum 2015
I recently blogged about Mahalanobis distance and what it means geometrically. I also previously showed how Mahalanobis distance can be used to compute outliers in multivariate data. But how do you compute Mahalanobis distance in SAS? Computing Mahalanobis distance with built-in SAS procedures and functions There are several ways to
The smallest aircraft I’ve ever flown on was the one I took from Raleigh to Hilton Head, South Carolina to attend my first PharmaSUG – the Pharmaceutical Industry SAS Users Group. That was in 1997, and it’s been my pleasure to work with this great group of volunteer SAS leaders
Teachers have more than enough to juggle each day, lacking the time to search for, and find, high-quality curricular resources online. When I would search for lesson plan supplements, I would often get lost in Google's abyss of results, spending far too much precious time sifting through mediocre materials. Until
What're you wearing? I get that question all of the time …. OK, let me re-phrase that. In regards to events, I am often asked, “What are you going to wear?” It’s always hard to answer as the standard for events, including SAS Global Forum, is business casual.
The SAS DATA step supports a special syntax for determining whether a value is contained in an interval: y = (-2 < x < 2); This expression creates an indicator variable with the value 1 if x is in the interval (-2,2) and 0 otherwise. There is not a standard
In this blog we have been discussing graphs useful for analysis of data for many domains such as clinical research, forecasting and more. SG Procedures and GTL are particularly suited for these use cases. So, when I came upon a dashboard image from Steven Few's Visual Business Intelligence blog, showing the
When I read the way that this user is working with SAS, I took a look around support.sas.com to find examples to allow you to work with your own data. (Take a look at this.) If this example isn't quite right for you, plug in your own key words.
I have previously blogged about how to convert a covariance matrix into a correlation matrix in SAS (and the other way around). However, I still get questions about it, perhaps because my previous post demonstrated more than one way to accomplish each transformation. To eliminate all confusion, the following SAS/IML
The graph showing the distribution of the maximum liver function test values by treatment for all participants in a study is commonly used for the analysis of safety data in clinical trials. The data is often structured in multiple columns (one per treatment) as below on the left, or grouped by
I previously described how to use Mahalanobis distance to find outliers in multivariate data. This article takes a closer look at Mahalanobis distance. A subsequent article will describe how you can compute Mahalanobis distance. Distance in standard units In statistics, we sometimes measure "nearness" or "farness" in terms of the
Do you love SAS? I do! And there is a special place for me to share that love. Don't worry there is a special place for you, too. It just so happens that it is the same place – SAS users groups. SAS users groups hold events to allow attendees
So, there’s a lot of talk about staying for the magic of Disney World after SAS Global Forum. What about arriving early for some SAS magic? A selection of some of the most popular SAS training courses is being offered Wednesday – Friday, April 18-20 prior to the conference. Here’s
How we love shortcuts. Our life seems more efficient with them. I try to take the earlier train for a good parking spot that lets me exit early. Actually change that to any spot (my train station has tons of commuters with FEW parking spaces so getting up early is the
The Walt Disney World Swan and Dolphin Resort (the headquarters hotel) is offering a great rate to SAS Global Forum attendees. This amazing facility is where all of the action is. No cars to rent, no gas tanks to fill. No parking to find and pay for – which means no searching
Way back when I learned to program, I remember a computer instructor explaining that an IF-THEN statement can be a relatively slow operation. He said "If a multiplication takes one unit of time, an IF statement requires about 70 units." I don't know where his numbers came from, or even
The parable of beer and diapers is often related when teaching data mining techniques. Whether fact or fiction, a Heat Map is useful to view the claimed associations. A co-worker recently enquired about possible ways to display associations or dependency between variables. One option is to show the dependency as a node
I have a love-hate relationship with spreadsheet data. I am interested in finding data to analyze, and if it arrives in the form of a spreadsheet, I'll take it. And I like to deliver results and reports, but often my constituents ask for it as a spreadsheet that they can
Big data is one of the hottest topics in business. When you hear those words - BIG Data - you almost surely think of: HUGE financial services firms scoring terabytes of historical and current risk data GLOBAL telecommunications companies mining petabytes of structured and unstructured data INTERNATIONAL retailers repricing hundreds of thousands of products across
