Select menu: Data | Set Calculations
Performs Boolean arithmetic on sets on the contents of vectors. The expression is displayed at the top of the window and can be constructed step by step by combining data structures and operators. You can use brackets to control the order of evaluation when required. You can also type directly into the expression field.
- After you have imported your data, from the menu select
Data | Set Calculations.
Available data
Lists data structures of the types requested. Double-click a name to copy it into the expression being formed. You can control which structures are displayed in the Available data field by selecting the data type check boxes.
Save result in
Specifies a data structure to contain the result of the expression. If this structure already exists you should ensure it is the appropriate type to store the result.
Operators:
Operator | Name | Description |
.and. | Intersection | Represents the Boolean “and” operation: for example x.AND.y produces a vector that contains any item that is in both x and y |
.or. | Union | Represents the Boolean “or” operation: for example x.OR.y produces a vector that contains any item that is in either x or y |
.eor. | exclusive or | Represents “exclusive or”: for example x.EOR.y produces a vector that contains any item that is in either x or y but not both of them |
− | but not | Represents “not”, for example x-y produces a vectors that contains the items that are in x but not in y |
Options
Lets you select the options and output.
Display resulting set in spreadsheet
The saved set will be displayed within a new spreadsheet window.
Display resulting set in Output Window
The saved set will be displayed within the Output window.
Tolerance for numerical comparisons
This defines the tolerance to be used when comparing numbers.
Compare factor using
Specifies whether the values of factors are compared using their levels or their labels.
See also
- SETCALCULATE directive