STA 321 Introduction to Statistical Computing

1
STA 321IntroductiontoStatistical Computing

• Combining SAS Data Sets

2
Read in your textbook

• Chapter 14 An overview
• Chapters 15-19

3
Overview

• Concatenation
• Using the SET statement
• Using Proc Append
• Interleaving
• Merging
• Updating a Master Data Set
• Example Programs

4
Concatenating

• Combining two or more data sets, one after the
  other into a single data set.
• Data new set old1 old2 old3
• Proc Append basemaster newnewdata

5
Interleaving

• Combining individual sorted data sets into one
  sorted data set.
• Data new set old1 old2 by samevar

6
Merging

• Combining observations from two or more data sets
  into a single observation in a new data set.
• One-to-one
• data new merge old1 old2
• Match-merge
• data new merge old1 old2 by samevar

7
Updating a Master Data Set

• Replacing values of variables in a master data
  set with nonmissing values from a transaction
  data set.
• Data new_mstr update master transact by
  samevar

8
Sample Programs

• Winners and Losers
• Description (handout) win-loser-merge.sas
• SAS Sample Programs
• Concatenating chapter15.sas
• Interleaving chapter16.sas
• Merging chapter17.sas
• Updating chapter18.sas
• Manipulating SAS data sets chapter19.sas