Did you know that you can index into SAS/IML matrices by using unique strings that you assign via the MATTRIB statement? The MATTRIB statement associates various attributes to a matrix. Usually, these attributes are only used for printing, but you can also use the ROWNAME= and COLNAME= attributes to subset
Ron Cody’s at it again. It’s like he just can’t help himself; he knows SAS and wants to help others know it too. His new book, Cody's Collection of Popular SAS Programming Tasks and How to Tackle Them gathers often-used programming tasks and techniques in one handy volume, allowing users
Business forecasting is a dismal field of endeavor, fit for dismal people like myself. In an attempt to make this field interesting to people who aren't so dismal by nature, our friends at PollyVote Election Forecasting ask the question: Could you be President of the United States? The PollyVote project is
By now, most of you probably already know how to add drill downs and hover text to your SAS graphs. But did you know you can add pop-up images and graphs? Here are a couple of examples ... In this first example, when you hover your mouse over each state, you
Is there a forecasting problem you'd like to attack, and wouldn't mind a little financial support to do it? If so, the SAS/IIF Grant to Support Research on Forecasting may be just what you need to get started. For the tenth year, in collaboration with the International Institute of Forecasters,
I was recently flipping through Ross' Simulation (2006, 4th Edition) and saw the following exercise: Let N be the minimum number of draws from a uniform distribution [until the sum of the variates]exceeds 1. What is the expected value of N? Write a simulation to estimate the expected value. For
This summer’s education conferences have been dominated by sessions discussing the “next generation,” Common Core aligned assessments in English and mathematics. As 44 states plan for the transition from their state tests to the new PARCC and Smarter Balanced Assessment Consortium assessments, SAS has received repeated questions from our partners
The following is an excerpt from my forthcoming book: Creating Custom Tasks for SAS Enterprise Guide using Microsoft .NET. If your custom task generates a SAS program, the chances are pretty high that your program will reference one or more variables within a SAS data set. Despite our best efforts,
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
Dylan Jones (@dataqualitypro) explains why data migration should be a keystone of your data transformation.
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
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
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
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
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
