| Index | Tutorial | Glossary |
The Select Records box allows you to enter a logical expression that specifies a subset of observations
for analysis. Both numeric and string variables and values can be used in the expression.
The string values must be enclosed in single quotation marks ''. You may use parentheses to define
the priority of operations (see Logical Operators) in the expression.
To enter a variable name in the Select Records box, choose the variable in the Variables
box and click on the
button. The variable
name will appear in the Select Records box.
A simple way of entering an expression in the Select Records box is also described in the By Category help.
VariableName1 LogicalOperator Value1 [LogicalOperator VariableName2 ...]
Note: Square brackets in syntax diagrams denote optional elements.
| Expression | Explanation |
| Industry=='Transport' | Reduces dataset to firms only in transportation industry |
| c203a<=50 | Keeps only firms, which are less than or 50% owned by domestic private sector (c203a is a percentage owned in a firm by domestic private sector) |
| (industry=='Construction')&(size=='Small') | Selects small construction firms |
| (industry=='Textiles'|industry=='Garments')&(size=='Micro'|size=='Small') | Selects micro and small enterprises in garments and textile industry |
| industry=='Textiles'|industry=='Garments'& size=='Micro'|size=='Small' | Selects all enterprises in textile industry and micro enterprises in garments as well as all small firms |