Merging More Than Two Data Sources

Using command syntax, you can merge more than two data files.

  • Use MATCH FILES to merge multiple files that don't contain key variables or multiple files already sorted on key variable values. See the topic MATCH FILES for more information.
  • Use STAR JOIN to merge multiple files where there is one case data file and multiple table lookup files. Files do not need to be sorted in order of key variable values, and each table lookup file can use a different key variable. See the topic STAR JOIN for more information.