|
Size: 8233
Comment:
|
← Revision 14 as of 2024-01-02 17:05:51 ⇥
Size: 5716
Comment: PSPP 2.0 update
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 3: | Line 3: |
| These are the functions that can be used on the [[SPSS/AggregatingData#Aggregate|AGGREGATE command]]. | The [[SPSS/Aggregate|AGGREGATE]] command creates variables using a mini-programming language that is largely characterized by the below functions. |
| Line 15: | Line 15: |
| Generally, missing values are ignored. String values will never be considered missing. | Generally, missing values are ignored. [[SPSS/DataTypes#Strings|Strings]] will never be considered missing. |
| Line 47: | Line 47: |
| == 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. ---- |
== Functions == |
| Line 57: | Line 51: |
| == Cin == | === Count functions === |
| Line 59: | Line 53: |
| The '''`CIN`''' function returns a count of cases with a value within some range for each source variable. | The '''`CGT`''' and '''`CLT`''' functions returns a count of cases with a value greater/less than a second argument. |
| Line 61: | Line 55: |
| 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. | The '''`CIN`''' function returns a count of cases within an inclusive range defined by the second and third arguments. If the second argument is greater than the third, they are automatically reversed. If they are equal, `CIN` operates as an equality. |
| Line 63: | Line 57: |
| If the second and third arguments are equal, `CIN` returns a count of cases with a value equal to the second argument. | The '''`COUT`''' function is the complement of `CIN`. |
| Line 65: | Line 59: |
| Note: unsupported in SPSS version 21 or earlier. ---- |
Note: These are all unsupported in SPSS version 21 or earlier, and in PSPP version 1.6.2 or earlier. |
| Line 71: | Line 63: |
| == Clt == | === First === |
| Line 73: | Line 65: |
| 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. ---- |
The '''`FIRST`''' function returns the first non-missing value for each source variable. String values will never be considered missing. |
| Line 81: | Line 69: |
| == Cout == | === Fraction functions === |
| Line 83: | Line 71: |
| The '''`COUT`''' function returns a count of cases with a value outside of some range for each source variable. | The '''`FGT`''' and '''`FLT`''' functions returns a fraction of cases with a value greater/less than a second argument. |
| Line 85: | Line 73: |
| 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. | The '''`FIN`''' function returns a fraction of cases within an inclusive range defined by the second and third arguments. If the second argument is greater than the third, they are automatically reversed. If they are equal, `FIN` operates as an equality. |
| Line 87: | Line 75: |
| 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. ---- |
The '''`FOUT`''' function is the complement of `FIN`. |
| Line 97: | Line 79: |
| == Fgt == | === Last === |
| Line 99: | Line 81: |
| The '''`FGT`''' function returns a fraction of cases with a value greater than a specified second argument for each source variable. ---- |
The '''`LAST`''' function returns the lastnon-missing value for each source variable. String values will never be considered missing. |
| Line 105: | Line 85: |
| == 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 == |
=== Max === |
| Line 161: | Line 91: |
| ---- | |
| Line 164: | Line 93: |
== Mean == |
=== Mean === |
| Line 171: | Line 99: |
| ---- | |
| Line 174: | Line 101: |
== Median == |
=== Median === |
| Line 181: | Line 107: |
| ---- | |
| Line 184: | Line 109: |
== Min == |
=== Min === |
| Line 191: | Line 115: |
| ---- | |
| Line 194: | Line 117: |
== N == |
=== N === |
| Line 201: | Line 123: |
| ---- | === Nmiss === The '''`NMISS`''' function returns a weighted number of cases with missing values for each source variable. String values will never be considered missing. |
| Line 205: | Line 131: |
| == 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 == |
=== Nu === |
| Line 219: | Line 137: |
| ---- | === Numiss === The '''`NUMISS`''' function returns an unweighted number of cases with missing values for each source variable. String values will never be considered missing. |
| Line 223: | Line 145: |
| == Numiss == | === Percentage functions === |
| Line 225: | Line 147: |
| The '''`NUMISS`''' function returns an unweighted number of cases with missing values for each source variable. String values will never be considered missing. | The '''`PGT`''' and '''`PLT`''' functions returns a percentage of cases with a value greater/less than a second argument. |
| Line 227: | Line 149: |
| ---- | The '''`PIN`''' function returns a percentage of cases with a value within some range for each source variable. If the second argument is greater than the third, they are automatically reversed. If they are equal, `PIN` operates as an equality. The '''`POUT`''' function is the complement of `PIN`. |
| Line 231: | Line 155: |
| == 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 == |
=== SD === |
| Line 279: | Line 161: |
| ---- | |
| Line 282: | Line 163: |
== Sum == |
=== Sum === |
SPSS Aggregate Functions
The AGGREGATE command creates variables using a mini-programming language that is largely characterized by the below functions.
Contents
General Syntax
The number of target variables must match the number of source variables.
Generally, missing values are ignored. Strings 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.
Functions
Count functions
The CGT and CLT functions returns a count of cases with a value greater/less than a second argument.
The CIN function returns a count of cases within an inclusive range defined by the second and third arguments. If the second argument is greater than the third, they are automatically reversed. If they are equal, CIN operates as an equality.
The COUT function is the complement of CIN.
Note: These are all unsupported in SPSS version 21 or earlier, and in PSPP version 1.6.2 or earlier.
First
The FIRST function returns the first non-missing value for each source variable. String values will never be considered missing.
Fraction functions
The FGT and FLT functions returns a fraction of cases with a value greater/less than a second argument.
The FIN function returns a fraction of cases within an inclusive range defined by the second and third arguments. If the second argument is greater than the third, they are automatically reversed. If they are equal, FIN operates as an equality.
The FOUT function is the complement 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.
Percentage functions
The PGT and PLT functions returns a percentage of cases with a value greater/less than a second argument.
The PIN function returns a percentage of cases with a value within some range for each source variable. If the second argument is greater than the third, they are automatically reversed. If they are equal, PIN operates as an equality.
The POUT function is the complement 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.