Join Jordan Bakerman for an in-depth discussion in this video Match-merging data sets, part of SAS Programming for R Users, Part 1.
- [Narrator] Now the merge statement…is much more powerful than the way I've previously detailed.…Instead of just doing a straight C-bind,…we can actually merge according to a common variable…in each data set.…And in the next few examples I'll show you how to do…a one-to-one, one-to-many-, and non-match merge.…To actually do the following match merging,…you have to first go ahead and sort your data…by that common variable.…And to do so you'll just use Proc Sort.…That's a really easy procedure which you can go ahead…and look up on the online doc page in your own time.…
Once you go ahead and use the sort procedure,…then you can use your data step and use the merge statement.…And you'll list all the data tables you want to merge…according to some common variable.…And to tell SAS what that common variable is,…you'll list it in the by statement.…So imagine I have a data set called employees…and a data set called phone,…which obviously holds the names of my employees…and the phone numbers.…And you'll notice each data set has a common variable,…
Note: You can visit the SAS site to obtain a copy of the software, and use the company's online data sets to do the course exercises.
- SAS University Edition
- Working in SAS Studio
- Using tasks and snippets in SAS Studio
- Determining power using simulation
- SAS procedure syntax
- Creating datasets manually in the DATA step
- Importing raw data files
- Creating new variables and conditional processing
- Match-merging data sets
Skill Level Beginner
Descriptive Healthcare Analytics in Rwith Monika Wahi4h 15m Advanced
1. Introduction and Working in SAS
2. Importing and Reporting Data
3. Creating New Variables, Functions, and Data Tables
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.