S A M P L E   F O C E X E C S

Compute


Columns of data on a report can be used to create new columns.
A.    >
      tfs
      sum mongrs and compute
      newgross=mongrs*.05;
      topgross=mongrs*.l;
      if cdos is av
      end

      NUMBER OF RECORDS IN  TABLE=    947    LINES=      1

      PAGE  1

            MONGRS    NEWGROSS     TOPGROSS
            ------    --------     --------
      1,075,790.99   53,789.55   107,579.10


B.   >
     tfs
     sum mongrs monfte and compute
     wtavgrs=mongrs/monfte;
     by csex
     if recordlimit is 50
     end

     NUMBER OF RECORDS IN  TABLE=    50     LINES=      2

     PAGE  1

     CSEX     MONGRS     MONFTE    WTAVGRS
     ----     ------     ------    -------
     F     24,139.29    15.2512   1,582.78
     M     25,910.96    12.5551   2,063.78

     Column numbers can be used instead of data element names.


C.   >
     FOCUS:
     tfs
     sum mongrs monfte and compute
     wtavgrs=cl/c2;
     by csex
     if recordlimit is 50
     end

     NUMBER OF RECORDS IN  TABLE=     50    LINES=      2

     PAGE  1

     CSEX     MONGRS     MONFTE    WTAVGRS
     ----     ------     ------    -------
     F     24,139.29    15.2512   1.582.78
     M     25,910.96    12.5551   2,063.78

Back to Sample Focexecs