Reporting Language Syntax Summary

The syntax of a TABLE request is:

DEFINE FILE filename [CLEAR|ADD] 
tempfield [/format]
  [{DEFCENT|DFC} {cc|19} {YRTHRESH|YRT} {[-]yy|0}]
  [MISSING {ON|OFF} [NEEDS] {SOME|ALL} [DATA]]
  [(GEOGRAPHIC_ROLE = georole)] [WITH realfield]
  [TITLE 'line1[,line2 ...']]
  [DESCRIPTION 'description'] = expression; 
tempfield [/format] REDEFINES qualifier.fieldname = expression;
.
.
.
END
TABLE 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...obj1024]
      [WITHIN field] [IN [+]n]
COMPUTE field [/format] [(GEOGRAPHIC_ROLE = georole)] = 
        expression; [AS 'title,...,title5'] [IN [+]n]
[AND] ROW-TOTAL [/R|/L|/C] [/format] [AS 'name']
[AND] COLUMN-TOTAL [/R|/L|/C] [AS 'name']
ACROSS [HIGHEST] sortfieldn [IN-GROUPS-OF qty]
   [NOPRINT] AS 'title1,...,title5']
BY [HIGHEST] sortfieldn [IN-GROUPS-OF qty]
   [NOPRINT] AS 'title1,...,title5']
BY [HIGHEST|LOWEST{n}] TOTAL [prefix_operator] {field|code_value}
RANKED [AS 'name'] BY {TOP|HIGHEST|LOWEST} [n] field 
       [PLUS OTHERS AS 'othertext'] 
       [IN-GROUPS-OF qty [TILES [TOP m]] [AS 'heading']]
       [NOPRINT|AS 'title1,...,title5']

{BY|ACROSS} sortfield IN-RANGES-OF value [TOP limit]
ON sfld option1 [AND] option2 [WHEN expression;...]
ON sfld RECAP fld1 [/fmt] = FORECAST (fld2, intvl, npredct,
  '{MOVAVE|EXPAVE}',npnt);

ON sfld RECAP fld1[/fmt] = FORECAST(fld2, interval, npredict, 'DOUBLEXP', 
   npoint1, npoint2);

ON sfld RECAP fld1[/fmt] = FORECAST(fld2, interval, npredict, 'SEASONAL', 
   nperiod, npoint1, npoint2, npoint3);

ON sfld RECAP fld1 [/fmt] = FORECAST (fld2, intvl, npredct, 'REGRESS');

ON {sortfield|TABLE} RECAP y[/fmt] = REGRESS(n, x1, [x2, [x3,]] z);
ON sfld RECAP fld1 [/fmt] = FORECAST (infield, interval, npredict,
  'DOUBLEXP',npoint, npoint2);
ON sfld RECAP fld1 [/fmt] = FORECAST (infield, interval, npredict,
  'SEASONAL', nperiod, npoint, npoint2, npoint3);{BY|ON} fieldname 
SUBHEAD
  [NEWPAGE]
"text"

{BY|ON} fieldname SUBFOOT [WITHIN] [MULTILINES] [NEWPAGE]
"text" [<prefop.fieldname ... ]" [WHEN expression;]

WHERE [TOTAL] expression 
WHERE {RECORDLIMIT|READLIMIT} EQ n 
IF [TOTAL] field relation value [OR value...]
WHERE_GROUPED expression
ON TABLE SET parameter value 
ON TABLE HOLD [VIA program][AS name] [FORMAT format] [DATASET dataset]
              [MISSING {ON|OFF}] [PERSISTENCE {STAGE|PERMANENT}]
ON TABLE {PCHOLD|SAVE|SAVB} [AS name] [FORMAT format]  [MISSING {ON|OFF}]
ON TABLE NOTOTAL
ON TABLE COLUMN-TOTAL [/R|/L|/C] [AS 'name'] fieldname 
ON TABLE {ROW-TOTAL|ACROSS-TOTAL}[/R|/L|/C][format] [AS 'name'] fieldname 
{BY|ON} sfld [AS 'text1']   {SUBTOTAL|SUB-TOTAL|SUMMARIZE|RECOMPUTE}
  [MULTILINES] [pref.] [field1 [pref.] field2 ...] [AS 'text2']
  [WHEN expression;]
{ACROSS|ON} sfld [AS 'text1'] {SUBTOTAL|SUB-TOTAL|SUMMARIZE|RECOMPUTE}
   [AS 'text2'] [COLUMNS c1 [AND c2 ...]]
ON  TABLE {SUBTOTAL|SUB-TOTAL|SUMMARIZE|RECOMPUTE}
  [pref.] [field1 [pref.] field2 ...] [AS 'text2']
FOOTING [CENTER] [BOTTOM]
"text"
MORE
FILE file2 
   [IF field relation value [OR value...]|WHERE expression]
END