Select menu: Spread | Restrict/Filter | To Groups (Factor Level)
Use factor levels or labels to restrict the rows displayed and to be included within an analysis.
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 sent 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.
- From the menu select Spread | Restrict/Filter | To Groups (Factor Level).
The factor by which the spreadsheet is restricted. A dropdown list of factors in the spreadsheet is available for selection.
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 Ctrl key while selecting. Holding the Shift key down while selecting levels selects all levels between the selected item and the last selected item.
Units (rows) matching the selection criteria can be either included or excluded from the data displayed in the spreadsheet and used in subsequent calculations.
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.|
- Spreadsheet Restrict/Filter Menu for other methods of defining restrictions.
- Restrict using Expression
- Restrict Units by Value
- Restrict/Filter Duplicate Rows
- Restrict/Filter Random Rows
- Save Restriction/Filter
- Edit Factor Levels and Labels
- Spreadsheet Factor Menu
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’)