AGGREGATE function

Description

AGGREGATE(statistic[,allowmissing],variable,group[,filter]) calculates the specified statistic of a variable in the group a case belongs to.

statistic: must be COUNT, MEAN, MEDIAN, MIN, MAX, PERCENTILE, SEM, STDEV, VAR, SUM, SUMSQ, GEOMEAN or HARMEAN.
When PERCENTILE is specified, the function takes one more parameter "centile", which is a value between 0 and 100. See the example below.
allowmissing: an optional parameter, if TRUE then the function will also return a value for a case in which data are missing for the continuous variable.
variable: a continuous variable for which to calculate the statistic of interest
group: a categorical grouping variable (e.g. gender)
filter: an optional filter on the continuous variable.

AGGREGATE function

Column AG1	AGGREGATE(MEAN,age,gender) returns the MEAN age in the group defined by the variable gender.
Column AG2	AGGREGATE(MEAN,TRUE,age,gender) returns the MEAN age in the group defined by the variable gender, even for a case in which the age value is missing.
Column AG3	AGGREGATE(MEAN,age,gender,success=1) returns the MEAN age of cases where success=1, in the group defined by the variable gender.
Column AG4	AGGREGATE(PERCENTILE,TRUE,75,age,gender) returns the 75th percentile of age in the group defined by the variable gender, even for a case in which the age value is missing.
Column AG5	AGGREGATE(PERCENTILE,75,age,gender) returns the 75th percentile of age in the group defined by the variable gender, but not for cases in which the age value is missing.

Note: we have used Auto-values in this example.