Data Visualization | Learn SAS | Programming Tips

Rick WicklinFebruary 1, 2023 0

Colorblind-safe palettes in SAS

SAS supports the ColorBrewer system of color palettes from the ColorBrewer website (Brewer and Harrower, 2002). The ColorBrewer color ramps are available in SAS by using the PALETTE function in SAS IML software. The PALETTE function supports all ColorBrewer palettes, but some palettes are not interpretable by people with color

Read More

English

Data Visualization | Learn SAS | Programming Tips

Rick WicklinJanuary 30, 2023 0

Tips for making colorblind-safe statistical graphs

Did you know that about 8% of the world's men are colorblind? (More correctly, 8% of men are "color vision deficient," since they see colors, but not all colors.) Because of the "birthday paradox," in a room that contains eight men, the probability is 50% that at least one is

Read More

English

Learn SAS | Programming Tips

Rick WicklinJanuary 25, 2023 0

Write to the log from SAS IML programs

I previously discussed how to use the PUTLOG statement to write a message from the DATA step to the log in SAS. The PUTLOG statement is commonly used to write notes, warnings, and errors to the log. This article shows how to use the PRINTTOLOG subroutine in SAS IML software

Read More

English

Learn SAS | Programming Tips

Rick WicklinJanuary 23, 2023 0

Use the PUTLOG statement to write errors, warning, and notes to the SAS log

Many experienced SAS programmers use the PUT statement to write messages to the log from a DATA step. But did you know that SAS supports the PUTLOG function, which is another way to write a message to the log? I use the PUTLOG statement in the DATA step for the

Read More

English

Analytics | Programming Tips

Peter StyliadisJanuary 17, 2023 0

Getting started with Python integration to SAS® Viya® - Part 12 - Count of Unique Values

Welcome to the continuation of my series Getting Started with Python Integration to SAS Viya. In previous posts, I discussed how to connect to the CAS server, working with CAS actions and CASResults objects, and how to summarize columns. Now it's time to focus on how to get the count of unique values

Read More

English

Analytics | Programming Tips

Rick WicklinJanuary 16, 2023 0

Simulate data from a logistic regression model: How the intercept parameter affects the probability of the event

This article shows that you can use the intercept parameter to control the probability of the event in a simulation study that involves a binary logistic regression model. For simplicity, I will simulate data from a logistic regression model that involves only one explanatory variable, but the main idea applies

Read More

English

Programming Tips | SAS Administrators

Leonid BatkhanJanuary 11, 2023 0

Automatic cloning of SAS metadata user groups and roles

SAS expert Leonid Batkhan demonstrates how to automatically replicate/clone metadata users’ groups and roles from one user to another.

Read More

English

Analytics | Learn SAS | Programming Tips

Rick WicklinJanuary 11, 2023 0

12 blog posts from 2022 that deserve a second look

In a previous article, I presented some of the most popular blog posts from 2022. In general, popular articles deal with elementary topics that have broad appeal. However, I also write articles about advanced topics. The following articles didn't make the Top 10 list, but they deserve a second look.

Read More

English

Programming Tips

Ron CodyJanuary 10, 2023 0

Understanding the _TYPE_ variable in output data sets

When you use PROC MEANS or PROC SUMMARY to create a summary data set and include a CLASS statement, SAS includes two variables, _FREQ_ and _TYPE_, in the output data set. This blog shows you two ways to interpret and use _TYPE_ using the data set Shoes in the SASHELP

Read More

English

Analytics | Learn SAS | Programming Tips

Rick WicklinJanuary 4, 2023 0

Top 10 posts from The DO Loop in 2022

Last year, I wrote almost 90 articles for The DO Loop blog. My most popular articles were about SAS programming, data visualization, statistics and data analysis, and matrix computations. If you missed these articles when I published them—or if you want to read them again!— here is the "Reader's Choice

Read More

English

Programming Tips

Peter StyliadisDecember 22, 2022 0

Creating a Microsoft Excel report using SAS, Python and SQL!

The addition of the PYTHON procedure and Python editor in SAS Viya enables users to execute Python code in SAS Studio. This new capability in SAS Viya adds another tool to SAS's existing collection. With this addition I thought, how can I utilize this new found power? In this example,

Read More

English

Programming Tips

Bari LawhornDecember 21, 2022 0

Decode your SAS® macro code with the MFILE and MPRINT options

SAS' Bari Lawhorn introduces you to the MFILE option as a way to home in on errors and warnings in your macros.

Read More

English

Programming Tips | SAS Administrators

Ursula PoloDecember 20, 2022 0

ESM and S9CA: Useful Tools for Migration from SAS 9 to SAS Viya

Change is hard and can be a bit scary. We tend to resist change as we get comfortable with our routines and how things work. However, many times we fail to see the benefits of that something new. Imagine if we didn't move from MS DOS to Windows? If we'd

Read More

English

Programming Tips

Peter StyliadisDecember 19, 2022 0

CAS-Action! Advanced Frequency Tables - Part 4

Welcome back to my SAS Users blog series CAS Action! - a series on fundamentals. The previous posts show how to use the simple.freq CAS action to generate, save and group simple frequency tables. In this post I will show you how to use the freqTab.freqTab CAS action to generate more advanced

Read More

English

Learn SAS | Programming Tips

Rick WicklinDecember 19, 2022 0

Working with combinations in SAS

A colleague posted a Christmas-themed code snippet that shows how to use the DATA step in SAS to output all the possible ways that Santa can hitch up a team of reindeer to pull his sled. The assumption is that Rudolph must lead the team, and the remaining reindeer are

