Create a Subset

Ribbon bar. Select the Data tab. In the Manage group, click Subset to display the Create a Subset dialog box.

Classic menus. On the Data menu, select Subset to display the Create a Subset dialog box.

Variables. Click the Variables button to display the Select Variables dialog box, which contains options to choose the variables from the current spreadsheet to be included in the subset.

Cases. Click the Cases button to display the Spreadsheet Case Selection Conditions dialog box, which contains options to create conditions to define the selection of cases to be considered for the sample. For more information about case selection conditions, see Case Selection Conditions Overview, Case Selection Conditions Syntax Summary, and Case Selection Conditions Examples.

Create new spreadsheet. Select this check box to create a new spreadsheet based on your selections in this dialog box.

Copy formatting to new spreadsheet. Select this check box to retain the cell format(s) of the original cases in the new subset(s).

OK. Click the OK button to generate a subset based on the active input and close the dialog box.

Cancel. Click the Cancel button to close the dialog box without generating a subset.