Refer to your FOCUS documentation for complete information on using the commands below.
|
COLUMNS/ROWS
|
ACROSS fieldname COLUMNS value AND value AND value
BY fieldname ROWS value OVER value OVER value
|
|
EMBEDDED DATA
|
e.g., "Data as of <AC:DAO"
|
|
FOLD-LINE
|
BY fieldname FOLD-LINE
|
|
IMPLIED PROMPTING WITH TEXT
|
e.g., IF AC:AGENCY EQ &AC:AGENCY.ENTER AGENCY CODE.
|
|
IN-GROUPS-OF
|
BY/ACROSS fieldname IN-GROUPS-OF value
|
|
MULTIPLE VERBS
|
SUM/COUNT fieldname1
BY fieldname2
PRINT/LIST fieldname3
BY fieldname2
BY fieldname4
|
|
NOPRINT
|
SORT fieldname NOPRINT
|
|
NOSPLIT
|
BY fieldname NOSPLIT
|
|
NOTOTAL
|
ON TABLE NOTOTAL
|
|
ON TABLE SUBHEAD/ SUBFOOT
|
ON TABLE SUBHEAD/SUBFOOT
"user provided text"
|
|
PAGE-BREAK REPAGE
|
BY fieldname PAGE-BREAK REPAGE
|
|
PREFIX OPERATORS
|
SUM prefix.fieldname
|
|
SKIP-LINE
|
BY fieldname SKIP-LINE
|
|
SUBHEAD/SUBFOOT
|
BY fieldname SUBHEAD/SUBFOOT
"user provided text"
|
|
SUBTOTAL MULTILINES
|
BY fieldname SUBTOTAL MULTILINES
|
|
UNDER-LINE
|
BY fieldname UNDER-LINE
|
Last Updated: February 1, 2000