Transforming Columns from the Input Data Set

To run the Transform Data task, you must select an input data source. To filter the input data source, click Filter Icon.
Using the Transform Data task, you can transform up to three columns from your input data set. You must assign a column to the Variable 1 role.
Role
Description
Transform n
Variable n
specifies the variable to transform.
Transform
specifies the transform to use. Here are the available transforms:
  • Inverse square
  • Inverse
  • Inverse square root
  • Natural log
  • Square root
  • Square
To create your own transformation, select Specify custom transformation. An example of a custom transformation is Salary*1000.
Output Data Set
Show output data
specifies whether to display the output data set on the Results tab. You can choose to display all of the data or a subset of the output data. The task always creates an output data set that appears on the Output Data tab. The output data is also saved as a SAS data set.