SPSS Aggregate Functions

These are the functions that can be used on the AGGREGATE command.

General Syntax

The number of target variables must match the number of source variables.

Generally, missing values are ignored. String values will never be considered missing.

Generally, a missing value are only returned if all values are missing. The exception is SD, which requires two non-missing values.

PSPP extends this syntax with handling for user missing values. To include this type of missing values on any aggregate function, append the function name with a period. For example, SUM..

Variable Metadata

Only the MAX, MIN, FIRST, and LAST functions copy the metadata of a source variable.

All other created variables lack labels and have a format pre-determined by the function.

• F5.3 for functions FGT, FIN, FLT, and FOUT

• F5.1 for functions PGT, PIN, PLT, and POUT

• F7.0 for functions NU and NUMISS

• F8.2 for functions CGT, CIN, CLT, COUT, MEAN, MEDIAN, SD, SUM, N, and NMISS

  • If weighting is not enabled, N and NMISS create variables with a format of F7.0. In other words, N and NMISS match the behavior of NU and NUMISS when weighting is disabled.

To specify a variable label for a new target variable, list the label in quotes following the new variable name.

Value labels cannot be specified.

Variable formats cannot be specified.

Cgt

The CGT function returns a count of cases with a value greater than a specified second argument for each source variable.

Note: unsupported in SPSS version 21 or earlier.

Cin

The CIN function returns a count of cases with a value within some range for each source variable.

The range is specified by the second and third arguments, and it is inclusive of those two values as well. If the second argument is greater than the third, they are automatically reversed.

If the second and third arguments are equal, CIN returns a count of cases with a value equal to the second argument.

Note: unsupported in SPSS version 21 or earlier.

Clt

The CLT function returns a count of cases with a value lesser than a specified second argument for each source variable.

Note: unsupported in SPSS version 21 or earlier.

Cout

The COUT function returns a count of cases with a value outside of some range for each source variable.

The range is specified by the second and third arguments, and it is inclusive of those two values as well. If the second argument is greater than the third, they are automatically reversed.

If the second and third arguments are equal, COUT returns a count of cases with a value not equal to the second argument.

COUT is complementary of CIN.

Note: unsupported in SPSS version 21 or earlier.

Fgt

The FGT function returns a fraction of cases with a value greater than a specified second argument for each source variable.

Fin

The FIN function returns a fraction of cases with a value within some range for each source variable.

The range is specified by the second and third arguments, and it is inclusive of those two values as well. If the second argument is greater than the third, they are automatically reversed.

If the second and third arguments are equal, FIN returns a fraction of cases with a value equal to the second argument.

First

The FIRST function returns the first non-missing value for each source variable. String values will never be considered missing.

Flt

The FLT function returns a fraction of cases with a value lesser than a specified second argument for each source variable.

Fout

The FOUT function returns a percentage of cases with a value outside of some range for each source variable.

The range is specified by the second and third arguments, and it is inclusive of those two values as well. If the second argument is greater than the third, they are automatically reversed.

If the second and third arguments are equal, FOUT returns a fraction of cases with a value not equal to the second argument.

FOUT is complementary of FIN.

Last

The LAST function returns the lastnon-missing value for each source variable. String values will never be considered missing.

Max

The MAX function returns a maximum non-missing value for each source variable.

String values are evaluated according to codepoints. For example, "Z" has a higher codepoint than "A", so between the two values the maximum value is "Z". String values will never be considered missing.

Mean

The MEAN function returns a mean across cases for each source variable.

Note: only valid for numeric variables.

Median

The MEDIAN function returns a median value for each source variable.

Note: only valid for numeric variables.

Min

The MIN function returns a minimum non-missing value for each source variable.

String values are evaluated according to codepoints. For example, "A" has a lower codepoint than "Z", so between the two values the minimum value is "A". String values will never be considered missing.

N

The N function returns a weighted number of cases in a break group.

If specified with a variable list argument, the N function returns a weighted number of cases with non-missing values for each source variable. String values will never be considered missing.

Nmiss

The NMISS function returns a weighted number of cases with missing values for each source variable. String values will never be considered missing.

Nu

The NU function returns an unweighted number of cases in a break group.

If specified with a variable list argument, the NU function returns an unweighted number of cases with non-missing values for each source variable. String values will never be considered missing.

Numiss

The NUMISS function returns an unweighted number of cases with missing values for each source variable. String values will never be considered missing.

Pgt

The PGT function returns a percentage of cases with a value greater than a specified second argument for each source variable.

Pin

The PIN function returns a percentage of cases with a value within some range for each source variable.

The range is specified by the second and third arguments, and it is inclusive of those two values as well. If the second argument is greater than the third, they are automatically reversed.

If the second and third arguments are equal, PIN returns a percentage of cases with a value equal to the second argument.

Plt

The PLT function returns a percentage of cases with a value lesser than a specified second argument for each source variable.

Pout

The POUT function returns a percentage of cases with a value outside of some range for each source variable.

The range is specified by the second and third arguments, and it is inclusive of those two values as well. If the second argument is greater than the third, they are automatically reversed.

If the second and third arguments are equal, POUT returns a percentage of cases with a value not equal to the second argument.

POUT is complementary of PIN.

SD

The SD function returns a standard deviation across cases for each source variable.

Note: only valid for numeric variables.

Sum

The SUM function returns a sum across cases for each source variable.

Note: only valid for numeric variables.

CategoryRicottone