TABLEF Syntax Summary

The syntax of a TABLEF request is:

TABLEF FILE filename 
HEADING [CENTER]
"text"

 
{display_command}  [SEG.]field  [/R|/L|/C]  [/format] 
{display_command}  [prefixop.][field] [/R|/L|/C] [/format]
    [NOPRINT|AS 'title1,...,title5']    [AND|OVER]    [obj2...obj495]
    [IN n]

COMPUTE field [/format]=expression; [AS 'title1,...title5']
[AND] ROW-TOTAL [AND] COLUMN-TOTAL

BY [HIGHEST] keyfieldn [NOPRINT]

ON keyfield option1 [AND] option2...

WHERE [TOTAL] expression

IF [TOTAL] field relation value [OR value...]

ON TABLE SET parameter value

ON TABLE HOLD [VIA program] [AS name] [FORMAT format]  [MISSING {ON|OFF}]
ON TABLE PCHOLD             [AS name] [FORMAT format]  [MISSING {ON|OFF}]
ON TABLE SAVE               [AS name] [FORMAT format]  [MISSING {ON|OFF}]
ON TABLE SAVB               [AS name] [FORMAT format]  [MISSING {ON|OFF}]

ON TABLE  NOTOTAL
ON TABLE  COLUMN-TOTAL fieldname 
ON TABLE  ROW-TOTAL fieldname

 FOOTING [CENTER] [BOTTOM]
 "text"
 
{END|RUN|QUIT}

Note:

• Prefix operators for TABLEF can be: AVE., ASQ., MAX., MIN., FST., LST., CNT., or SUM.
• TABLEF requests cannot use:
  • Prefix operators DST., PCT., PCT.CNT., RPCT., and TOT.
  • Variables TABPAGENO, TABLASTPAGE, and BYLASTPAGE.
  • SET SQUEEZE
  • SET EMPTYREPORT.
  • Border styling.
  • ACROSS phrases.
  • WITHIN phrases.
  • RANKED BY phrases.
  • NOSPLIT.
  • Requests with multiple display commands (multi-verb requests).