Merge Key Variables

Use this field to specify the variables from the Primary Input SAS Data Set by which to merge data from the Secondary Input SAS Data Set .

Important : The same variables must exist in the Secondary Input SAS Data Set . Only observations that have the same value(s) of the Merge Key Variables in both the primary and secondary input SAS data sets are carried through in the analysis.

To Specify One or More Merge Key Variables:

Specify the Primary Input SAS Data Set .

All of the variables in the specified input data set are displayed in the Available Variables field.

Examine the list of available variables.

Highlight one or more variables whose values are to be used for merging the primary and secondary input SAS data sets. To highlight multiple variables at once, hold down Ctrl while left-clicking on them.

Click to add the highlighted variable(s) to the Merge Key Variables field, as shown below: