Prefixes

sum.      Sum of values

cnt.      Count of the occurrences

max.      Select the maximum value

min.      Select the minimum value

ave.      Compute the average value

pct.      Compute the percent of the column total

rpct.     Compute the row percent

tot.      Compute the column total

NOTE:  Only the verbs "write" or "sum" can be used with prefixes.
       They are interchangeable.


>
tfs
sum cnt.ctitle mongrs monfte
by csex
rl
end

NUMBER OF RECORDS IN TABLE=      25  LINES=      2

PAGE  1

      CTITLE
CSEX  COUNT        MONGRS     MONFTE
----  ------       ------     ------
F         13    12,825.37     8.5768
M          7     5,336.71     3.1683


>
tfs
write cnt.ctitle sum.monars sum.monfte max.monqrs
by csex
rl
end

NUMBER OF RECORDS IN TABLE=      25  LINES=      2

PAGE  1

      CTITLE                             MAX
CSEX  COUNT        MONGRS     MONFTE     MONGRS
----  ------       ------     ------     ------
F         13    12,825.37     8.5768     2,281.50
M          7     5,336.71     3.1683     2,382.00