In this article you’ll learn hidden gems about DICTIONARY Tables In SAS. There are tons of useful use cases which many sas programmers aren’t aware of. This article exposes various aspects of DICTIONARY tables with detailed explanation. What Is a DICTIONARY Table In SAS? A DICTIONARY table is a read-only SAS view that contains information … Read more
Before you learn more about SAS Views you should look at what is SAS Data Set. SAS views are built on top of the SAS data set hence it is pivotal to know more about what happens in the backend when you create SAS data set. What Is SAS Data Set? A SAS data set … Read more
In this article you’ll learn “everything” about the SAS Data sets in less than 5 minutes. You’ll also learn parts of the SAS Data set: data portion, descriptor portion, built-in data sets, special data sets, and SAS views. What Is SAS Data Set? A SAS data set is a SAS file stored in a SAS … Read more
The SAS formats are a type of SAS language element that applies a pattern to or executes instructions for a data value to be displayed or written as output. Types of SAS formats: numeric, character, date, time, or timestamp. The ability to create user-defined formats is also supported. The examples of SAS formats are BINARY, … Read more
We have already seen the multiple examples of SAS arrays declaration and in depth article on SAS Do loop. In this article we will demonstrate how to use the Do loop in SAS array. Do Loop In SAS In this method SAS executes statements between the DO and END statements repetitively, based on the value … Read more
What Is SAS Loop? A loop in SAS is a programming construct that is used to repeat a set of instructions for a specific number of times or until a certain condition is met. There are three basic types of loops in SAS: DO Loop: This loop performs a certain number of iterations. For example, … Read more
You can append values from the multiple columns into one column in SAS. It’s also called reverse transposing the dataset. You are appending values by merging columns into one column against one unique variable. The following sample dataset will be used to demonstrate how to append values from multiple columns into one column (reverse transposing … Read more
You can combine all the values present on one column and form a single string using macro variable. There might be a scenario where you want to create a macro variable and assign values to that variable referring to any specific variable from SAS dataset. There are multiple ways you can create macro variables and … Read more
What Are SAS Arrays? In SAS, an array is a convenient way of temporarily identifying a group of variables. It’s not a data structure, and the array name is not a variable. An ARRAY statement defines an array. An array reference uses an array element in a program statement. All variables that are associated with … Read more
LIKE Operator In SAS The LIKE operator selects observations by comparing the values of a character variable to a specified pattern, which is referred to as pattern matching. The LIKE operator is case sensitive. There are two special characters available for specifying a pattern: 1. percent sign (%) It specifies that any number of characters … Read more