Tables and axes > More about axes > Options on n, col, val, fld and bit statements
 
Options on n, col, val, fld and bit statements
Options can be used on n01, n15, n10, n11, col, val, bit and fld statements to define more specifically when and how to print a row. In many cases, an axis, table, filter or run-level option can be switched off by entering the appropriate keyword on the element, preceded by the letters no. For example, if you have applied a scaling factor to the table as a whole, you can switch it off for a single element by placing the keyword noscale on the statement which defines that element.
Some of these options can be used on n03, n23 and n09 statements:
[no]sort
subsort
unl
[no]row
[no]col
[no]high
which are described below. The options:
[no]row
[no]col
are also valid on n25 statements.
On an n statement, the options are listed after the row text and are separated from it and each other by semicolons:
n01First Row;c=c132'1';fac=2; ...
n01Second Row;nohigh
On a col or val statement, the option follows the relevant row text, separated by a semicolon, and preceded by a percent sign:
col 121;Base;First Row;%fac=2-1;Second Row;%nohigh
val t12;Base;=;10;%nz;20;%norow
Where an option appears on an element and also at a higher level (that is, a, sectbeg, flt or tab), the option on the element overrides the same option at the higher level. Thus, dec=2 on an n01 override dec=1 on the a statement for that element only.
Note Where conflicting options appear on the row and column axes of a table, the column option takes precedence.
See
Output options
Data options
See also
More about axes