I have a table with a lot of numeric value fields, all of which need to be banded up into ranges (string). I have had a look at IntervalMatch but I'm not certain it is what I want - at least I have not seen a useful example of my scenario.
As an example:
load * inline [
I now want to apply a banding to each of these fields.
For A I want the banding to be:
If >0 <= 5 then Low
If >5 <=20 then Med
If >20 then High
For the others:
IF >0 <=10 Low
IF >10 High
This is a simple example of what I'm trying to do, but to put it in context I have a table with about 50 fields I need to band and don't want to have to write IF THEN ELSE code for each one.
Creates a classification of expressions. The bin width is determined by the number set as interval. The result is shown as a<=x<b, where a and b are the upper and lower limits of the bin. The x can be replaced by an arbitrary string stated in label. 0 is normally the default starting point of the classification. This can be changed by adding an offset.
class( var,10 ) with var = 23 returns '20<=x<30'
class( var,5,'value' ) with var = 23 returns '20<= value <25'
class( var,10,'x',5 ) with var = 23 returns '15<=x<25'