Setting Options

Option Name
Description
Output Order
Sort order
specifies whether to display the output data in ascending or descending order.
Maintain original order within groups
maintains the order of the observations relative to each other within a BY group.
Duplicate Records
Keep all records
keeps all of the records that are in the output table, including all duplicate records.
Keep only the first record for each ‘Sort by’ group
eliminates any duplicate observations that have the same values for the Sort by group.
Results
Sort in place
specifies to sort the existing data set in place. If you select this option, the Sort task keeps any variables that you assigned to the Columns to drop role and keeps all duplicate records.
Output data set
specifies the name of the output data set.