The macro is dynamic to generate multiple Excel files containing the frequency results for each unique BY-group. (e.g., Type). PROC SQL SELECT code is embedded inside a macro in this SAS example. The SELECT query processes the column (passed in the macro parameter) and then create a macro variable with the number of unique (distinct) [...]

In this article, you will learn ten uses of the Proc Dataset procedure PROC DATASET can perform a…

Data manipulation and management are vast fields in which SAS stands out as an incredibly versatile…

In the previous post, we discussed Creating a single record from multiple records in SAS. What if you want to go the other approach, that is, creating a data set with multiple observations from a single observation per ID? The process is simple, and we have taken the output from the previous example as input [...]

Creating a single record from multiple records in SAS is to transform a data set with one observation per subject and convert it to a data set with many observations per subject. Why is this required? It is easier to analyse when all the information per subject is in a single observation, for example, generating [...]

Fuzzy matching in SAS is a technique of deciding programmatically if one word is identical to the…

The COMPARE function in SAS lets you compare two-character values. With optionally available…

**PROC PRINT** is a type of procedure that is used by every SAS programmer frequently. Most of you…

What are automatic variables in SAS? Within a data step, SAS automatically create a couple of…

SQL Set operators are conceptually derived from the mathematical set principle. The three…