MISSING Subcommand (AGGREGATE command)

By default, AGGREGATE uses all nonmissing values of the source variable to calculate aggregated variables. An aggregated variable will have a missing value only if the source variable is missing for every case in the break group. You can alter the default missing-value treatment by using the MISSING subcommand. You can also specify the inclusion of user-missing values on any function.

  • MISSING must immediately follow OUTFILE.
  • COLUMNWISE is the only specification available for MISSING.
  • If COLUMNWISE is specified, the value of an aggregated variable is missing for a break group if the source variable is missing for any case in the group.
  • COLUMNWISE does not affect the calculation of the N, NU, NMISS, or NUMISS functions.
  • COLUMNWISE does not apply to break variables. If a break variable has a missing value, cases in that group are processed and the break variable is saved in the file with the missing value. Use SELECT IF if you want to eliminate cases with missing values for the break variables.