Hands-On SAS for Data Analysis

Interleaving

In interleaving, we stack up datasets in a particular order. In this instance, we have specified the order through the By Index statement:

Use the following code to interleave the two tables:

Data Interleave_AB;                        Set A B;                                                        By Index;                                Run;                                                   

This will result in the following output:

Whenever you specify a By statement, you need to ensure that the variable that's mentioned in the statement is sorted. You may have noticed that duplicate values have been retained in the output.