Tag: Programming Tips

Adjusting outliers with the 1.5 IQR rule

In my new book, End-to-End Data Science with SAS: A Hands-On Programming Guide, I use the 1.5 IQR rule to adjust multiple variables.  This program utilizes a macro that loops through a list of variables to make the necessary adjustments and creates an output data set. One of the most […]

Adjusting outliers with the 1.5 IQR rule was published on SAS Users.

Missing data? Quickly impute values using SAS Viya

This blog is part of a series on SAS Visual Data Mining and Machine Learning (VDMML). If you’re new to SAS VDMML and you want a brief overview of the features available, check out my last blog post! This blog will discuss types of missing data and how to use imputation […]

Missing data? Quickly impute values using SAS Viya was published on SAS Users.

How to retrieve contents of a SAS® Scalable Performance Data Server library

Just when you think you’ve seen it all, life can surprise you in a big way, making you wonder what else you’ve missed. That is what happened when I recently had a chance to work with the SAS® Scalable Performance Data Server, a product that’s been around a while, but […]

How to retrieve contents of a SAS® Scalable Performance Data Server library was published on SAS Users.

Passing comma-delimited values into SAS macros and macro functions

Have you ever tried to pass comma-delimited values to SAS macro or to a SAS macro function? How can SAS distinguish commas separating parameters or arguments from commas separating parts of the values? Passing comma-delimited value as an argument to a SAS macro function Let’s say you want to extract […]

Passing comma-delimited values into SAS macros and macro functions was published on SAS Users.

Finding n-th instance of a substring within a string

“There’s a way to do it better – find it.” – Thomas A. Edison When it comes to SAS coding, this quote by Thomas A. Edison is my best advisor. Time permitting, I love finding better ways of implementing SAS code. But what code feature means “better” – brevity, clarity […]

Finding n-th instance of a substring within a string was published on SAS Users.

Dividing by zero with SAS – myths and realities

To those of you who have not read my previous post, Dividing by zero with SAS, it’s not too late to go back and make it up. You missed a lot of fun, deep thought and opportunity to solve an unusual SAS coding challenge. For those who have already read […]

Dividing by zero with SAS – myths and realities was published on SAS Users.