AGR_SV_OPT
};
+#define AGGREGATE_FUNCTIONS \
+ AGRF(AGRF_SUM, "SUM", N_("Sum of values"), AGR_SV_YES, 0, -1, 8, 2) \
+ AGRF(AGRF_MEAN, "MEAN", N_("Mean average"), AGR_SV_YES, 0, -1, 8, 2) \
+ AGRF(AGRF_MEDIAN, "MEDIAN", N_("Median"), AGR_SV_YES, 0, -1, 8, 2) \
+ AGRF(AGRF_SD, "SD", N_("Standard deviation"), AGR_SV_YES, 0, -1, 8, 2) \
+ AGRF(AGRF_MAX, "MAX", N_("Maximum value"), AGR_SV_YES, 0, VAL_STRING, -1, -1) \
+ AGRF(AGRF_MIN, "MIN", N_("Minimum value"), AGR_SV_YES, 0, VAL_STRING, -1, -1) \
+ AGRF(AGRF_PGT, "PGT", N_("Percentage greater than"), AGR_SV_YES, 1, VAL_NUMERIC, 5, 1) \
+ AGRF(AGRF_PLT, "PLT", N_("Percentage less than"), AGR_SV_YES, 1, VAL_NUMERIC, 5, 1) \
+ AGRF(AGRF_PIN, "PIN", N_("Percentage included in range"), AGR_SV_YES, 2, VAL_NUMERIC, 5, 1) \
+ AGRF(AGRF_POUT, "POUT", N_("Percentage excluded from range"), AGR_SV_YES, 2, VAL_NUMERIC, 5, 1) \
+ AGRF(AGRF_FGT, "FGT", N_("Fraction greater than"), AGR_SV_YES, 1, VAL_NUMERIC, 5, 3) \
+ AGRF(AGRF_FLT, "FLT", N_("Fraction less than"), AGR_SV_YES, 1, VAL_NUMERIC, 5, 3) \
+ AGRF(AGRF_FIN, "FIN", N_("Fraction included in range"), AGR_SV_YES, 2, VAL_NUMERIC, 5, 3) \
+ AGRF(AGRF_FOUT, "FOUT", N_("Fraction excluded from range"), AGR_SV_YES, 2, VAL_NUMERIC, 5, 3) \
+ AGRF(AGRF_CGT, "CGT", N_("Count greater than"), AGR_SV_YES, 1, VAL_NUMERIC, 5, 1) \
+ AGRF(AGRF_CLT, "CLT", N_("Count less than"), AGR_SV_YES, 1, VAL_NUMERIC, 5, 1) \
+ AGRF(AGRF_CIN, "CIN", N_("Count included in range"), AGR_SV_YES, 2, VAL_NUMERIC, 5, 1) \
+ AGRF(AGRF_COUT, "COUT", N_("Count excluded from range"), AGR_SV_YES, 2, VAL_NUMERIC, 5, 1) \
+ AGRF(AGRF_N, "N", N_("Number of cases"), AGR_SV_NO, 0, VAL_NUMERIC, 7, 0) \
+ AGRF(AGRF_NU, "NU", N_("Number of cases (unweighted)"), AGR_SV_OPT, 0, VAL_NUMERIC, 7, 0) \
+ AGRF(AGRF_NMISS, "NMISS", N_("Number of missing values"), AGR_SV_YES, 0, VAL_NUMERIC, 7, 0) \
+ AGRF(AGRF_NUMISS, "NUMISS", N_("Number of missing values (unweighted)"), AGR_SV_YES, 0, VAL_NUMERIC, 7, 0) \
+ AGRF(AGRF_FIRST, "FIRST", N_("First non-missing value"), AGR_SV_YES, 0, VAL_STRING, -1, -1) \
+ AGRF(AGRF_LAST, "LAST", N_("Last non-missing value"), AGR_SV_YES, 0, VAL_STRING, -1, -1)
+
/* Aggregation functions. */
-enum
+enum agr_function
{
- SUM, MEAN, MEDIAN, SD, MAX, MIN, PGT, PLT, PIN, POUT, FGT, FLT, FIN,
- FOUT, N, NU, NMISS, NUMISS, FIRST, LAST,
-
- FUNC = 0x1f, /* Function mask. */
- FSTRING = 1<<5, /* String function bit. */
+#define AGRF(ENUM, NAME, DESCRIPTION, SRC_VARS, N_ARGS, ALPHA_TYPE, W, D) \
+ ENUM,
+AGGREGATE_FUNCTIONS
+#undef AGRF
};
/* Attributes of an aggregation function. */
struct agr_func
{
- const char *name; /* Aggregation function name. */
+ const char *name; /* Aggregation function name. */
const char *description; /* Translatable string describing the function. */
enum agr_src_vars src_vars; /* Whether source variables are a parameter of the function */
size_t n_args; /* Number of arguments (not including src vars). */
enum val_type alpha_type; /* When given ALPHA arguments, output type. */
- struct fmt_spec format; /* Format spec if alpha_type != ALPHA. */
+ struct fmt_spec format; /* Format spec if alpha_type != ALPHA. */
};
extern const struct agr_func agr_func_tab[];