This menu allows you to restrict the rows displayed and to be included within
any analysis by using factor levels or labels.
Restrictions can be applied to Matrices and Tables, although these structures
cannot be restricted within the GenStat server. If the Subset on Update option
is selected, then a reduced matrix with restricted rows removed will be
send to the server. Otherwise the restrictions within the spreadsheet will
be used for display purposes only and the full data will always be used
within the server.
Factor
The factor by which the spreadsheet is restricted. A drop down list of factors
in the spreadsheet is available for selection.
Selected Levels
The levels that are to be included or excluded from the available rows. A
single level can be selected by clicking on it with the mouse. Multiple levels
can be selected by holding down the Control key while selecting. Holding the
Shift key down while selecting levels selects all levels between the selected
item and the last selected item.
Restriction Type
Units (rows) matching the selection criteria can be either included or excluded
from the data displayed in the spreadsheet and used in subsequent calculations.
Existing Restrictions
If this spreadsheet is currently restricted, this controls how the
new restriction is added to the current restriction.
| Combine with New | - Combine the old restriction with the new one. |
| Replace with New | - Replace the old restriction with the new one. |
OK
Restrict the spreadsheet as required, and close the dialog.
Apply
Restrict the spreadsheet as required and leave the dialog
open to apply further restrictions.
Remove All
Remove any existing restriction from the spreadsheet.
Cancel
Close the dialog without making any further restrictions.
See Also
The RESTRICT directive can be used to filter columns
within the command language. The .IN. comparison is useful when restricting to
groups of a factor:
RESTRICT X; CONDITION = FACT .IN. !(1,4,7)
RESTRICT X; CONDITION = FACT .IN. !T('A','D','F')