The DO Loop

Learn SAS

Learn about the latest tips, tutorials, upcoming events and certifications

Rick WicklinSeptember 11, 2019 5

Axis tables versus rotated text: How to display a wide table in a small graph

I often use axis tables in PROC SGPLOT in SAS to add a table of text to a graph so that the table values are aligned with the data. But axis tables are not the only way to display tabular data in a graph. You can also use the TEXT

English

Data Visualization | Learn SAS

Rick WicklinSeptember 9, 2019 2

Anchor points and rotated text in PROC SGPLOT

The TEXT statement in PROC SGPLOT supports the ROTATE= option to rotate the specified text. It is worth knowing how the ROTATE= option interacts with the POSITION= option, which determines the anchor point at which the text is positioned. Briefly, the text is positioned FIRST, then the rotation occurs. The

English

Learn SAS | Programming Tips

Rick WicklinAugust 19, 2019 2

Timing performance in SAS/IML: Built-in functions versus Base SAS functions

One of my friends likes to remind me that "there is no such thing as a free lunch," which he abbreviates by "TINSTAAFL" (or TANSTAAFL). The TINSTAAFL principle applies to computer programming because you often end up paying a cost (in performance) when you call a convenience function that simplifies

English

Learn SAS | Programming Tips

Rick WicklinAugust 14, 2019 6

Short-circuit evaluation and logical ligatures in SAS

Many programmers are familiar with "short-circuit" evaluation in an IF-THEN statement. Short circuit means that a program does not evaluate the remainder of a logical expression if the value of the expression is already logically determined. The SAS DATA step supports short-circuiting for simple logical expressions in IF-THEN statements and

English

Learn SAS | Programming Tips

Rick WicklinAugust 7, 2019 3

The essential guide to binning in SAS

Do you want to bin a numeric variable into a small number of discrete groups? This article compiles a dozen resources and examples related to binning a continuous variable. The examples show both equal-width binning and quantile binning. In addition to standard one-dimensional techniques, this article also discusses various techniques

English

Learn SAS | Machine Learning | Programming Tips

Rick WicklinAugust 5, 2019 8

How to use PROC HPBIN to bin numerical variables

Binning transforms a continuous numerical variable into a discrete variable with a small number of values. When you bin univariate data, you define cut point that define discrete groups. I've previously shown how to use PROC FORMAT in SAS to bin numerical variables and give each group a meaningful name

English

Learn SAS | Programming Tips

Rick WicklinJuly 31, 2019 3

Use numeric values for column headers when printing a matrix

Sometimes a little thing can make a big difference. I am enjoying a new enhancement of SAS/IML 15.1, which enables you to use a numeric vector as the column header or row header when you print a SAS/IML matrix. Prior to SAS/IML 15.1, you had to use the CHAR or

English

Learn SAS | Programming Tips

Rick WicklinJuly 29, 2019 2

Vectorize the computation of the Mandelbrot set in a matrix language

When my colleague, Robert Allison, blogged about visualizing the Mandelbrot set, I was reminded of a story from the 1980s, which was the height of the fractal craze. A research group in computational mathematics had been awarded a multimillion-dollar grant to purchase a supercomputer. When the supercomputer arrived and got

English

Learn SAS | Programming Tips

Rick WicklinJuly 24, 2019 4

Implement the Gumbel distribution in SAS

SAS supports more than 25 common probability distributions for the PDF, CDF, QUANTILE, and RAND functions. Of course, there are infinitely many distributions, so not every possible distribution is supported. If you need a less-common distribution, I've shown how to extend the functionality of Base SAS (by using PROC FCMP)

English

Data Visualization | Learn SAS | Programming Tips

Rick WicklinJuly 15, 2019 4

Create a discrete heat map with PROC SGPLOT

Heat maps have many uses. You can use a heat map to visualize correlation matrices, to visualize longitudinal data ("lasagna plots"), and to visualize counts in any two-dimensional table. As of SAS 9.4m3, you can create heat maps in SAS by using the HEATMAP and HEATMAPPARM statements in PROC SGPLOT.

English

Blogs

Blogs

Learn SAS