SORT VARIABLES

SORT VARIABLES reorders the variables in the active dataset's dictionary according to a chosen sort key.

SORT VARIABLES [BY]
    (NAME | TYPE | FORMAT | LABEL | VALUES | MISSING | MEASURE
     | ROLE | COLUMNS | ALIGNMENT | ATTRIBUTE NAME)
    [(D)].

The main specification is one of the following identifiers, which determines how the variables are sorted:

  • NAME
    Sorts the variables according to their names, in a case-insensitive fashion. However, when variable names differ only in a number at the end, they are sorted numerically. For example, VAR5 is sorted before VAR400 even though 4 precedes 5.

  • TYPE
    Sorts numeric variables before string variables, and shorter string variables before longer ones.

  • FORMAT
    Groups variables by print format; within a format, sorts narrower formats before wider ones; with the same format and width, sorts fewer decimal places before more decimal places. See PRINT FORMATS.

  • LABEL
    Sorts variables without a variable label before those with one. See VARIABLE LABELS.

  • VALUES
    Sorts variables without value labels before those with some. See VALUE LABELS.

  • MISSING
    Sorts variables without missing values before those with some. See MISSING VALUES.

  • MEASURE
    Sorts nominal variables first, followed by ordinal variables, followed by scale variables. See VARIABLE LEVEL.

  • ROLE
    Groups variables according to their role. See VARIABLE ROLE.

  • COLUMNS
    Sorts variables in ascending display width. See VARIABLE WIDTH.

  • ALIGNMENT
    Sorts variables according to their alignment, first left-aligned, then right-aligned, then centered. See VARIABLE ALIGNMENT.

  • ATTRIBUTE NAME
    Sorts variables according to the first value of their NAME attribute. Variables without attributes are sorted first. See VARIABLE ATTRIBUTE.

Only one sort criterion can be specified. The sort is "stable," so to sort on multiple criteria one may perform multiple sorts. For example, the following will sort primarily based on alignment, with variables that have the same alignment ordered based on display width:

SORT VARIABLES BY COLUMNS.
SORT VARIABLES BY ALIGNMENT.

Specify (D) to reverse the sort order.