15.7.5.1 Explicit Categories

To use CTABLES to explicitly specify categories to include, list the categories within square brackets in the desired sort order. Use spaces or commas to separate values. Categories not covered by the list are excluded from analysis.

Each element of the list takes one of the following forms:

number

'string'

A numeric or string category value, for variables that have the corresponding type.

'date'

'time'

A date or time category value, for variables that have a date or time print format.

min THRU max

LO THRU max

min THRU HI

A range of category values, where min and max each takes one of the forms above, in increasing order.

MISSING

All user-missing values. (To match individual user-missing values, specify their category values.)

OTHERNM

Any non-missing value not covered by any other element of the list (regardless of where OTHERNM is placed in the list).

&postcompute

A computed category name (see Computed Categories).

SUBTOTAL

HSUBTOTAL

A subtotal (see Totals and Subtotals).

If multiple elements of the list cover a given category, the last one in the list takes precedence.

The following example syntax and output show how an explicit category can limit the displayed categories:

CTABLES /TABLE freqOfDriving.
CTABLES /TABLE freqOfDriving /CATEGORIES VARIABLES=freqOfDriving [1, 2, 3].