User's Manual

156
Chapter 8
Function
Result
Description
@GLOBAL_MIN(FIELD)
Number
Returns the mini mum value for FIELD over the whole
data set, as previously ge nerated by a Set Globals node.
FIELD must be the name of a n umeric field. If the
correspon ding global value has not been set, an error
occurs.
@GLOBAL_SDEV(FIELD)
Number
Returns the standar d devi at i on of values for FIELD over
the whole data set, as previously generated by a Set
Globals node. FIELD must be the name of a numeric
field. If the corresponding global value has not been set,
an error o ccurs.
@GLOBAL_MEAN(FIELD)
Number
Returns the mean average of values for FIELD over the
whole data set, as previously generated by a Set G l obals
node. FIELD must be the name of a numeric fiel d. If
the corresponding global value has not been set, an error
occurs.
@GLOBAL_SUM(FIELD)
Number
Returns the sum of values for FIELD over t he whole
data set, as previously ge nerated by a Set Globals node.
FIELD must be the name of a n umeric field. If the
correspon ding global value has not been set, an error
occurs.
Functions Handling Blanks and Null Values
Using CLEM, you can specify that c ertain values in a field are to be regarded as “blanks,” or
missing values. The following functions work with blanks.
Note: @ functions cannot be called from scripts .
Function
Result
Description
@BLANK(FIELD)
Boolean
Returns true for all records whose values are blank
according to the blank-handling rules set in an
upstream Type node or source no de (Types tab).
Note that this function cannot be called from a script.
@LAST_NON_BLANK(FIELD)
Any
Returns the last value for FIELD that was n ot blank,
as define
d in an upstream source or Type node.
If there are no nonblank valu es for FIELD in the
records read so far, $null$ is returned. Note that
blank va
lues, als o called user-missing values, can be
defined separately for each field.
@NULL(FIELD)
Boolean
Returns true if the value of FIELD is the
system-missing $null$. Returns false f or all other
values, including user-defined blanks. If you
want to check for both, use @BLANK(FIELD)and
@NULL(FIELD).
undef
Any
Used generally in CLEM to enter a $null$ value—for
example, to fill blan k values with nulls in the Filler
node.
Blank fields may be “filled in” with the Filler node. In b oth Filler and De r ive nodes (multiple
mode only), the special CLEM fun ction @FIELD refers to the current field(s) being examined.