Read More

English

Programming Tips

Peter StyliadisDecember 16, 2022 0

CAS-Action! Grouping Frequency Tables - Part 3

Welcome back to my SAS Users blog series CAS Action! - a series on fundamentals. In my previous part 1 and part 2 posts I reviewed how to use the simple.freq CAS action to generate frequency distributions for one or more columns and how to save the results. In this post I

Read More

English

Programming Tips

Ron CodyDecember 14, 2022 0

Using SAS to score a test

If you have ever needed to score a multiple-choice test, this blog is for you. Even if you are not planning to score a test, the techniques used in this example are useful for many other programming tasks. The example I am going to present assumes the answer key and

Read More

English

Analytics | Learn SAS | Programming Tips

Rick WicklinDecember 14, 2022 0

Construct heterogeneous structured covariance matrices in SAS

A previous article describes how to use SAS IML software to construct common covariance structures that are encountered in mixed models. Each covariance matrix has several parameters, and you want to construct a matrix for any choice of the parameters. After you have constructed the covariance matrix, you can use

Read More

English

Programming Tips

Peter StyliadisDecember 12, 2022 0

CAS-Action! Saving Frequency Tables - Part 2

Welcome back to my SAS Users blog series CAS Action! - a series on fundamentals. In my previous post CAS-Action! Simple Frequency Tables - Part 1, I reviewed how to use the simple.freq CAS action to generate frequency distributions for one or more columns using the distributed CAS server. In this post

Read More

English

Learn SAS | Programming Tips

Rick WicklinDecember 12, 2022 0

Properties of the Hadamard product

I always emphasize efficiency in statistical programming. I have previously written about why you should never multiply with a large diagonal matrix in the SAS IML language. The reason is that it is more efficient to use elementwise multiplication than matrix multiplication. Specifically, if d is a column vector, then

Read More

English

Analytics | Programming Tips

Peter StyliadisDecember 7, 2022 0

CAS-Action! Simple Frequency Tables - Part 1

Welcome back to my SAS Users blog series CAS Action! - a series on fundamentals. If you'd like to start by learning more about the distributed CAS server and CAS actions, please see CAS Actions and Action Sets - a brief intro. Otherwise, let's learn how to generate frequency distributions for one

Read More

English

Data Visualization | Learn SAS | Programming Tips

Rick WicklinDecember 7, 2022 0

Art in SAS: Christmas wrapping paper

For Christmas 2021, I wrote an article about palettes of Christmas colors, chiefly shades of red, green, silver, and gold. One of my readers joked that she would like to use my custom palette to design her own Christmas wrapping paper! I remembered her jest when I saw some artwork

Read More

English

Analytics | Programming Tips

Peter StyliadisDecember 1, 2022 0

CAS-Action! Rename Columns in a CAS Table

Welcome back to my SAS Users blog series CAS Action! - a series on fundamentals. If you'd like to start by learning more about the distributed CAS server and CAS actions, please see CAS Actions and Action Sets - a brief intro. Otherwise, let's learn how to rename columns in CAS tables.

Read More

English

Learn SAS | Programming Tips

Rick WicklinNovember 30, 2022 0

Ladders: A probabilistic card trick

A probabilistic card trick is a trick that succeeds with high probability and does not require any skill from the person performing the trick. I have seen a certain trick mentioned several times on social media. I call it "ladders" or the "ladders game" because it reminds me of the

Read More

English

Learn SAS | Programming Tips

Rick WicklinNovember 28, 2022 0

Simulate poker hands in SAS

A SAS programmer was trying to simulate poker hands. He was having difficulty because the sampling scheme for simulating card games requires that you sample without replacement for each hand. In statistics, this is called "simple random sampling." If done properly, it is straightforward to simulate poker hands in SAS.

Read More

English

Analytics | Programming Tips

Rick WicklinNovember 21, 2022 0

The area under a piecewise linear curve

Recently, I needed to know "how much" of a piecewise linear curve is below the X axis. The coordinates of the curve were given as a set of ordered pairs (x1,y1), (x2,y2), ..., (xn, yn). The question is vague, so the first step is to define the question better. Should

Read More

English

Analytics | Data Visualization | Programming Tips

Rick WicklinNovember 16, 2022 0

Optimal linear profile plots in SAS

A profile plot is a way to display multivariate values for many subjects. The optimal linear profile plot was introduced by John Hartigan in his book Clustering Algorithms (1975). In Michael Friendly's book (SAS System for Statistical Graphics, 1991), Friendly shows how to construct an optimal linear profile by using

Read More

English

Data Visualization | Learn SAS | Programming Tips

Rick WicklinNovember 14, 2022 0

Profile plots in SAS

A profile plot is a compact way to visualize many variables for a set of subjects. It enables you to investigate which subjects are similar to or different from other subjects. Visually, a profile plot can take many forms. This article shows several profile plots: a line plot of the

Read More

English

Programming Tips | SAS Administrators

Leonid BatkhanNovember 8, 2022 0

SAS administrator tip: How to identify and prevent duplicate librefs in SAS metadata

In this SAS administration tutorial Leonid Batkhan presents various SAS programming solutions on how to identify and prevent duplicate LIBREFs in SAS 9 metadata.

Read More

English

Analytics | Data Visualization | Learn SAS | Programming Tips

Rick WicklinNovember 7, 2022 0

The area of the convex hull of random points

I recently blogged about how to compute the area of the convex hull of a set of planar points. This article discusses the expected value of the area of the convex hull for n random uniform points in the unit square. The article introduces an exact formula (due to Buchta,

Read More

English