Restrict Units by Value

This menu allows you to apply a restriction to the spreadsheet, based on values of the current column. The menu title bar indicates which column is to be used for the restriction.

Units are selected according to whether their values meet the specified criterion; the test is based on numerical values so can only be used for variate columns or factors displayed using their levels.

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.

Choose Units With

You can select whether the restriction is based on units the comparison from the drop down list, Equal to, Less than, or Greater than the specified values. Multiple values can be entered into the edit box in the equals case, and they should be separated with commas. For a factor, you can enter the ordinal values as the values to restrict by. You can either type the values in directly or select them automatically from a list by clicking in the edit filed and pressing the up cursor key.

Restriction Type

Units that meet the specified conditions can be either included or excluded from the restriction.

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.

Remove All

Remove all existing restrictions from the spreadsheet.

Use Factor

Whether to compare the factor ordinals (i.e. 1,2,3...) or levels with the values entered in the Choose Units edit boxes.

Hints