O'Reilly logo

Combining and Modifying SAS® Data Sets: Examples Second Edition by Michele M. Burlew

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Example 2.3 Appending One Data Set to the End of Another Data Set

Goal

Add the observations from one data set to the end of another data set.

Example Features

Featured StepPROC APPEND
Featured Step Options and StatementsFORCE option
Related Technique 1PROC DATASETS, APPEND statement with FORCE option
A Closer LookDetermining When to Use PROC APPEND Using PROC APPEND When a Variable Exists in Only One of the Data Sets

Input Data Sets

Data set YTDPRICES contains 103 observations that record daily closing mutual fund prices. The first ten and the last five observations in YTDPRICES are shown.

   YTDPRICES (first 10 observations)

Obs     tradedate      price    boardmtg 1 01/04/2010 $80.29 2 01/05/2010 $85.36 3 01/06/2010 $81.43 4 01/07/2010 $79.51 5 01/08/2010 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required