Spreadsheet Case Selection Conditions - Selections Tab

Select the Selections tab of the Spreadsheet Case Selection Conditions dialog box to access options to create selection conditions that select a subset of cases of the current spreadsheet. The case selection conditions you create can be saved for future use.
Note: Selection Conditions and Graph Auto Updating. Graphs created with the Update from Spreadsheet option (on the Options 1 tab of the graph specifications dialog box) enabled are updated (either automatically or manually) to reflect spreadsheet data changes. Selection conditions are treated as a change in the data.

Graphs created through the Graphs menu default to the Use current Spreadsheet selection conditions option available in the Analysis/Graph Case Selection Conditions dialog box. When this option is used in conjunction with the Update from Spreadsheet option, the graph update includes the current spreadsheet selection conditions at the time of the update.

The graph analyses also allow the Use selection conditions for this analysis/Graph only option to be selected in the Analysis/Graph Case Selection Conditions dialog box. When this option is used in conjunction with the Update from Spreadsheet option, the selection conditions specified during the analysis are maintained during a graph update, overriding any spreadsheet selection condition changes.

Option Description
Enable Selection Conditions Select the Enable Selection Conditions check box to activate and/or create case selection conditions.
Review Variables Click this button to view a complete list of the variables in the spreadsheet.
Clear All Click the Clear All button to clear all boxes on this tab.
Include cases Use the options in the Include cases group box to specify which cases to include in the analysis.
All Select the All option button to include all cases in the analysis.
Specific, selected by Select the Specific, selected by option button to include cases in the analysis that satisfy the conditions in the Expression box or the or case number box. Note: It is possible to enter conditions in both the Expression and the or case number boxes, and when both boxes contain entries, cases that satisfy either condition are included. Example: in the example data set Adstudy.sta, if you use the include expression Gender='Male' and set the or case number field to 1-25, cases 1-25 will be selected, as well as any other cases where the value in the Gender column is 'Male'
Expression Use the Expression box to enter new or edit existing case selection condition expressions. Refer to the Case Selection Conditions Syntax Summary for information on how to properly specify case selection expressions, or use the Functions option, described next.
Functions Click the Functions button to display the Function Browser, which will assist you to enter expressions for including cases.
or case number Use the or case number box to include a specific subset of cases in your case selection conditions. You can enter case numbers and/or a range of case numbers separated my commas.
Exclude cases (from the set of cases defined in the 'Include cases' section) Use the options in the Exclude cases group box to exclude cases from the analyses that satisfy the conditions in the By expression or the or case number boxes. Note: It is possible to enter conditions in both the By expression and the or case number boxes, and when both boxes contain entries, cases that satisfy either condition are excluded. See the example above in the Specific, selected by option description.
By expression Use the By expression box to enter new or edit existing case selection condition expressions. Refer to the Case Selection Conditions Syntax Summary for information on how to properly specify case selection expressions, or use the Functions option, described next.
Functions Click the Functions button to display the Function Browser, which will assist you to enter expressions for excluding cases.
or case number Use the or case number box to ensure that the case selection conditions are not applied to a specific subset of cases. You can enter case numbers and/or a range of case numbers separated by commas.