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