FORMAT subcommand (FREQUENCIES command)

FORMAT controls various features of the output, including order of categories and suppression of tables.

  • The minimum specification is a single keyword.
  • By default, FREQUENCIES displays the Frequency table and sort categories in ascending order of values for numeric variables and in alphabetical order for string variables.

Table order

AVALUE. Sort categories in ascending order of values (numeric variables) or in alphabetical order (string variables). This is the default.

DVALUE. Sort categories in descending order of values (numeric variables) or in reverse alphabetical order (string variables). This is ignored when HISTOGRAM, NTILES, or PERCENTILES is requested.

AFREQ. Sort categories in ascending order of frequency. This is ignored when HISTOGRAM, NTILES, or PERCENTILES is requested.

DFREQ. Sort categories in descending order of frequency. This is ignored when HISTOGRAM, NTILES, or PERCENTILES is requested.

Table suppression

LIMIT(n). Suppress frequency tables with more than n categories. The number of missing and valid cases and requested statistics are displayed for suppressed tables.

NOTABLE. Suppress all frequency tables. The number of missing and valid cases are displayed for suppressed tables. NOTABLE overrides LIMIT.