SAS Users

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

Programming Tips

Suzanne MorgenFebruary 14, 2020 3

Learn to Love SAS LIKE

In honor of Valentine’s day, we thought it would be fitting to present an excerpt from a paper about the LIKE operator because when you like something a lot, it may lead to love! If you want more, you can read the full paper “Like, Learn to Love SAS® Like”

English

Programming Tips

Ron CodyFebruary 5, 2020 0

Finding Possible Data Errors Using the %Auto_Outliers Macro

One of the first and most important steps in analyzing data, whether for descriptive or inferential statistical tasks, is to check for possible errors in your data. In my book, Cody's Data Cleaning Techniques Using SAS, Third Edition, I describe a macro called %Auto_Outliers. This macro allows you to search

English

Learn SAS | Programming Tips

Leonid BatkhanJanuary 27, 2020 20

Shifting a date by a given number of workdays

This blog post demonstrates process and SAS coding techniques to shift dates by a given number of workdays accounting for weekends and holidays.

English

Programming Tips

Lora D. DelwicheJanuary 21, 2020 1

Expand Your SAS Knowledge by Learning PROC SQL

One great thing about being a SAS programmer is that you never run out of new things to learn. SAS often gives us a variety of methods to produce the same result. One good example of this is the DATA step and PROC SQL, both of which manipulate data. The

English

Learn SAS | Programming Tips

Suzanne MorgenJanuary 13, 2020 0

Foresight is 2020! New books to take your skills to the next level

Are you ready to get a jump start on the new year? If you’ve been wanting to brush up your SAS skills or learn something new, there’s no time like a new decade to start! SAS Press is releasing several new books in the upcoming months to help you stay

English

Programming Tips

Amber ElamJanuary 10, 2020 1

Why does my SAS date have the wrong century?

2020 is here and systems that use 2-digit years in date values are getting confused. Do we mean 1920 or 2020? In SAS, the YEARCUTOFF= option lets you decide.

English

Programming Tips

Ron CodyJanuary 8, 2020 2

Adventures of a SAS detective and the fantastic FIND function

Did I trick you into seeing what this blog is about with its mysterious title? I am going to talk about how to use the FIND function to search text values. The FIND function searches for substrings in character values. For example, you might want to extract all email addresses

English

Data Management | Programming Tips

Yinliang WuDecember 20, 2019 0

How to filter variables by percentage of missing values or duplicate values in SAS

This article discusses how to use SAS to filter variables in a dataset based on the percentage of missing values or duplicate values. The missing value statistics can be implemented by either DATA step programming on your own or reusing the existing powerful PROC FREQ.

English

Learn SAS | Programming Tips

Sian RobertsDecember 17, 2019 0

How many people does it take to publish a book?

The next time you pick up a book, you might want to pause and think about the work that has gone into producing it – and not just from the authors.

English

Advanced Analytics | Analytics | Machine Learning | Programming Tips

Nelson GrajalesDecember 11, 2019 0

Machine Learning with SASPy: Exploring and Preparing your data - Part 3

Parts 1 and 2 of this blog post discussed exploring and preparing your data using SASPy. To recap, Part 1 discussed how to explore data using the SASPy interface with Python. Part 2 continued with an explanation of how to prepare your data to use it with a machine-learning model.

English

Blogs

Blogs

Programming Tips