Example 2.2 Interleaving Observations from Two or More Data Sets Based on a Common Variable
Interleave the observations from three data sets in order by the values of a specific variable. Define a variable that identifies the data set from which the observation originated.
|Featured Step||DATA step|
|Featured Step Options and Statements||SET statement, IN= option BY statement|
|Related Technique||PROC SQL, OUTER UNION set operator and CORR keyword, ORDER BY clause|
Input Data Sets
Data sets SPRINGGRADS, SUMMERGRADS, and FALLGRADS contain lists of biology students who graduated in spring, summer, and fall. The students' final GPAs are included.
Example 2.1 also uses the three data sets.
SPRINGGRADS Obs student concentration gpa 1 ...