All Posts

Leanne Tang had a problem. She has one giant database that houses data from all of the units at National Agricultural Statistics Service. She has hundreds of people who need access, but she wants individual users to have access only to the data that meets their needs. In Tang’s

Do you finish the Word Search in the Sunday paper? Several years ago, Robert Matthews decided to design a word search to help his kids in their school work. Matthews wanted to be able to put in the words of his choice and provide difficulty levels so that game users could

The Macro facility is a powerful and flexible tool, but sloppy techniques can make macros one of your biggest headaches. Poorly handled macros may run without error but leave your users with unexpected results and litter your system with unwanted files and variables.

Living in the Washington, D.C. area I expect the morning news shows to spend a lot of time reporting on traffic. Crashes on the beltway, downed power lines delaying train service…that’s a normal day. D.C. is the most congested city, according to the Texas Transportation Institute’s annual report.). Commuting to

Last week I provided the steps for how to go on a date, at least by using dynamic prompts in BI Dashboard. Now that you have seen how to create them, lets discuss making them smarter. For this example, the customer is asking for two prompts to affect a single

Andy Pulkstenis of State Farm thinks it is, stating that this red-headed stepchild among modeling technques is where predictive modeling was ten years ago. He opened his talk, "Do You Know or Do You Think You Know? Creating a Testing Culture at State Farm," at the A2012 conference in Las Vegas with

You've all heard about the recent meningitis outbreak, right? Being a data-guy and a map-guy, I went looking for maps related to the outbreak. I found the following map on the Centers for Disease Control (CDC) website. It shows the states that received the recalled drug used in epidurals (for back

Have you registered for the 20th annual SouthEast SAS Users Group conference (SESUG) yet? NO? What are you waiting for? I've heard it going to be a real party, so come help us celebrate SESUG's 20th birthday (hmm ... SESUG isn't even old enough to drink). The last time I went was

Sunny days, keeping the clouds away, can you tell me how to get, how to get to Sesame Street?? Oops, sorry, was just day dreaming about younger days and the magic of an eight foot talking yellow bird. How great was Sesame Street? I learned counting, my abc’s, sharing, diversity,

Beans aren’t just good for your heart; they’re affordable, convenient, and packed with nutrients that have a wide range of health benefits including lowered LDL cholesterol, blood sugar control, weight management, and more. Beans are an excellent plant-based source of protein and fiber and are rich in minerals such as

~ Lisa Pyle and Rob Russell, NESUG 2012 Conference Co-chairs Can you believe it?! In just a few weeks we will all be together at NESUG's 25th conference! We are looking forward to all the presentations and workshops we have planned and to seeing all our old friends and meeting some new ones too.

Last week I wrote a SAS/IML program that computes the odds of winning the game of craps. I noted that the program remains valid even if the dice are not fair. For convenience, here is a SAS/IML function that computes the probability of winning at craps, given the probability vector

You might know about the many automatic macro variables that are available in SAS. They provide plenty of information about the SAS environment, such as the current user (SYSUSERID), the SAS version (SYSVER and SASVLONG), and the operating system where SAS is running (SYSCP and SYSCPL). That information is often

As SLG’s health policy specialist, I’m chartered with developing novel ways to apply data analytics to our state government health systems. If you ask me, it’s the perfect blend of technology and policy - two of my favorite things. However, I sometimes find it challenging to identify the areas within
The Scatter Plot Matrix statement supports a couple of different configurations. The basic is the N x N panel of cells, with each cell showing scatter plots plot for a pair of variables at a time. Here is an example of a 3 x 3 scatter plot matrix for the