Formats overview

<< Click to Display Table of Contents >>

Navigation:  Reference Manual > Formats >

Formats overview

 

If you cannot find a format option you are looking for, please go to the CL online manual which lists all the format options available:

https://netmr.scot/manuals/cl/Manual.htm

Formats are used to control the layout of tables produced.

They can be set globally for all the tables or be changed on individual tables using Format options.

All formats have a default value that will be used on a table if the setting has not been changed.

The project can have default formats that are preset in new tables (QTF) files to override the standard default settings.

All the main formats are referred to by a three letter abbreviation.

Some default values are changed from the older programs:

Companion: RLW30/SMA'+'/SMB'+'/SHG11/ESS

Previous:      RLW24/SMA'*'/SMB'*'/SHG0/NESS   Change to these formats for compatibility with older program output

Format types

Formats have three main types:

Logical formats

These format settings are either true (set) or untrue (not set).  To turn off a logical format the name is preceded by N.

For example the default format PRC (Print Raw Counts) causes figures to appear in the body of the table along with the percentages.  The default setting is PRC and it can be turned off using NPRC (No Print Raw Counts).

Numeric formats

These format settings have a value.  The value follows the name.  Numeric formats have a limited range of values that will be accepted.

For example the default value DPR0 (Decimal Places for Ratios) sets the decimal places for percentages to zero.  You can get 1 decimal place using DPR1.  Format DPR must have a value between 0 and 15.

Character formats

These format settings have a single character.  The value follows the name enclosed in apostrophes.

For example the default setting SMA'+' uses a plus (or minus) for significance marking against the total column; use SMA'+'/SMB'+'.

Format uses

The format descriptions are grouped into categories:

Width

Width format settings change the column widths for the row labels and the column labels on tables.

Figure

Figure format settings change the figures other than percentages that are shown and how the figures themselves are formatted.

Percentage

Percentage format settings change the percentages that are shown and how the figures themselves are formatted.

Suppress

Suppress format settings decide whether empty rows, columns, and tables should be shown, suppressed, or flagged.

Statistics

Statistics format settings request various table based statistics and significance markers to be added to the tables.

Significance

Significance format settings control the marking of significant differences using t tests and Z tests.

Exclude

Exclude format settings reject records with empty rows or columns from the table.

Combine

Combine format settings are used to put tables together that use the same columns.

Ranking

Ranking format settings request the rows or columns of a table to be sorted based on the (usually total) figures.

Title

Title format settings are used to suppress the titles (row, column, base, extra) to be shown on the tables.

Total

Total format settings change the total rows and total columns on a table.

Case

Case format settings control upper or lower case on a table.