AND

Purpose

Updates the current selection (as defined with SELECT command) with additional selection criteria as specified in this command.  Records will be used only if they were included in the selection in effect at the time with command was given and if the condition indicated in this command is true.

Syntax

AND added_logical_expression @

Arguments and Subcommands

added_logical expression

Either a simple logical expression or a series of simple logical expressions connected by the logical operators AND or OR which defines a subset of records to be used in the subsequent analyses. A simple logical expression has the form vname rop #, where vname is a variable name, rop is one of the standard relational operators (EQ, NE, LT, LE, GT, GE), and # must be a number. Alternative forms for the relational operators are: ==,  < , <=,  >, >= , while & and  may be used in place of AND and OR, respectively. Parentheses are not allowed in this command.

Remarks

When the AND command is issued, the value of the internal selection indicator variable (%SEL) is updated to 1 for all records in the current selection (%SEL = 1) for which the additional condition expressed in this command is true.   Records for which the condition expressed in this command is not true are excluded from the current selection (that is, %SEL is set to 0).