<< Click to Display Table of Contents >> Navigation:  Reference Manual > Formats > Figure formats

These formats are used to alter the figures (not percentages) on the table.

CAZ (Character for Absolute Zero)

For spreadsheet output this will only be used if "Use zero formats instead of numeric zero" is set in CSV tables options.

This is a character format which sets the character to be used when a cell is zero (not close to zero).

The default value is CAZ'-'.

If CAZ'0' is used then the value will be shown with the relevant number of decimal places.

CNZ (Character for Nearly Zero)

For spreadsheet output this will only be used if "Use zero formats instead of numeric zero" is set in CSV tables options.

This format is also used for percentages that are nearly zero.

This is a character format which sets the character to be used when a figure is close to zero, and would show as zero, but is not actually zero.

For example:

For whole numbers, values between 0 and 0.5 will use CNZ.

For one decimal place, values between 0.0 and 0.05 will use CNZ.

The default value is CNZ'*'.

If CNZ'0' is used then the value will be shown as normal with the relevant number of decimal places.

DPT (Decimal Places for Table)

This is the number of decimal places to show for figures on a table.

The default value is DPT0.

The value must be set in the range DPT0 to DPT15.

DPW (Decimal Places for Weight labels)

This is the number of decimal places to show for row labels when the rows of a table is a float entry.

The default value is DPW5.

The value must be set in the range DPW0 to DPW15.

IMPORTANT: we recommend using NPSV and DPW for tables with float values as the rows.

PEC (Print Effective Counts)

This logical format causes the effective sample sizes figure for each cell in the table to be shown above the normal figures.

The default value is NPEC (false). Use PEC to see the ESS figures for cells.  This is useful for checking the weighting effects.

See also format ESR (Effective Sample size Row).

PRC (Print Raw Counts)

This logical format causes the figures for each cell in the table to be shown.

The default value is PRC (true). Use NPRC to see tonly see the percentages in the body of the table.  See also format FTC (Figures in Total Column).

PUC (Print Unweighted Counts)

This logical format causes the actual (unweighted) figures for each cell in the table to be shown above the normal figures.

The default value is NPUC (false). Use PUC to see the unweighted figures for cells.  This is useful for checking weighting.

See also formats UNC and UNR.

RWU (Replace Weighted with Unweighted)

This logical format replaces all the cells of a table with the unweighted figures in place of the (respondent or quantity) weighted figures.

It is used to produce unweighted tables without turning off any weighting.

The default value is NRWU (false).  Use RWU to turn on.