I recently read a blog post in which a SAS user had to rename a bunch of variables named A1, A2,..., A10, such as are contained in the following data set: /* generate data with variables A1-A10 */ data A; array A[10] A1-A10 (1); do i = 1 to 10;
In the previous post on Broken Y-Axis, I reviewed different ways to display data as a Bar Chart, where the response values for some categories are many orders of magnitude larger than the other values. These tall bars force the display of other values to be squeezed down thus making it harder to compare
If you live anywhere in the Midwestern United States (you know who I'm talking about, those of you in the 12 states in the map to the right), you must be breathing a sigh of relief right about now. Why? Because the MWSUG (MidWest SAS Users Group) Call for Papers deadline
One of the coolest things that I saw at SAS Global Forum was Dr. Goodnight dissecting a hologram of a SAS high-performance server and describing how the technology works with analytics. This is the height of innovation. You have got to watch this! Here are a few great
Often we want to display data as a bar chart where a few observations have large values compared to the rest. Comparison between the smaller values becomes hard as the small bars are squeezed by the tall bars. Here is an example data, and a bar chart showing the data. The large values
In the summer of 2010, the LA Times made national waves by publishing Los Angeles Unified School District’s teacher names and value-added estimates. The New York Times followed suit in February, 2012, ranking New York City’s teachers based on their value-added ratings. While these bold actions may satisfy some parents
In the SAS/IML language, a user-defined function or subroutine is called a module. Modules are used to extend the capability of the SAS/IML language. In my blog posts, I usually define a module in a PROC IML session and then immediately use it. However, sometimes it is useful to store
I am part of a 'virtual team from SAS Technical Support' who provide the suggestions for the Tips & Techiques section for the SAS Tech Report each month. A couple of days ago, Bill Gibson, Chief Technology Officer from SAS Australia, sent us an email saying that like him, many
We're at stop #3 on the crash analytics highway. We've introduced the topic of the Four E's and have discussed the role of analytics in Enforcement. Now let's talk about Engineering. Safety, reliability and accessibility are all key components in road design. Traffic engineers work to make the driving environment
In the SAS/IML language, a user-defined function or subroutine is called a module. Modules are used to extend the capability of the SAS/IML language. Usually you need to explicitly load modules before you use them, but there are two cases where PROC IML loads a module automatically. Modules in IMLMLIB
Recently, I came across an interesting graph showing Euro contries bank exposuro to GIIPS countries, as percent of GNP. Here is the graph: I thought I would see how far I can get in making a similar graph using SAS. I made up some data with response values for a Product x
I found this great video on AllAnalytics.com. It was shot while you guys were at SAS Global Forum and has soooo many great SAS users talking about the reasons that you love to go to SAS Global Forum. Take a look: Now that you have heard their reasons, tell me
Put up or shut up is one of those great sayings from my generation. Loosely translated it means, stop complaining if you aren't going to do something about the problem. In this week's Innovation Inspiration, the author decided to teach American middle schoolers how to question the information that they
This post is a result of an intriguing question posed by a user on the SAS communities' page. How to create a bar chart where the category is a combination of two variables var_1 and var_2 (each with values of '+' and '-'), and get a X axis that shows each
If you missed PharmaSUG - as I did - you still like to stay on top of the great information that comes out of the conference. I found the list of Best Contributed Papers and decided to post them here for you. There is a lot of other great information
Back in 2009, I announced that SAS was developing a version of its business analytics platform for use on the Nintendo Wii. I think I gave our legal department a heart attack with this news, until they realized that I had posted it on April 1. At SAS Global Forum
If you're looking for some good stuff to read ... I mean great stuff for SAS users, I've had this list brewing in my head for a few weeks now. (The reason that I ask is because in the US, this weekend will be a three-day holiday to commemorate Memorial Day. So, many families will
In a previous blog, I showed how to use SAS/IML subscript reduction operators to compute the location of the maximum values for each row of a matrix. The subscript reduction operators are useful for computing simple statistics for each row (or column) of a numerical matrix. If x is a
On the SAS-L mailing list, a participant posed this question (paraphrased): How can I tell which date format my Windows session is using: European format (with day first) versus USA format (with month first)? I'm reading in output from a Windows file listing, and need to know how to interpret
In August 2011, we expanded the scope of the SAS Global Forum blog and rebranded it as the SAS Users Group blog. Our goal was to create one vibrant and dynamic spot for content related to SAS users groups and SAS user presentations. The result has been terrific! Many new
The other day I encountered an article in the SAS Knowledge Base that shows how to write a macro that "returns the variable name that contains the maximum or minimum value across an observation." Some people might say that the macro is "clever." I say it is complicated. This is
At SAS Global Forum, and again at PharmaSUG, we had the pleasure of attending many papers and presentations on various topics that included graphs in the power point decks or in the papers. More often than not, the graphs exist along other text, and occupy a smaller part of the screen
It's Friday, and on SAS Voices they are posting fun stuff about dogs who work at SAS. I'm posting about PROC SQL and MySQL. You tell me - which of us knows how to ring in the weekend with style? I've been working with MySQL data sources lately, and SAS/ACCESS
At SAS Global Forum, one of the most difficult areas for me to show to you are the poster presentations. This year, I asked Steve Polilli, a colleague who is great with a Flipcam, to video a few for me. I picked out three that I will use in the
Here is the last video from the last day at SAS Global Forum 2012. This one is great! Make sure you stay in there long enough to watch the outtakes: they are so funny!
PharmaSUG 2012 conference drew to a close today, concluding two and a half days packed with papers, presentations, posters, hands-on demos and super demos by SAS staff. While the weather outside was a bit chilly from time to time, the conference what hopping with many user papers on how to
Annette Harris spends several minutes during this video extolling many of the high-performance virtues of Pete Lund, Information Systems Manager, Looking Glass Analytics. One thing she didn't mention (it was mentioned to me later) is that Pete is a long-time member of SAS-L. Do you know how many other SAS
I've been a fan of statistical simulation and other kinds of computer experimentation for many years. For me, simulation is a good way to understand how the world of statistics works, and to formulate and test conjectures. Last week, while investigating the efficiency of the power method for finding dominant
SAS users, by definition, do not embrace the mysterious. That's one of the main reasons that they use SAS: to demystify some data or process. And so, when you (as a SAS user) have gone to the trouble of designing a process flow in SAS Enterprise Guide, you like to
As a SAS fan, in a number of roles over the past 15+ years (programmer, statistician, data warehouse developer, business analyst, consultant, trainer, partner), I am also the Queensland Users Exploring SAS Technology (QUEST) chairperson, and I feel very privileged to be able to contribute to the wider SAS community
