Processes | Utilities | Transform Expression

Transform Expression
Use this field to specify appropriate SAS syntax for transforming the variables .
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.
To Specify a Transform Expression:
Enter a valid expression into the Transform Expression field.