Merge Merge datasets will help user join 2 datasets together. User need to specify one or more variables in the active dataset and in the selected target dataset that you want the join to be performed on.
Merge Options
inner_join: return all rows from x where there are matching values in y, and all columns from x and y. If there are multiple matches between x and y, all combination of the matches are returned.
left_join: return all rows from x, and all columns from x and y. Rows in x with no match in y will have NA values in the new columns. If there are multiple matches between x and y, all combinations of the matches are returned.
right_join: return all rows from y, and all columns from x and y. Rows in y with no match in x will have NA values in the new columns. If there are multiple matches between x and y, all combinations of the matches are returned.
full_join: return all rows and all columns from both x and y. Where there are not matching values, returns NA for the one missing.
semi_join: Keep all rows in first dataset with a match in second dataset
anti_join: Keep all rows in first dataset without a match in second dataset
This section id dataset tab has 4 options that are explained in following sections.
Last modified: 01 October 2025