SAS data sets consist of a descriptor portion and a data portion that contains the data values. The descriptor portion of a SAS data set holds the detailed information about the data set. This information

It is one of the most common data manipulation tasks to find records that exist in table one that also exists in table two. In other words, finding common rows that exist in both tables. This post includes 3 methods with PROC SQL and 1 method with data step merge to solving it. Suppose you have [...]

Sorting Orders for Numeric Variables Numeric variables are sorted from the smallest-to-largest…

There are a number of statements, options, functions, and programming alternatives that are well suited to controlling how and when all or a portion of a program can be stopped conditionally. Sometimes we want to control the flow of the individual data steps of the program. This may include the termination of a step or even the SAS job itself. There are several exit strategies depending on the objective.

Password Protecting SAS datasets means using access control on your data to prevent unintended access and secure your data. SAS has provided three levels of Access controls over the data and is implemented using passwords.

There are several ways to save a log file in SAS. However, the most straightforward way is to use…

PROC SUMMARY in SAS procedures allows us to explore our data in terms of counts and distributions…

Proc Contents is a useful tool for analyzing data in SAS. This article will show you how to use Proc…

This article thoroughly explores the significant features of the SCAN function in SAS, covering its…

The SAS INDEX function searches for a specified string of characters. If any match is found, the…