-------------------------------------------------------------------------------------------
>> XTAB PreProcessor V0.9 (2000/01/09)
>> Documentation: http://www.holg.com/xtab
1. * xtd010
2. *
3. * print the first 25 lines of a file:
4. *
5.
6. *files
7. input xtabdemodata.txt
8. limit 25
9.
10. *variables
11. lastname/Last Name/1-10
12. firstname/First Name/11-20
13. age/Age/21-22
14. race/Race/23
15. sex/Sex/24
16. county/County/25-26
17. company/Company/27-36
18. phone//37-46
19. ac/Area Code/37-39
20. ssn/Social Security Number/47-55
21. salary/Salary/56-60
22. title/Job Title/61
23. class/Classification/62
24.
25. *instructions
26. print data
27.
XTAB - Perl CrossTabulation Program
Gore Diane 73WM30Sun 666323812679845627798359VT
Bush Carol 18HF03Oracle 333553167398371656951748CT
Harris Barbara 63BM09Borland 222018543043319745096821AT
Bush Kim 32HF04Gateway 222196026194841707230390DT
Bush Jerry 40WM39Oracle 888215943027234379658149PT
Dole Gina 46WF26Sun 333697999646900366167802PT
Clinton Diane 25HF54Oracle 888076838208681002626259PT
Smith Barbara 80AM48Sun 333718937376409822752563PS
Jones Barbara 77WF50Sun 444173360896171288768466VT
Miller Irma 87HF31Dell 777593928094041300175969MT
Bush Barbara 47WM38Dell 666555025482912726646972AT
Wilson Kim 52WF47Dell 777023807954879332068593PT
Wilson Carol 38BF18Dell 666232542250882071722226MT
Bush Jerry 22BF52Novell 666443598396655005283552VS
Jones Irma 36WF01Dell 777442263022584578964965CT
Brown Gina 91WM43IBM 333363477282727887625490CS
Jones Barbara 80WF33Gateway 222171998204089172693476CT
Clinton Jerry 62WM29Microsoft 555221343055038027940979DT
Brown Kim 78AM33Novell 222158435913191405483757DT
Harris Kim 43WM05Borland 888704768009629434039069CT
Dole Irma 51AF26Gateway 888305420641545570152622CS
Smith Jerry 54HF33Novell 888045406790238444649851CT
Wilson Kim 64WM47IBM 777992587329990819257324CT
Gore Mary 89HM01Novell 333608424957453460664440MT
Gore Carol 31BF33Oracle 444275724551305822640205CT
# READ: 25
# SELECTED: 25
Time ended: Wed Jan 17 14:00:28 PST 2001
Time began: Wed Jan 17 14:00:28 PST 2001
-------------------------------------------------------------------------------------------
>> XTAB PreProcessor V0.9 (2000/01/09)
>> Documentation: http://www.holg.com/xtab
1. * xtd020
2. *
3. * print the first 25 records with some formatting
4. *
5. *files
6. input xtabdemodata.txt
7. limit 25
8.
9. *variables
10. lastname/Last Name/1-10
11. firstname/First Name/11-20
12. age/Age/21-22
13. race/Race/23
14. sex/Sex/24
15. county/County/25-26
16. company/Company/27-36
17. phone//37-46
18. ac/Area Code/37-39
19. ddd//40-42
20. dddd//43-46
21. ssn/Social Security Number/47-55
22. salary/Salary/56-60
23. title/Job Title/61
24. class/Classification/62
25.
26. *instructions
27. print company,2x,lastname,firstname,3x,1-(,ac,') ',ddd,-,dddd
28.
29. *tables
XTAB - Perl CrossTabulation Program
Sun Gore Diane 1-(666) 323-8126
Oracle Bush Carol 1-(333) 553-1673
Borland Harris Barbara 1-(222) 018-5430
Gateway Bush Kim 1-(222) 196-0261
Oracle Bush Jerry 1-(888) 215-9430
Sun Dole Gina 1-(333) 697-9996
Oracle Clinton Diane 1-(888) 076-8382
Sun Smith Barbara 1-(333) 718-9373
Sun Jones Barbara 1-(444) 173-3608
Dell Miller Irma 1-(777) 593-9280
Dell Bush Barbara 1-(666) 555-0254
Dell Wilson Kim 1-(777) 023-8079
Dell Wilson Carol 1-(666) 232-5422
Novell Bush Jerry 1-(666) 443-5983
Dell Jones Irma 1-(777) 442-2630
IBM Brown Gina 1-(333) 363-4772
Gateway Jones Barbara 1-(222) 171-9982
Microsoft Clinton Jerry 1-(555) 221-3430
Novell Brown Kim 1-(222) 158-4359
Borland Harris Kim 1-(888) 704-7680
Gateway Dole Irma 1-(888) 305-4206
Novell Smith Jerry 1-(888) 045-4067
IBM Wilson Kim 1-(777) 992-5873
Novell Gore Mary 1-(333) 608-4249
Oracle Gore Carol 1-(444) 275-7245
# READ: 25
# SELECTED: 25
Time ended: Wed Jan 17 14:00:28 PST 2001
Time began: Wed Jan 17 14:00:28 PST 2001
-------------------------------------------------------------------------------------------
>> XTAB PreProcessor V0.9 (2000/01/09)
>> Documentation: http://www.holg.com/xtab
1. * xtd030
2. *
3. * Produce some simple tables
4. *
5. *files
6. input xtabdemodata.txt
7.
8. *variables
9. lastname/Last Name/1-10
10. firstname/First Name/11-20
11. age/Age/21-22
12. race/Race/23
13. sex/Sex/24
14. county/County/25-26
15. company/Company/27-36
16. phone//37-46
17. ac/Area Code/37-39
18. ssn/Social Security Number/47-55
19. salary/Salary/56-60
20. title/Job Title/61
21. class/Classification/62
22.
23. *instructions
24. trim company
25.
26. *tables
27. table Title -vrs- Class
28. stub title freq 10
29. spread class freq 10
30.
31. table Title -vrs- Class
32. stub title codes M,A,D,V,P,C
33. spread class codes A,S,T
34.
35. table Title,-vrs-,Class
36. labels Manager, Analyst, Data Base Administrator, Developer,
37. Programmer, Clerk
38. stub title codes M,A,D,V,P,C
39. labels Administration, Supervision, Technical
40. spread class codes A,S,T
41.
42. table *******************,
43. * Salary by Class *,
44. *******************,/,/
45. stub salary values 0-35000,35001-50000,50001-75000,75001-99999
46. labels Administration, Supervision, Technical
47. spread class codes A,S,T
48.
49. table *******************,
50. * Salary by Class *,
51. *******************,/,(IBM only)
52. select company eq IBM
53. stub salary values 0-35000,35001-50000,50001-75000,75001-99999
54. labels Administration, Supervision, Technical
55. spread class codes A,S,T
XTAB - Perl CrossTabulation Program
Title -vrs- Class
Job Title
Classification
TOTAL A S T
TOTAL 1000 79 190 731
A 123 10 20 93
C 354 32 58 264
D 75 11 8 56
M 68 5 18 45
P 246 12 63 171
V 134 9 23 102
Title -vrs- Class
Job Title
Classification
TOTAL A S T
TOTAL 1000 79 190 731
M 68 5 18 45
A 123 10 20 93
D 75 11 8 56
V 134 9 23 102
P 246 12 63 171
C 354 32 58 264
Title
-vrs-
Class
Job Title
Classification
TOTAL Administration Supervision Technical
TOTAL 1000 79 190 731
Manager 68 5 18 45
Analyst 123 10 20 93
Data Base Administrator 75 11 8 56
Developer 134 9 23 102
Programmer 246 12 63 171
Clerk 354 32 58 264
*******************
* Salary by Class *
*******************
Salary
Classification
TOTAL Administration Supervision Technical
TOTAL 1000 79 190 731
0-35000 193 13 32 148
35001-50000 175 10 34 131
50001-75000 319 21 68 230
75001-99999 313 35 56 222
*******************
* Salary by Class *
*******************
(IBM only)
Salary
Classification
TOTAL Administration Supervision Technical
TOTAL 124 8 20 96
0-35000 26 1 5 20
35001-50000 29 2 9 18
50001-75000 35 3 3 29
75001-99999 34 2 3 29
# READ: 1000
# SELECTED: 1000
Time ended: Wed Jan 17 14:00:29 PST 2001
Time began: Wed Jan 17 14:00:29 PST 2001
-------------------------------------------------------------------------------------------
>> XTAB PreProcessor V0.9 (2000/01/09)
>> Documentation: http://www.holg.com/xtab
1. * xtd040
2. *
3. * Create an HTML page from a data file.
4. *
5.
6. *f
7. input xtabdemodata.txt
8. output H ibm.htm
9.
10. *variables
11. lastname/Last Name/1-10
12. firstname/First Name/11-20
13. age/Age/21-22
14. race/Race/23
15. sex/Sex/24
16. county/County/25-26
17. company/Company/27-36
18. phone//37-46
19. ac/Area Code/37-39
20. ssn/Social Security Number/47-55
21. salary/Salary/56-60
22. title/Job Title/61
23. class/Classification/62
24.
25. *init
26. write H IBM Employees with SALARYS Over ,' 75,000',
27. write H
28. write H | Name | Salary |
|---|
29.
30. *instructions
31. trim company
32. select company eq IBM
33. select salary > 75000
34. write H | ,lastname, firstname, | ,salary, |
35.
36. *term
37. write H
38.
39. *tables
XTAB - Perl CrossTabulation Program
# READ: 1000
# SELECTED: 34
# H: 38
Time ended: Wed Jan 17 14:00:29 PST 2001
Time began: Wed Jan 17 14:00:29 PST 2001