g_pkg(G;S;O;K;X)

Returns a package value for each group, in the specified order. (Available as of version 15.21)

Function type

Vector only

Syntax

g_pkg(G;S;O;K;X)

Input

Argument Type Description
G any A space- or comma-separated list of column names

Rows are in the same group if their values for all of the columns listed in G are the same.

If G is omitted, all rows are considered to be in the same group.

If any of the columns listed in G contain N/A, the N/A value is considered a valid grouping value.

S integer The name of a column in which every row evaluates to a 1 or 0, which determines whether or not that row is selected to be included in the calculation

If S is omitted, all rows will be considered by the function (subject to any prior row selections).

If any of the values in S are neither 1 nor 0, an error is returned.

O integer A space- or comma-separated list of column names that determine the row order within a particular group

If O is omitted, the order is the current display order of the table.

If any of the values in O are N/A, an error is returned.

K list-value The keys to the package, which must yield valid key names
X any simple type A column name

The values corresponding to each key in K

Return Value

For every row in each group defined by G and ordered by O (and for those rows where S=1, if specified), g_pkg returns a package value for each group specified by G, where the keys are specified by K and the values are specified by X.

If no rows have valid (non-N/A) values for X, the result is N/A.

Note: An empty string is not considered to be an N/A for the purposes of g_ functions.