Sometimes it is useful to group observations based on the values of some variable. Common schemes for grouping include binning and using quantiles. In the binning approach, a variable is divided into k equal intervals, called bins, and each observation is assigned to a bin. In this scheme, the size
This week's SAS tip is from Don Henderson and his book Building Web Applications with SAS/IntrNet. A SAS user since 1975, Don was one of the original developers for the SAS/IntrNet Application Dispatcher. The following excerpt is from SAS Press author Don Henderson and his book "Building Web Applications with SAS/IntrNet: A Guide to the
Dylan Jones (@dataqualitypro) explains why data migration should be a keystone of your data transformation.
You may have received the announcement that Carpenter’s Guide to Innovative SAS Techniques has just released as an eBook through the Apple iBookstore. Over the years, we’ve received feedback from SAS users that they would like more flexibility in how they purchase their SAS Press content. With Art’s book, we’re
Detecting and preventing fraud isn't easy. Many tools and techniques are required, and while the digital age and advanced technologies have made fraud much easier in many ways, those same technologies have opened up new ways to combat it. One of those comes in the form of social network analysis,
Dear Miss SAS Answers, I have read through a few Dear Miss SAS Answers blog posts, but I cannot seem to find what I am looking for. I need to extract only the second duplicate from a whole list of duplicates per account number. Is there a way to
With the US presidential election looming, all eyes are on the Electoral College. In the presidential election, each state gets as many votes in the Electoral College as it has representatives in both congressional houses. (The District of Columbia also gets three electors.) Because every state has two senators, it
Last week I attended a meeting of the Toronto Area SAS Society. (Okay, I didn't just attend; I was a presenter as well.) This user group meeting contained a feature that I had never seen before: "Solutions to the Posed Problem". Weeks before the meeting, an "open problem" was posted
Avast Mateys! Did you know that International Talk Like a Pirate Day is coming up?!? (September 19) Here's the official website, if you'd like more info. And what better way to get into the spirit of things than to use SAS/GRAPH to plot some real pirate data - Arrrr!!! Here's
Who says anyone is an expert at something? I definitely do not when it comes to SAS (well, anything for that matter). Each time I sit through a presentation at a conference I learn something new. During the SAS Western Users Conference, fondly know as WUSS, this month I learned
Ron Cody’s newest book, Cody's Collection of Popular SAS Programming Tasks and How to Tackle Them, is already getting high marks from early reviewers. Gerry Hobbs (West Virginia University), says, “This is an excellent book that deserves a place on every SAS professional’s bookcase.” Long-time SAS user Andrew T. Kuligowski
If you use a word three times, it's yours. -Unknown When I was a child, my mother used to encourage me to increase my vocabulary by saying, "If you use a word three times, it's yours for life." I believe that the same saying holds for programming techniques: Use a
A week ago, SAS "wusses" got together in Long Beach, California for another successful WUSS conference. Personally, I really enjoy all SAS user conferences as it gives me an opportunity to see the creative ways in which SAS users are exploiting our software. One such case was the paper "Power
Manfred Kiefer is a Globalization Specialist for SAS and the author of SAS Encoding: Understanding the Details. This week's tip is from his new book. In a review, Edwin Hart said "This book provides a very readable description of a topic that has long needed exposure: Why do my characters get
Government pensions at the state and local government level have come under attack in recent years over their viability. Much of this attack has been political and is being used to go after unions and pensioners who tend to support one party or another. State and local governments work hard to maintain viable
I have returned safely from my trip to Long Beach, CA, and WUSS 2012! As always, it was a great conference. The opening session was really fun this year. Maura Stokes and Diane Hatcher from SAS gave the keynote in the form of a “presidential debate.” Maura’s platform was analytics; while
Out of the box, the simple bar graph uses the same color for each bar. A frequent request from users is to define a standard color palette for the dashboard indicators so distinct bars are the same color in each indicator or from refresh to refresh. With most dashboard tricks,
This article is an excerpt from my forthcoming book Simulating Data with SAS. Not every matrix with 1 on the diagonal and off-diagonal elements in the range [–1, 1] is a valid correlation matrix. A correlation matrix has a special property known as positive semidefiniteness. All correlation matrices are positive
Michele Burlew’s new book, SAS Hash Object Programming Made Easy takes users through the newest look-up technique from SAS, one that has many still shaking their heads. “Not many DATA step programmers have used hash objects much,” Burlew says. “They seem scary because they operate a little differently from the SAS
This is a dramatic interpretation of an actual conversation I recently had with the CIO of one of North Carolina’s leading cities. We discussed his experience using data quality, data integration, business intelligence and analytics in the daily operation of the city. I may have taken some...well, a lot of
Robert Allison posted a map that shows the average commute times for major US cities, along with the proportion of the commute that is attributed to traffic jams and other congestion. The data are from a CEOs for Cities report (Driven Apart, 2010, p. 45). Robert use SAS/GRAPH software to
This week's SAS tip comes from superstar blogger Rick Wicklin and his book Statistical Programming with SAS/IML Software. You can learn more about Rick, read user reviews of his book and a free chapter, as well as sign up to receive notification of availability of his forthcoming book Simulating Data with SAS --by visiting his author page.
Around the country and in my neighborhood, kids everywhere have returned to school. We’ve made it through the back-to-school ads in our newspapers, social media, and on TV. Our pocket books are lighter now (and credit cards heavier) with all the spending on school supplies and the very important back-to-school
A while back, I had seen the following map on the CEOs for Cities website. It seemed like an interesting topic and an interesting map, but I just couldn't grok what their map was saying ... So I decided to download the data and create my own map with SAS. I
Ah! The joys of sets! It is easy to test whether two vectors are equal in SAS/IML software. It is only slightly more challenging to test whether two sets are equal. Recall that A and B are equal as sets if they contain the same elements. Order does not matter.
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
SAS users world-wide have turned to Susan Slaughter, Lora Delwiche, and The Little SAS Book to learn SAS programming. This week's SAS tip is from their bestselling fourth edition of the book (the fifth edition is now available for preorder). Whichever version of The Little SAS Book you use, you'll benefit from the friendly
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
Wondering why technology is such a big deal and why working with SAS will be in demand forever? The great blackout of Toronto in 2003 proved that so well. We could barely survive without electricity for a whole day. While breakdowns make us acutely aware of our dependence, technology also
According to Wikipedia, "Innovation is the creation of better or more effective products, processes, services, technologies, or ideas that are readily available to markets, governments, and society. Innovation differs from invention in that innovation refers to the use of a better and, as a result, novel idea or method, whereas
