Dear Miss SAS Answers, In PROC REPORT can I use one calculated (computed) variable in the calculation of another computed variable? In the example below, I’m trying to use the value of the Bonus column to calculate the Total column: compute Bonus; Bonus =sal.sum*0.05; endcomp; compute Total; total=sum(sal.sum, Bonus.sum); endcomp;
During one week in December, two separate transportation agencies within the federal government made two major announcements. First, the National Highway Traffic Safety Administration (NHTSA) – the government agency responsible for guiding traffic safety initiatives on the nation’s highways announced that crash fatalities had declined to record low rates. Just
For 25 years, winners of sporting events, singing competitions and beauty pageants have been spouting the same response when asked, “What’s next?” Their simple answer - “I’m going to Disney World!” - makes us all jealous.
A recent post on the SAS website shows the SAS Annual Revenue History. It would be interesting to see how we could create such a graph using SG procedures, and how we could add more information and interest in the presentation. So, I started with the basic informaiton on the annual revenues provided,
Without fail, at every social media conference I attend, someone will approach the microphone during the Q&A portion of a presentation and ask the speaker or the panelsts, "How are you measuring influence for your blogger outreach programs?" Or, "How can we replicate what you're doing to decide whether certain
In the R programming language, you can use a negative index in order to exclude an element from a list or a row from a matrix. For example, the syntax x[-1] means "all elements of x except for the first." In general, if v is a vector of indices to
If you live in the US, do you remember the Dunkin Donuts commercial from about 30 years ago. It opens with a devoted donut maker climbing out of bed, saying "It's time to make the donuts." (Donut makers have to get up early so that you and I can have
Following up on the theme of graphs commonly used in many applications, here is another one that displays a horizontal bar chart with multiple data columns aligned with the bars. Recently at WUSS, a user stopped by asking how to create just such a graph. While this user wanted something more complex
Buffon's needle experiment for estimating π is a classical example of using an experiment (or a simulation) to estimate a probability. This example is presented in many books on statistical simulation and is famous enough that Brian Ripley in his book Stochastic Simulation states that the problem is "well known
In the immortal words of Britney Spears: Oops! I did it again. At least, I'm afraid that I did. I think I might have helped a SAS student with a homework assignment, or perhaps provided an answer in preparation for a SAS certification exam. Or maybe it was a legitimate
SAS Publishing is pleased to announce that both the Base and the Advanced SAS Certification Prep Guides are now available as eBooks in the Apple iBookstore. In these guides, you’ll find affordable self-study materials to help you prepare for the SAS® 9 exams. Prepare yourself to achieve certification using your favorite
Happy New Year, everyone! It’s that wonderful time of the year when people start anew and we all start making promises to ourselves about the things we want to accomplish in the year ahead. If you’re looking for some ways to ramp up your personal and professional expertise this year,
Local governments are not immune to the rising demand for more accountability in government run services and programs, and the expenditure of public funds. Elected officials and citizens alike want to know what these programs accomplish for the public investment made. To date, the response to these questions and demands has been
Happy New Year! As we begin 2012, I think we can all agree there is no question that the explosion of digital technology over the past few years has redefined the relationship between vendor and customer. With so much product and vendor information just a click or a tap away,
Let us ring in the new year with something simple and useful. A recent question by a user over the holidays motivated this article on what is likely a commonly used graph. We want to compare the preformance of two categories along with a third measure. This could be something like "How
Hello, 2012! It's a New Year and I'm flushed with ideas for new blog articles. (You can also read about The DO Loop's most popular posts of 2011.) The fundamental purpose of my blog is to present tips and techniques for writing efficient statistical programs in SAS. I pledge to
Today, every organization is running on too few resources - getting it done with fewer people, a reduced budget and less time. Grid computing enables SAS to automatically use a centrally managed grid infrastructure to achieve workload balancing, high availability and parallel processing. Do what once took days in minutes
At the beginning of 2011, I made four New Year's resolutions for my blog. As the year draws to a close, it's time to see how I did: Resolution: 100 blog posts in 2011: Completed. I blew by this goal by posting 165 articles. I recently compiled a list of
It’s a time for excitement, laughter, getting together with friends and family, and best of all cookie exchanges! It’s kind of sad that in a few days it will all be over. Does it have to end? Can’t another holiday or event bring about the same feelings? How about SAS
According to Wikipedia, marketing with music can roughly be traced back to 1923 with the dawn of commercial radio broadcasting. What we now know as a "jingle" first aired on Christmas Eve in 1926, touting the merits of General Mills' Wheaties cereal. As we all know, musical messages have since become a staple for advertisements on
As you probably remember, this innovation series is really Brainstorming 2.0. I've taken the Post-It Notes that SAS users put on the Innovation Wall and reposted them here to help spark new ideas for using SAS. I'm also adding posts here and there when I have an interview with a customer
Lots of the visitors to this blog arrive here by way of Google search (welcome!). Thanks to search engines and a few well placed keywords, the same older posts (let's call them "timeless topics") seem to attract the most traffic from year to year. I hope that the searchers find
When I give presentations on using the SG procedures, I try to describe how you can take simple plots and layer them to create more complex graphs. I also emphasize how you must consider the output of each plot type so that, as you overlay them, you do not obscure
2011 saw incredible change in the states as more than half of the governorships changed hands. As expected, that caused significant turnover at the State CIO level, as well. So while executive and technology policies changed in many ways, the dismal budget situation reinforced the need to allocate tax pay
In Simple maps can go a long way, we discussed some techniques to create simple outline maps from map datasets in the MAPS library using GTL. Now, let us take this a step further to do something more useful with this feature. For some graphs, the map information is an essential part of the
On the heels of the release of the popular SAS macro variable viewer from last month, I'm providing another custom task that I hope will prove just as useful. This one is a SAS options viewer, similar in concept to the OPTIONS window in SAS display manager. You can download
My friend and colleague, Matt Fulk, has detailed in his posts some of the great ways we've used SAS Customer Intelligence to improve our own marketing. Using SAS fits with our culture of measurement and analysis that keeps us constantly focused on finding better ways to do things, and one
2011 has been a big year for social media at SAS. Our award-winning blogging program got a major makeover We relaunched the Knowledge Exchange in WordPress to provide great thought leadership content to our customers We debuted new corporate social media presences on Facebook and Google+ The popular support.sas.com discussion
From the largest corporation to a small startup, data overload can be a crippling problem. Just ask this big guy ... Now you know. Happy holidays!
A few colleagues and I were exchanging short snippets of SAS code that create Christmas trees and other holiday items by using the SAS DATA step to arrange ASCII characters. For example, the following DATA step (contributed by Udo Sglavo) creates a Christmas tree with ornaments and lights: data _null_;
