Subset by Logic

Returns a subset of the dataset. User can specify the columns/variables that user wants in the smaller dataset. User can also specify selection criteria to be applied against each row of the dataframe.

Save results to a new dataset: Specify a new dataset to store the subsetted data

Overwrite existing dataset: This saves the subsetted dataset to the existing dataset name

Display results in the output window: This prints the subsetted dataset in the output window only. The subsetted dataset is not saved in a dataset.

Selected distinct cases: This removes duplicates from the subsetted dataset. All variables have to be the same to be considered a duplicate.

Remove unused factor levels: This deletes factor levels that were excluded by the subset (i.e. no longer appear in the data).

Select variables to include in subsetted dataset: This allows the user to select specific columns they want to include in the dataset. If any are specified, then only the specified variables will show up in the subsetted dataset. If no variables are specified, then all variables will be kept.

Enter subsetting criteria: Specify variable logic that will be used to filter the rows of the dataset.