Band
Calculates categories (called bands) for a numeric variable and returns the appropriate category for a specified value in the numeric variable.
Syntax
Band(<value>, <minimum>, <size> [, <count>])
Parameters
<value>
Type: None
Variant value of type Long or Double.
<minimum>
Type: Double
Double value specifying the (inclusive) lower boundary of the first band.
<size>
Type: Double
Double value specifying the size of each band. If Size <= 0.0, an empty categorical value is returned.
<count>
Type: Long
(Optional.) The number of bands to define. If omitted or < 0, the number of bands is unlimited.
(return)
Type: Categorical
Categorical value containing the number of the band into which the value falls, if it is in the specified range; an empty categorical value otherwise.
Notes
The first band is numbered 1.
The numeric value is considered to fall into band N if
Val < (Min + N * Size) and
Val >= (Min + (N - 1) * Size) and
N <= Count (if given)
If <value> is NULL, the return value is an empty Categorical value ({}).
Examples
|
Function call
|
Val
|
Result
|
|
Band(Val, 1.0, 5.0, 10)
|
30
|
{6}
|
|
Band(Val, 1.0, 5.0, 10)
|
300
|
{}
|
|
Band(Val, 1.0, 5.0, 100)
|
300
|
{60}
|
|
Band(Val, 1.0, 50, 10)
|
300
|
{6}
|
The following example could be used to create a derived categorical case data variable from the visits numeric variable, which records the number of times respondents have previously visited the museum. This example would create categories corresponding to 1-5 visits, 6-10 visits, 11-15 visits, and so on.
visits.Band(1, 5)
See also