This operator is used in logical expressions to test whether an item or variable is within a set of values or ranges. The item or variable can be numeric or alphanumeric. A range of values is separated by a colon, for example 1:5. Elements of a list of values or ranges are separated by commas, for example 1, 3:5, 7.
Example 1:
if RELATIONSHIP in 1:5 then
is the same as
if RELATIONSHIP >= 1 and RELATIONSHIP <= 5 then
Example 2:
if WORK in 1,3,5 then
is the same as
if WORK = 1 or WORK = 3 or WORK = 5 then
Example 3:
if X in 1:4, missing, notappl then
is the same as
if (X >= 1 and X <= 4) or X = missing or X = notappl then
Example 4:
if NAME in "A":"MZZ" then
is the same as
if NAME >= "A" and NAME <= "NZZ" then
See also: Has Operator