The following
table shows some functions that are used only in GTL. As with other
functions, these must be enclosed within an EVAL. In all these functions,
column can be either the name of a column in
the input data set or a dynamic / macro variable that resolves to
such a column.
|
|
|
|
|
returns the case-sensitive
name of the column.
|
|
|
returns the case-sensitive
label of the column. If no
label is defined for the column, the case-sensitive name of the column is returned.
|
|
|
returns 1 if specified item exists, 0 otherwise. If item is a column, it tests for the presence of
the column in the input data set. If item is a dynamic / macro variable, it tests whether there has been a
run-time initialization of the variable.
|
EXPAND( numeric-column, freq-column)
|
creates a new column
as ( numeric-column * frequency-column)
|
ASORT( column,
RETAIN=ALL)
|
sorts all columns of
the data object by the values of column in ascending order. SORT is an alias for ASORT.
Warning: if the RETAIN=ALL argument is not included, column alone is sorted, not the other columns, causing rowwise information
to be lost.
|
DSORT( column,
RETAIN=ALL)
|
sorts all columns of
the data object by the values of column in descending order.
Warning: if the RETAIN=ALL argument is not included, column alone is sorted, not the other columns, causing rowwise information
to be lost.
|
|
|
returns a column that contains the ordinal position of
each observation in the input data set (similar to an OBS column)
|
/* arrange bars in descending order of response values */
barchartparm x=region y=eval(dsort(amount,retain=all));
/* label outliers with their position in the data set */
/* it does not matter which column is used for NUMERATE() */
boxplot x=age y=weight / datalabel=eval(numerate(age));
/* add information about the column being processed,
which is passed by a dynamic */
entrytitle "Distribution for " eval(colname(DYNVAR));