Parameters | Utilities | Transform Expression

• Specify the transformation as a function of varb[i] and varm[i]. The former represents the variables from the Base Input SAS Data Set, and the latter represents the corresponding variables from the Merge Input SAS Data Set. For example, type varb[i] = varb[i] - varm[i]; in this field to subtract the merge variables from the base variables.

• Additional SAS statements can be used to modify the resulting data set. For example, typing varb[i] = varb[i] - varm[i]; drop var3 var5; subtracts the merge variables from the base variables and drops var3 and var5 from the output data set. Note: It is assumed here that var3 and var5 exist in either the base or merge data sets. The transformation can include any SAS function.

Enter a valid expression into the Transform Expression field.