topic Re: interleaving in SAS in SAS Programming

interleaving in SAS

anjita — Sat, 12 Jan 2019 11:47:46 GMT

What is interleaving in SAS?

Re: interleaving in SAS

PeterClemmensen — Sat, 12 Jan 2019 13:48:22 GMT

Can you elaborate? In what context are you in doubt of the term 'interleave'?

Re: interleaving in SAS

Astounding — Sat, 12 Jan 2019 14:59:14 GMT

Interleaving refers to a DATA step that uses:

a SET statement with more than one data set
a BY statement.

For example:

data want;

set a b;

by id;

run;

The incoming data sets must all be in sorted order (by ID in this case), and the output will also be in sorted order.

Re: interleaving in SAS

Cynthia_sas — Sat, 12 Jan 2019 15:47:38 GMT

Hi:

Here's a comparison of 2 techniques:

1) Concatenation of the data, then sorting

2) Using 2 (or more) SET statements with BY group processing.

Cynthia

Re: interleaving in SAS

rinugour — Tue, 15 Jan 2019 07:01:56 GMT

Interleaving combines individual, sorted SAS data sets into one sorted SAS data set. For each observation, the following figure shows the value of the variable by which the data sets are sorted. You interleave data sets using a SET statement along with a BY statement.
In the following example, the data sets are sorted by the variable Year.
We can sort and then join the datasets on Year with the below code.

Data combined;
Set data1 data2
By Year;
Run;