Planning for SAS Global Forum 2013 is well underway and it’s time you get involved through the Call for Papers! As the 2013 SAS Global Forum conference chair, I cannot emphasize enough how much we rely on your creative tips and tricks to contribute to the invaluable content provided at
I needed to construct a string to use in the title of a scatter plot. The scatter plot showed a line, and I wanted to include the equation of the line in the plot's title. This article shows how to construct a string that contains the equation in a readable
A few weeks ago I wrote an article on using the non breaking space character to prevent stripping of leading and trailing blanks in a string. Since then, I have discovered a few more instances where the nbsp can be a useful tool for creating graphs. One such instance came up last week
It’s that time of year again! The leaves are turning, the days are getting shorter, and all across the country, SAS users are getting ready for the annual users group conferences. To get people excited about the upcoming events, I’ll be hitting the road—metaphorically, at least—and virtually visiting each of
One of the often-cited side effects of moving from "Base SAS" (SAS on your PC, or Display Manager) to SAS Enterprise Guide is the loss of "X" command privileges -- that is, the ability for your SAS programs to invoke other programs via the operating system shell. We call this
A super hot topic in most organizations is how to make the most of the troves of social data available. This Post-It Note author isn't specific about the SAS solution that is being used, so I'm going to speculate that he or she is taking advantage of SAS Text Miner, SAS Text
I follow Andrew Ratcliff's NOTE: blog, and thought you might want to check out his latest post. I've reprinted it below (you'll notice that I'm a bit behind the times): NOTE: SGF Call for Papers 2013 Opens Tomorrow #sasgf13 The Call for Papers for next year's SAS Global Forum (SGF) opens
Magic squares are cool. Algorithms that create magic squares are even cooler. You probably remember magic squares from your childhood: they are n x n matrices that contain the numbers 1,2,...,n2 and for which the row sum, column sum, and the sum of both diagonals are the same value. There are many
“Ohio links teacher pay to test scores” was the headline of a recent CNN School of Thought blog. Yikes! With a headline like that, teachers might start heading for the hills. I kept reading through the blog hoping that it would better explain Ohio’s policy to use student growth data
When I studied math in school, I learned that the expression a (mod n) is always an integer between 0 and q – 1 for integer values of a and q. It's a nice convention, but SAS and many other computer languages allow the result to be negative if a (or q) is
Pie charts have been the subject of some criticism when they are used to compare measures across multiple categories. It is generally accepted that comparison of magnitudes represented as angular measures from varying baselines is not effective. However here are some use cases where a pie chart does quite well. When it comes
It's always great to hear that SAS users get to thump their chests a bit around statisticians and programmers who are struggling because they are trying to solve problems using software provided by those "other" companies. Now, that's inspiring.
As a trainer for SAS Education Australia and chairperson of the local SAS User Group, QUEST (Queensland Users Exploring SAS Technology) , I meet many new SAS users over the years. In July 2011, I met Kim MacKenzie, a lecturer at Queensland University of Technology (QUT), Brisbane, Australia at an Enterprise
Regular expressions provide a powerful method to find patterns in a string of text. However, the syntax for regular expressions is somewhat cryptic and difficult to devise. This is why, by my reckoning, approximately 97% of the regular expressions used in code today were copied and pasted from somewhere else.
The other day I was using PROC SGPLOT to create a box plot and I ran a program that was similar to the following: proc sgplot data=sashelp.cars; title "Box Plot: Category = Origin"; vbox Horsepower / category=origin; run; An hour or so later I had a need for another box
Facebook has millions of users, and therefore when people share an interesting graph on Facebook it can "go viral" and millions of people might see it. Some of the graphs are obviously a bit biased - especially ones that are trying to sway your opinion one way or another on a topic
The next meeting of the Toronto Area SAS Society (TASS) will be at 8:30 am, Friday September 14th, 2012, at SAS Canada (280 King Street East, Toronto, Ontario). The meeting is really two meetings in one
The SAS/IML language supports user-defined functions (also called modules). Many SAS/IML programmers know that you can use the RETURN function to return a value from a user-defined function. For example, the following function returns the sum of each column of matrix: proc iml; start ColSum(M); return( M[+, ] ); /*
The Scatter Plot Matrix is a great tool that provides a quick visual of potential associations between variables. This may provide the analyst some hints on how to proceed with the analysis. Matrix of lab values for liver function tests are commonly used in clinical research. The SGSCATTER procedure provides an easy way
It is common to want to extract the lower or upper triangular elements of a matrix. For example, if you have a correlation matrix, the lower triangular elements are the nontrivial correlations between variables in your data. As I've written before, you can use the VECH function to extract the
Every summer, SAS hires interns from colleges across the US. Now, I've worked at other organizations, and I've worked with interns before. These guys are brilliant - the rising stars of industry. This year, one of the summer interns is Dylan Sweetwood. He'll be returning to Stanford in the fall,
The project that I'm currently working on requires several input data tables, and those tables must have a specific schema. That is, each input table must contain columns of a specific name, type, and length in order for the rest of the system to function correctly. The schema requirements aren't
Recently, there has been lot of uproar and confusion about the Supreme Court ruling on the constitutionality of the Affordable Care Act. Many were surprised by the ruling, and others, while happy it was upheld, are concerned about the constitutional questions that arose due to the way the ruling was
I'm working on a SAS programming project with a large team. Each team member is responsible for a piece of the overall system, and the "contract" for how it all fits together is The Data. For example, I've got a piece that performs some data manipulation and produces several output
Sometimes a small option can make a big difference. Last week I thought to myself, "I wish there were an option that prevents variable labels from appearing in a table or graph." Well, it turns out that there is! I was using PROC MEANS to display some summary statistics, and
Forest plots come in many flavors. An example of a Forest plot using GTL is available on the SAS support web site. Simple forest plots can also be created using SGPLOT procedure by using the SCATTER statement with MARKERCHAR to display data aligned with the plot by study names. One issue
Do you use SAS for analytics and Microsoft Excel for graphs? Why not use SAS for your graphs too?!? Then you could completely automate the entire process in one SAS program, with no manual steps! A lot of people use Excel to create their graphs because "it's what they know." What if somebody
This Post-It Note reminds me of a presentation at SAS Global Forum 2012 about automating reports. Of course, these Post-It Notes always remind me of presentations. This week, instead of pointing you to a bunch of past presentations, I'm going to challenge you to use this note as an idea
Unbelievable: It's already August. When I was a child, my mother used to talk about how time flies when you become an adult, and that I shouldn't wish my life away by always wanting to be older than my years or longing for something that was just beyond my maturity
I've seen analyses of Fisher's iris data so often that sometimes I feel like I can smell the flowers' scent. However, yesterday I stumbled upon an analysis that I hadn't seen before. The typical analysis is shown in the documentation for the CANDISC procedure in the SAS/STAT documentation. A (canonical)
