1. Home
  2. Restrict using Factor Levels

Restrict using Factor Levels

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.

  1. 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.

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 Ctrl 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.

Action buttons

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:


Updated on March 14, 2019

Was this article helpful?