Sorting, Merging and Setting datasets
In this training module we will cover the following topics:
- Sorting datasets with PROC SORT
- How to SET datasets together
- How to MERGE datasets together
- When to SET or MERGE
- BY variables
In this module we will learn how to SET and MERGE datasets together, the difference between setting and merging, we will also look at PROC SORT and learn how to sort our datasets in order to merge them correctly. We also look at BY variables and why it is important to have a unique set of BY variables when merging datasets.