Example (AGGREGATE command)

AGGREGATE
  /OUTFILE='/temp/temp.sav'
  /BREAK=gender marital
  /age_mean=MEAN(age) 
  /age_median=MEDIAN(age) 
  /income_median=MEDIAN(income).
  • AGGREGATE creates a new IBM® SPSS® Statistics data file, temp.sav, that contains two break variables (gender and marital) and all of the new aggregate variables.
  • BREAK specifies gender and marital as the break variables. In the aggregated file, cases are sorted in ascending order of gender and in ascending order of marital within gender. The active dataset remains unsorted.
  • Three aggregated variables are created: age_mean contains the mean age for each group defined by the two break variables; age_median contains the median age; and income_median contains the median income.