Announcement Icon Online training class for Clinical R programming batch starts on Monday, 02Feb2026. Click here for details.

Appending datasets

Lesson Description
-
  • Sometimes, we want to work with the concept of "Appending datasets" in a clear, repeatable way.
  • This lesson walks through a simple example and shows the key steps.
  • We will see one approach on how we can do it in SAS and R.
data MALES;
 infile datalines dlm='|' dsd missover;
input Name : $8. Sex : $1. Age : best32. Height : best32. Weight : best32.;
label ;
 format ;
 datalines4;
Alfred|M|14|69|112.5
Henry|M|14|63.5|102.5
James|M|12|57.3|83
;;;;
 run;

data FEMALES;
 infile datalines dlm='|' dsd missover;
input Name : $8. Sex : $1. Age : best32. Height : best32. Weight : best32.;
label ;
 format ;
 datalines4;
Alice|F|13|56.5|84
Barbara|F|13|65.3|98
Carol|F|14|62.8|102.5
;;;;
 run;

data class;
     set males females;
 run;
  • The provided SAS code combines two datasets, "males" and "females," into a single dataset named "class."
  • The data statement is used to specify the creation of a new dataset named "class."
  • The set statement is used to read data from the "males" dataset and the "females" dataset into the "class" dataset. By using the set statement with multiple dataset names separated by spaces, the observations from both datasets are appended sequentially in the order they are listed.
  • The run; statement marks the end of the data step and executes the creation of the "class" dataset.
  • This SAS code snippet demonstrates how to combine two datasets, "males" and "females," into a single dataset named "class." By using the set statement, the observations from both datasets are merged together to create a consolidated dataset containing data for both males and females.
males <- tribble( ~Name,~Sex,~Age,~Height,~Weight,
"Alfred","M",14,69,112.5,
"Henry","M",14,63.5,102.5,
"James","M",12,57.3,83,
)

 

females <- tribble( ~Name,~Sex,~Age,~Height,~Weight,
"Alice","F",13,56.5,84,
"Barbara","F",13,65.3,98,
"Carol","F",14,62.8,102.5, 
)

class <- bind_rows(males,females)
  • This R Tidyverse code snippet demonstrates how to combine two data frames, "males" and "females," into a single data frame named "class" using the bind_rows function from the dplyr package. The bind_rows function vertically stacks the rows from each data frame, resulting in a consolidated data frame.
  • In the code snippet, the bind_rows function is applied to the "males" and "females" data frames using the syntax bind_rows(males, females). This concatenates the rows from both data frames, preserving their column structure.
  • By using the bind_rows function, the observations from both "males" and "females" data frames are combined vertically, creating a single data frame that contains data for both males and females.
  • This technique offers flexibility in data management and is useful when you need to merge datasets with the same variables but different observations. It allows you to consolidate data from multiple sources into a single dataset for further analysis or modeling.
males <- data.frame(
  Name = c("Alfred", "Henry", "James"),
  Sex = c("M", "M", "M"),
  Age = c(14, 14, 12),
  Height = c(69, 63.5, 57.3),
  Weight = c(112.5, 102.5, 83)
  , stringsAsFactors = FALSE
)

females <- data.frame(
  Name = c("Alice", "Barbara", "Carol"),
  Sex = c("F", "F", "F"),
  Age = c(13, 13, 14),
  Height = c(56.5, 65.3, 62.8),
  Weight = c(84, 98, 102.5)
  , stringsAsFactors = FALSE
)

class <- rbind(males, females)
  • rbind() stacks rows from two data frames with matching columns.