A Bar Line graph is commonly used in many domains. The SGPLOT procedure makes it easy to create bar line graphs where the user can customize it in many different ways. This post is prompted by a recent question on the communities page on creating such a graph, with one bar and
Most of us can probably recite the age-old recommendation to "drink eight 8-ounce cups of water every day" in our sleep. However, how many of us actually do it? We are often quick to replace our water bottles with sugar-sweetened beverages, coffee, or tea while telling ourselves, "it’s mostly water,
Everyone may find bad dates in their data set from time to time, but it’s often difficult to tell if they’re mere annoyances or indicative of a larger problem. Luckily, Lucheng Shao has come to the rescue in his SAS Global Forum winning paper, Don’t Let a Bad Date Ruin
A regular reader noticed my post on initializing vectors by using repetition factors and asked whether that technique would be useful to expand data that are given in value-frequency pairs. The short answer is "no." Repetition factors are useful for defining (static) matrix literals. However, if you want to expand
Imagine a business offering a multitude of products and services that seemingly have little relationship to one another, and all are supported by different data systems. This is the plight of local governments. The products and services produced and managed by local governments range from utilities, solid waste and recycling to parks
This week's SAS tip is from Art Carpenter and his latest book Carpenter's Guide to Innovative SAS Techniques. Art is a talented SAS user and prolific author--and was just recognized in the SAS Circle of Excellence for 30 years of using SAS software. After taking a look at this week's book
Like most SAS users and administrators, you usually don't know where your backend SAS servers are located--probably in some basement server farm or perhaps another building or even another town. But I'm sure you do know that your SAS client application must have a way to reach services running on
If you've watched any of the demos for SAS Visual Analytics (or even tried it yourself!), you have probably seen this nifty exploration of multiple measures. It's a way to look at how multiple measures are correlated with one another, using a diagonal heat map chart. The "stronger" the color
The MidWest SAS Users Group (MWSUG) 2013 call for papers closes on June 15. If you’ve submitted a paper or have been thinking about it, why not sign up for the MWSUG Presenter Mentoring Program? Students, first-time paper or poster presenters or anyone who wants guidance with abstract submission, paper
In a previous blog post, I described how to use a spread plot to compare the distributions of several variables. Each spread plot is a graph of centered data values plotted against the estimated cumulative probability. Thus, spread plots are similar to a (rotated) plot of the empirical cumulative distribution
First of all, congratulations to everyone who presented at SAS Global Forum 2013. Your hard work and contributions are what make it a success each year. Even though SAS Global Forum 2013 has come and gone, all of the papers and presentations are still available online. Out of this fantastic
Suppose that you have several data distributions that you want to compare. Questions you might ask include "Which variable has the largest spread?" and "Which variables exhibit skewness?" More generally, you might be interested in visualizing how the distribution of one variable differs from the distribution of other variables. The
As part of my follow-up to SAS Global Forum 2013, I've posted a few articles about how to create your own client apps with SAS Integration Technologies. This article shows how to use Microsoft .NET -- the same approach used for SAS Enterprise Guide and SAS Add-In for Microsoft Office
This week's SAS tip is from Michele Burlew and her book SAS Macro Programming Made Easy, Second Edition. Michele is the author of several extremely helpful SAS books. Visit her author page to learn more about her work and for additional free content. The following excerpt is from SAS Press
John Heaton is no stranger to the often frustrating process of migrating code between environments after software updates. While release management and version control may often be afterthoughts, Heaton cautions that ignoring them could be “time consuming and disastrous should errors occur.” His winning SAS Global Forum paper SAS® Release
Last week I showed how to use simulation to estimate the power of a statistical test. I used the two-sample t test to illustrate the technique. In my example, the difference between the means of two groups was 1.2, and the simulation estimated a probability of 0.72 that the t
One of the great things about SAS libraries is that you can write your programs to read and write data without having to worry about where the data lives. SAS data set on a file system? Oracle table in a database server? Hadoop data in Hive? For many SAS applications,
A SAS user told me that he computed a vector of values in the SAS/IML language and wanted to use those values on a statement in a SAS procedure. The particular application involved wanting to use the values on the ESTIMATE and CONTRAST statements in a SAS regression procedure, but
They say "Imitation is the most sincere form of flattery"... Therefore when I imitate Hans Rosling's famous world-data animation, it's not that I'm jealous, but that I'm paying homage to him! (OK, and maybe also a little bit jealous! LOL) Well, anyway, for those of you who haven't seen it,
Reading Jan Bigalke’s SAS Global Forum paper on “Hardening a SAS® Installation on a multi tier installation on Linux" reminded me of baking apple stack cake with my mother. Neither is a simple project. Both are time-consuming, and their success depends on how skillfully you handle each layer. Data security
The power of a statistical test measures the test's ability to detect a specific alternate hypothesis. For example, educational researchers might want to compare the mean scores of boys and girls on a standardized test. They plan to use the well-known two-sample t test. The null hypothesis is that the
If you write a blog, you deal with spam comments. That's just part of the deal. Spammers are forever inventing new and creative methods for "tricking" you into accepting their spam comments. These comments have nothing to do with your blog topic but do contain trackback links to their own
Has anyone noticed that the REG procedure in SAS/STAT 12.1 produces heat maps instead of scatter plots for fit plots and residual plots when the regression involves more than 5,000 observations? I wasn't aware of the change until a colleague informed me, although the change is discussed in the "Details"
At SAS, one of our core values is to be swift and agile. So it makes sense that our software development be Agile too. The Agile methodology has been around for more than 10 years and was designed with software development in mind. Today, it is still used predominately for
In my article "Simulation in SAS: The slow way or the BY way," I showed how to use BY-group processing rather than a macro loop in order to efficiently analyze simulated data with SAS. In the example, I analyzed the simulated data by using PROC MEANS, and I use the
Often we want to visualize the relationship between variables over time. The understanding of such data can be improved by viewing the animated graph over time. With SAS 9.4, you can create animated graphs using the new animation options on the OPTIONS statement and the PRINTER destination. A popular example an
I recently read an interesting article in The Economist, where they describe "The Big Mac index." This is an index they invented as a lighthearted guide to compare currencies in different countries. In their article they create a multi-panel display (similar to a dashboard) where they compare the index for several countries using
A good chunk of the SAS year revolves around SAS Global Forum. Pre-conference, everyone is busy polishing presentations and planning meetings. Post-conference is the best—attendees come back to Cary with heads full of customer ideas to implement and notebooks full of contacts to follow up on. One user's request found its
Humans have over 10,000 taste buds which are made up of hundreds of receptor cells that control our sense of taste. Each type of receptor responds to one of these 5 basic tastes: Sweet: activated by presence of sugars (ie: fruit, sugary drinks, desserts) Salty: activated by presence sodium chloride
Last week I discussed a program that had three nested loops that used scalar operations in the innermost loop. I mentioned that this program was not vectorized, and would therefore be slow in a matrix language such as SAS/IML, MATLAB, or R. I then went through a series of steps
