S A M P L E F O C E X E C S
Sorts (in groups of)
A. >
tfs
count empno by age in-groups-of 15
end
NUMBER OF RECORDS IN TABLE= 859 LINES= 5
PAGE 1
EMPNO
AGE COUNT
--- -----
15 294
30 364
45 143
60 57
75 1
Note: The first line shows there are 294 employees between the ages
of 15 and 29.
B. >
tfs
count empno across age in-groups-of 10
on table row-total
end
NUMBER OF RECORDS IN TABLE= 859 LINES= 1
PAGE 1
AGE
10 20 30 40 50 60 70 TOTAL
--------------------------------------------------------
24 270 276 151 80 53 5 859
Note: The first entry shows there are 24 emnloyees between the ages
of 10 ind 19.
C. >
tfs
count emono across aqe in-groups-of 10
if recordlimit is 10
end
NUMBER OF RECORDS IN TABLE= 10 LINES= 1
PAGE 1
AGE
20 30 50 60
----------------------------
2 6 1 1
NOTE: Age 40 did not appear in the report, because there is no one in
the first ten records between the ages of 40 and 49.
Back to Sample Focexecs