Formats for Summaries (CTABLES command)

A default format is assigned to each summary function:

Count. The value is expressed in F (standard numeric) format with 0 decimal places. If you have fractional weights and want a count that reflects those weights, use F format with appropriate decimal places.

Percent. The value is expressed with one decimal place and a percent symbol.

General. The value is expressed in the variable’s print format.

These default formats are internal to CTABLES and cannot be used in table expressions. To override the default formats, use any of the print formats that are available in the Core system except Z, PBHEX, and HEX, or use the additional formats that are described in the following table.

Table 1. Additional formats for summaries
Format Description Example
NEGPARENw.d Parentheses appear around negative numbers. –1234.567 formatted as NEGPAREN9.2 yields (1234.57).
NEQUALw.d “N=” precedes the number. 1234.567 formatted as NEQUAL9.2 yields N=1234.57.
PARENw.d The number is parenthesized. 1234.567 formatted as PAREN8.2 yields (1234.57).
PCTPARENw.d A percent symbol follows the parenthesized value. 1234.567 formatted as PCTPAREN10.2 yields (1234.57%).