Tag: Uncategorized

Fun with Dots in PROC REPORT

You should play a little. Add dots. Add color. Your PROC REPORT output does not have to be boring. As a matter of fact, it can be both functional and appealing. Any Unicode value will do, but this blog shows how to use the Unicode value for a dot (fill…

Using X-ray glasses to see patterns in your data!

When you were a kid, were you intrigued by the 99-cent X-ray glasses advertised in the back of the comic books? If you ordered those glasses, you were probably disappointed. Now that you’re an adult, how would you like to use computer techniques to “X-…

Import Excel data, transpose, and plot it!

Of course you know how to create graphs … But do you often find that preparing the data to plot is often the hardest part? Well then, this blog post is for you! I’ll be demonstrating how to import Excel data into SAS, transpose the data, use what wer…

SAS code golf: find the max digit in a string of digits

“Code golf” is a fun programming pastime that challenges you to solve a problem with the least amount of code possible. Like regular golf, the goal is to use fewest code “strokes” to hit the mark. Here’s a recent challenge that was posted to me via Twitter. @cjdinger @SASJedi got […]

The post SAS code golf: find the max digit in a string of digits appeared first on The SAS Dummy.

What DS2 can do for the DATA step

The Base SAS DATA step has been a powerful tool for many years for SAS programmers. But as data sets grow and programmers work with massively parallel processing (MPP) computing environments such as Teradata, Hadoop or the SAS High-Performance Analytic…

How old is your county?

The United States declared independence in 1776, and we celebrate it on July 4th every year. But the land areas that make up the United States today weren’t necessarily the same as they were back then. So I thought it would be interesting to create a m…

Using %IF-%THEN-%ELSE in SAS programs

SAS programmers have long wanted the ability to control the flow of their SAS programs without having to resort to complex SAS macro programming. With SAS 9.4 Maintenance 5, it’s now supported! You can now use %IF-%THEN-%ELSE constructs in open code. This is big news — even if it only […]

The post Using %IF-%THEN-%ELSE in SAS programs appeared first on The SAS Dummy.

When will women control state legislatures?

In FiveThirtyEight’s Significant Digits section, they recently mentioned that nine states could potentially have 50% or more females in their legislature after the upcoming election. My first thought – I need to see some graphs! They linked to a New Yo…