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.

•

Please refer to Base SAS documentation or seek assistance from a SAS programmer if you are unfamiliar with SAS syntax.

To Specify a Transform Expression:

8

Enter a valid expression into the Transform Expression field.