4.90 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 or numeric values in a specified column that is present in both of two pre-existing data sets. The user may specify which columns of the second data set to take and which to leave. The user may also transfer parameter and array data.
• synopsis:

  sddsxref [-pipe[=input][,output]] [input] [xRefFile] [output] [-equate=columnName | -match=columnName] [-reuse[=rows][,page]] [-fillIn] [-take=columnName,...] [-leave=columnName,...] [-transfer={parameter | array},name[,name...] [-ifis={column | parameter | array},name[,name...] [-ifnot={column | parameter | array},name[,name...]

• files: input is the data set to which data is being added. xRefFile is the data set from which data is being taken. Warning: if output is not given and if -pipe=out is not specified, input is overwritten. For pipe input, the first file listed is taken to be xRefFile. For pipe input and output, the only file listed is xRefFile.
• switches:
  • -equate=columnName, -match=columnName— These options specify the name of a column that exists in both input and xRefFile. For match, the column must contain string data, while for the equate the column must contain numeric data. For each row in input, sddsxref searches xRefFile to find the first row for which the match column is identical or the equate column is equal, as appropriate. This row is the one from which any data is taken for addition to the row in input. If neither of these options is given, then rows are taken sequentially from xRefFile for each row of input.
  • -reuse[=rows][,page] — By default, each row from xRefFile is matched to one row in input. If -reuse=rows is given, each row from xRefFile may be matched to any number of rows in input. Also by default, each page of input is matched with the corresponding page of xRefFile. If -reuse=page is given, then each page of input is matched anew to the first page of xRefFile. The two qualifiers may be given together.
  • -fillIn — Normally if there is no match in xRefFile for a row in input, that row will not appear in output. If -fillIn is given, the row will appear, but the values for the columns that are being transferred from xRefFile will be filled with zeros and empty strings, as appropriate.
  • -take=columnName,..., -leave=columnName,...— These options specify which columns of xRefFile to extract from a matching or equal row of xRefFile for addition to a row of input. Wildcards may be given in the column names. By default, all columns not in input are taken. If take is employed, only the named columns will be taken. In either case, no column specified under leave will be taken. -leave=* causes no columns to be taken.
  • -transfer={parameter | array},name[,name...] — This option, which may be given multiple times, specifies the names of parameters and arrays to be transfered. Wildcards are not presently supported in this option.
  • -ifis={column | parameter | array},name[,name...], -ifnot={column | parameter | array},name[,name...] — These options allow conditional execution. If any column that is named under a ifis option is not present, execution aborts. If any column that is named under a ifnot option is present, execution aborts.
• sddsmxref — sddsmxref is a variant of sddsxref that permits multiple -match and -equate options for more sophisticated cross-referencing. In other respects, the program is used just like sddsmxref. sddsxref is much faster, however, for single-criterion matching or equating.
• see also:
  • Data for Examples
  • sddsselect
• author: M. Borland, L. Emery, H. Shang, R. Soliday ANL/APS.