Join Jordan Bakerman for an in-depth discussion in this video Concatenating data sets, part of SAS Programming for R Users, Part 1.
- [Narrator] Now that we know how to subset data,…what if we want to go ahead and column bind…or row bind our data back together again?…To reproduce the rbind function in r, we'll use a data step.…And in the set statement, we'll specify…all the data sets we want to row bind.…So imagine I have two data sets here,…Employees Denmark and Employees France,…and I just want to stack them on top of each other…and create a new data set called Employees All.…Well, I'll just pass the Employees Denmark data table…and the Employees France data table to a single set…statement and it'll simply stack them on top of each other.…
The important thing to remember here is, they have to have…the exact same column names, otherwise you'll get…a block diagonal data table for Employees All.…On the other hand, if I have two separate data sets…names and home, and I want to column bind them together,…I'll use multiple set statements, or you can think of it as…creating a column of set statements.…And each set statement should have its own data table.…
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.