Previous: sddssort
Up: Manual Pages
Next:
Previous Page: sddssort
Next Page:

sddsxref

• name:
  sddsxref
• description:
  sddsxref creates a new data set by adding selected rows from one data set to another data set. The rows are selected by matching the string and numeric values in specified columns that are shared in the two pre-existing data sets. The user may specify which columns of the second data set to take and which to leave.
• synopsis:
  sddsxref input1 input2 [ output] [-equate= column-name,...] [-take= column-name,...] [-leave= column-name,...] [-match= column-name,...]
• files: input1 is the data set to which data is being added. input2 is the data set from which data is being taken. If given, the new data set is placed in output; otherwise, input1 is overwritten.
• options:
  • match, equate - These options specify the names of columns that exist in both input1 and input2. The match columns must contain string data, while the equate columns must contain numeric data. For each row in input1, sddsxref searches input2 to find the first row for which all the match columns are identical (as judged by strcmp) and for which all the equate columns are numerically equal. This row is the one from which any data is taken for addition to the row in input1.
  • take, leave - These options specify which columns of input2 to extract from a selected row for addition to a row of input1. By default, all columns not in input1 are taken. If take is employed, only the named columns will be taken. In either case, no column specified under leave will be taken.