Example 2.1 Concatenating Data Sets

Goal

Concatenate three data sets. Define a variable that identifies the data set from which the observation originated.

Example Features

Featured StepDATA step
Featured Step Options and StatementsSET statement, IN= option
Related Technique 1PROC SQL, OUTER UNION set operator and CORR keyword
Related Technique 2PROC APPEND

Input Data Sets

Data sets SPRINGGRADS, SUMMERGRADS, and FALLGRADS contain lists of biology students who graduated in spring, summer, and fall. The Student' final GPAs are included.

               SPRINGGRADS

Obs      student       concentration    gpa 1 Johnson, Allison Biochemistry 3.86 2 Davis, Jeffrey General Biology 3.91 3 Hall, Daniel Genetics 3.43 4 Hill, Courtney Ecology 4.00 5 Scott, Tiffany Plant Biology 3.58 ...

Get Combining and Modifying SAS® Data Sets: Examples Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.