Appendix 1: Sample SAS Program
1 The SAS System 13:31 Thursday, October 18, 2001
NOTE: Copyright (c) 1989-1996 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software Release 6.12 TS060
Licensed to SOCIAL & SCIENTIFIC SYSTEMS INC, Site 0026405003.
1
2 OPTIONS LS=132 PS=79;
3 *------------------------------------------------------------------------
4 *
5 * Program Name: SAMPLE.SAS
6 *
7 * Description: This job provides an example of how to get job info
8 * from previous rounds when STILLAT=1 (indicates still
9 * at the current main job) on the job record
10 *
11 * In this example, the variable SICKPAY is updated
12 * based on information from the current main job in
13 * the 1997 JOBS file
14 *
15 *------------------------------------------------------------------------;
16
17 LIBNAME INOUT 'T:\AHRQ\CCFS\DB009DVK\DATA\';
NOTE: Libref INOUT was successfully assigned as follows:
Engine: V612
Physical Name: T:\AHRQ\CCFS\DB009DVK\DATA
18 LIBNAME IN2 'T:\AHRQ\CCFS\HCPUFS\HC019\DATA\';
NOTE: Libref IN2 was successfully assigned as follows:
Engine: V612
Physical Name: T:\AHRQ\CCFS\HCPUFS\HC019\DATA
19
20 TITLE 'EXAMPLE 1';
21
22 *------------------------------------------------------------------
23 * select panel 2, round 3 main jobs with STILLAT=1, SICKPAY=-1
24 * from the 1998 jobs file
25 *------------------------------------------------------------------;
26
27 DATA JOBS98;
28 SET INOUT.JOBS3X;
29 IF PANEL = 2 & RN=3 & SUBTYPE=1 & STILLAT=1 & SICKPAY=-1;
30 RUN;
NOTE: The data set WORK.JOBS98 has 4365 observations and 88 variables.
NOTE: The DATA statement used 0.6 seconds.
31
32 PROC PRINT DATA=JOBS98 (OBS=10);
33 TITLE4 'SUBSET: PANEL=2, RN=3, SUBTYPE=1, STILLAT=1, SICKPAY=-1';
34 TITLE5 '(FROM 1998 JOBS FILE)'; TITLE6;
35 RUN;
NOTE: The PROCEDURE PRINT printed page 1.
NOTE: The PROCEDURE PRINT used 0.05 seconds.
36
37 *-------------------------------------------------------------
38 * get corresponding jobs records from the 1997 file
39 * merge by DUPERSID JOBSN to get jobs from all rounds
40 *-------------------------------------------------------------;
41
42 PROC SORT DATA=JOBS98; BY DUPERSID JOBSN;
43 RUN;
NOTE: The data set WORK.JOBS98 has 4365 observations and 88 variables.
NOTE: The PROCEDURE SORT used 0.33 seconds.
2 The SAS System 13:31 Thursday, October 18, 2001
44
45 PROC SORT DATA=IN2.JOBS5X OUT=HC019; BY DUPERSID JOBSN; /* 1997 file */
46 RUN;
NOTE: The data set WORK.HC019 has 59548 observations and 88 variables.
NOTE: The PROCEDURE SORT used 7.63 seconds.
47
48 DATA JOBS97;
49 MERGE JOBS98 (IN=A KEEP=DUPERSID JOBSN) HC019(IN=B);
50 BY DUPERSID JOBSN;
51 IF A & B;
52 RUN;
NOTE: The data set WORK.JOBS97 has 12678 observations and 88 variables.
NOTE: The DATA statement used 1.32 seconds.
53
54 PROC FREQ;
55 TABLE SUBTYPE*STILLAT*SICKPAY RN/LIST MISSING;
56 TITLE4 'MATCHING RECORDS FROM THE 1997 JOBS file'; TITLE5;
57 RUN;
NOTE: The PROCEDURE FREQ printed page 2.
NOTE: The PROCEDURE FREQ used 0.16 seconds.
58
59 PROC PRINT DATA=JOBS97 (OBS=15);
60 TITLE4 'SAMPLE DUMP OF 1997 JOBS RECORDS'; TITLE5;
61 RUN;
NOTE: The PROCEDURE PRINT printed page 3.
NOTE: The PROCEDURE PRINT used 0.0 seconds.
62
63 *--------------------------------------------------------------------
64 * drop 1997 records with STILLAT=1 (indicates person is at the
65 * same job, so job info would be recorded in an earlier round)
66 *
67 * also drop 1997 records if SUBTYPE not equal to 1 (indicates
68 * that the job is not the main job)
69 *---------------------------------------------------------------------;
70
71 DATA JOBS97;
72 SET JOBS97;
73 IF STILLAT=1 OR NOT(SUBTYPE=1) THEN DELETE;
74 RUN;
NOTE: The data set WORK.JOBS97 has 4361 observations and 88 variables.
NOTE: The DATA statement used 0.33 seconds.
75
76 PROC PRINT DATA=JOBS97 (OBS=25);
77 TITLE4 'SAMPLE DUMP OF 1997 JOBS RECORDS AFTER DELETING';
78 TITLE5 'RECORDS THAT HAVE STILLAT=1, SUBTYPE NE 1'; TITLE6;
79 RUN;
NOTE: The PROCEDURE PRINT printed pages 4-5.
NOTE: The PROCEDURE PRINT used 0.05 seconds.
3 The SAS System 13:31 Thursday, October 18, 2001
80
81 *------------------------------------------------------------------
82 * select the 1997 record from the last round, if there is
83 * more than one record for the job
84 *------------------------------------------------------------------;
85
86 PROC SORT DATA=JOBS97; BY DUPERSID JOBSN RN;
87 RUN;
NOTE: The data set WORK.JOBS97 has 4361 observations and 88 variables.
NOTE: The PROCEDURE SORT used 0.27 seconds.
88
89 DATA JOBS97 CHEK;
90 SET JOBS97; BY DUPERSID JOBSN;
91 IF LAST.JOBSN THEN OUTPUT JOBS97;
92 IF NOT(FIRST.JOBSN & LAST.JOBSN) THEN OUTPUT CHEK;
93 RUN;
NOTE: The data set WORK.JOBS97 has 4361 observations and 88 variables.
NOTE: The data set WORK.CHEK has 0 observations and 88 variables.
NOTE: The DATA statement used 0.33 seconds.
94
95 PROC PRINT DATA=CHEK(OBS=20);
96 TITLE4'DIAGNOSTIC (MORE THAN ONE MATCH)';TITLE5;
97 RUN;
NOTE: No observations in data set WORK.CHEK.
NOTE: The PROCEDURE PRINT used 0.05 seconds.
98
99 PROC PRINT DATA=JOBS97 (OBS=20);
100 TITLE4 'SELECTED 1997 JOBS TO MATCH TO 1998 JOBS'; TITLE5;
101 RUN;
NOTE: The PROCEDURE PRINT printed pages 6-7.
NOTE: The PROCEDURE PRINT used 0.0 seconds.
102
103 *-----------------------------------------------------------
104 * merge 1997 jobs info on to the 1998 jobs record
105 * by DUPERSID JOBSN
106 *
107 * SICKPAYX: SICKPAY from the 1997 jobs record
108 *-----------------------------------------------------------;
109
110 DATA JOBS98;
111 MERGE JOBS98(IN=A)
112 JOBS97(IN=B KEEP=DUPERSID JOBSN SICKPAY RENAME=(SICKPAY=SICKPAYX));
113 BY DUPERSID JOBSN;
114 IF A;
115 RUN;
NOTE: The data set WORK.JOBS98 has 4365 observations and 89 variables.
NOTE: The DATA statement used 0.38 seconds.
116
117 PROC FREQ DATA=JOBS98;
4 The SAS System 13:31 Thursday, October 18, 2001
118 TABLE SICKPAY*SICKPAYX /LIST MISSING;
119 TITLE4 '1998 JOBS RECORDS, AFTER MERGING ON 1997 DATA';
120 TITLE5; TITLE6;
121 RUN;
NOTE: The PROCEDURE FREQ printed page 8.NOTE: The PROCEDURE FREQ used 0.05 seconds.
122
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
EXAMPLE 1 13:31 Thursday, October 18, 2001 1
SUBSET: PANEL=2, RN=3, SUBTYPE=1, STILLAT=1, SICKPAY=-1
(FROM 1998 JOBS FILE)
D R M D W W Y S O N W E
J U J E S A I H O _ T F O H N S
O P O J J J J J J T U I F Y R C I F W Y U T
B E J P B S S S S S S I B N F _ K H L T T _ M M
S R D O A T T T T T T T R T _ W D S A L A A L E A
O I S U P B N Y R R R O O O J Y J A I T N W K K E M T
B D I I I R S E P T T T P P P O P O G F A G R E E F P E
S X D D D N N L E M D Y M D Y B E B E F T E K I I T S 1
1 30001030301 30001030 30001 30 3 1 2 2 -1 -1 1993 -1 -1 -1 2 1 1 2 -1 1 -1 -1 -1 -1 -1 -8 -1
2 30005015301 30005015 30005 15 3 1 2 2 -1 -1 1987 -1 -1 -1 2 1 1 2 -1 1 -1 -1 -1 -1 -1 100 -1
3 30005022301 30005022 30005 22 3 1 2 2 9 2 1997 -1 -1 -1 2 1 1 2 -1 1 -1 -1 -1 -1 -1 28 -1
4 30008018301 30008018 30008 18 3 1 2 1 -1 -1 1985 -1 -1 -1 2 1 1 -1 -1 2 -1 -1 -1 2 -1 -1 -1
5 30008025301 30008025 30008 25 3 1 2 2 -1 -1 1974 -1 -1 -1 2 1 1 1 3 1 -1 -1 -1 -1 -1 40 -1
6 30009020301 30009020 30009 20 3 1 2 1 -1 -1 1984 -1 -1 -1 2 1 1 -1 -1 1 -1 -1 -1 -1 -1 -1 -1
7 30011017302 30011017 30011 17 3 2 2 2 8 11 1997 -1 -1 -1 2 1 1 2 -1 1 -1 -1 -1 2 -1 -8 -1
8 30013018301 30013018 30013 18 3 1 2 1 4 12 1997 -1 -1 -1 2 1 1 -1 -1 1 -1 -1 -1 2 -1 -1 -1
9 30013025301 30013025 30013 25 3 1 2 2 -1 -1 1993 -1 -1 -1 2 1 1 2 -1 1 -1 -1 -1 -1 -1 12 -1
10 30014014301 30014014 30014 14 3 1 2 2 -1 -1 1977 -1 -1 -1 2 1 1 2 -1 1 -1 -1 -1 -1 -1 -8 -1
P T A P P R O D P H N S M
M R Y Y H H P S A A E W E F I I R H U T A H D H M P O
O B O P N R R R X I Y Y T K M F F N O M M O L O A R A E M M R
R U P E Y O E S S H C D V I L P R F U V E F T A W Y S K R O O E
E S R E L B C P 3 R K R A R Y L D P N D M M L R P W P E U R R M
O L I I M E U A R 5 D P V C P A I I L I I B E E I A A R A N E E I
B O N E P F S L W W A A S T L M N N N O N E M M E I G D M I 1 1 N
S C C T L T N L K K Y Y T N N T S S S N S R B P D D E Y T T 0 5 M
1 1 -1 -1 2 -1 -1 -1 50 -1 -1 -1 -1 -1 -1 -1 1 -1 -1 -1 1 -1 -1 -1 1 -1 -1 -1 -1 -1 -1 -1 -1
2 1 -1 -1 1 -1 -1 -1 50 -1 -1 -1 -1 -1 -1 -1 1 -1 -1 -1 -1 -1 -1 -1 2 -1 -1 -1 -1 -1 -8 -1 -1
3 2 -1 -1 1 -1 -1 -1 40 -1 -1 -1 -1 -1 -1 -1 1 -1 -1 -1 -1 -1 -1 -1 1 -1 -1 -1 -1 -1 -8 -1 -1
4 -1 -1 -1 -1 -1 -1 -1 30 -1 -1 -1 -1 -1 -1 -1 2 2 -1 -1 -1 -1 -1 1 -1 -1 -1 -1 -1 -1 -1 -1 -1
5 1 -1 -1 1 -1 -1 -1 40 -1 -1 -1 -1 -1 -1 -1 1 -1 -1 -1 -1 -1 -1 -1 1 -1 -1 -1 -1 -1 -1 -1 -1
6 -1 -1 -1 -1 -1 -1 -1 100 -1 -1 -1 -1 -1 -1 -1 1 -1 -1 -1 -1 -1 -1 30 -1 -1 -1 -1 -1 -1 -1 -1 -1
7 2 -1 -1 1 -1 -1 -1 44 -1 -1 -1 -1 -1 -1 -1 2 2 -1 -1 -1 -1 -1 -1 2 -1 -1 -1 -1 -1 -1 -1 -1
8 -1 -1 -1 -1 -1 -1 -1 60 -1 -1 -1 -1 -1 -1 -1 2 2 -1 -1 -1 -1 -1 11 -1 -1 -1 -1 -1 -1 -1 -1 -1
9 2 -1 -1 1 -1 -1 -1 38 -1 -1 -1 -1 -1 -1 -1 1 -1 -1 -1 -1 -1 -1 -1 2 -1 -1 -1 -1 -1 -1 -1 -1
10 1 -1 -1 1 -1 -1 -1 40 -1 -1 -1 -1 -1 -1 -1 1 -1 -1 -1 1 -1 -1 -1 2 -1 -1 -1 -1 -1 -1 -1 -1
O G G S O E E E O T B C H J J J S H I O
V R R A T A A A T I T O B O C R J J B E S O S H R N C
R O O L H R R R H P I N O M O L J J B E E N H B T F S D C
T S S R R N N N R S P S N M M Y B E E N G D I H I T A T P
I S S Y T T B C W U S U S U M W E N G D A A F A L C L C C
O M P P W Y I O O A N A N A N A A G D M M M M T S L H B O O
B H A E K P P N M G I M I M I M G H H I I P P W H A N A D D
S R Y R S E S S M E T T T T T T E R R N N M M K I T G S X X
1 -1 1800 2 -1 -1 2 2 2 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 1 2 40 -1 -1
2 -1 -1 -1 -1 -1 2 1 2 -1 -1 -1 -1 -8 -1 -1 -8 -1 -1 -1 -1 -1 -1 -1 -1 1 2 -1 -1 -1
3 -1 -8 -1 -1 -1 2 2 2 -1 -1 -1 -1 -1 -1 -1 -8 -1 -1 -1 -1 -1 -1 -1 -1 1 2 40 -1 -1
4 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 1 2 -1 -1 -1
5 -1 27000 1 52 -1 2 1 2 -1 -1 -1 6 1600 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 1 2 40 -1 -1
6 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 1 2 -1 -1 -1
7 -1 -1 -1 -1 3 2 2 2 -1 -1 -1 -1 -1 -1 -1 8 -1 -1 -1 -1 -1 -1 -1 -1 1 1 -1 -1 -1
8 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 1 2 -1 -1 -1
9 -1 -1 -1 -1 1 2 2 2 -1 -1 -1 -1 -1 -1 -1 12 -1 -1 -1 -1 -1 -1 -1 -1 1 2 -1 -1 -1
10 -1 -1 -1 -1 3 2 1 2 -1 -1 -1 -1 -8 -1 -1 15 -1 -1 -1 -1 -1 -1 -1 -1 1 2 -1 -1 -1
EXAMPLE 1 13:31 Thursday, October 18, 2001 2
MATCHING RECORDS FROM THE 1997 JOBS file
Cumulative Cumulative
SUBTYPE STILLAT SICKPAY Frequency Percent Frequency Percent
----------------------------------------------------------------------
1 -1 -9 14 0.1 14 0.1
1 -1 -8 114 0.9 128 1.0
1 -1 -7 4 0.0 132 1.0
1 -1 -1 591 4.7 723 5.7
1 -1 1 2236 17.6 2959 23.3
1 -1 2 1402 11.1 4361 34.4
1 1 -1 8082 63.7 12443 98.1
2 -1 -1 29 0.2 12472 98.4
3 -1 -9 1 0.0 12473 98.4
3 -1 -8 2 0.0 12475 98.4
3 -1 -1 8 0.1 12483 98.5
3 -1 1 17 0.1 12500 98.6
3 -1 2 59 0.5 12559 99.1
3 2 -1 3 0.0 12562 99.1
4 -1 -1 8 0.1 12570 99.1
5 -1 -1 104 0.8 12674 100.0
6 -1 -1 4 0.0 12678 100.0
ROUND
Cumulative Cumulative
RN Frequency Percent Frequency Percent
------------------------------------------------
1 3956 31.2 3956 31.2
2 4361 34.4 8317 65.6
3 4361 34.4 12678 100.0
EXAMPLE 1 13:31 Thursday, October 18, 2001 3
SAMPLE DUMP OF 1997 JOBS RECORDS
D R M D W W Y S O N W E
U J J E S A I H O _ T F O H N S
P O O J J J J J J T U I F Y R C I F W Y U T
E J B P B S S S S S S I B N F _ K H L T T _ M M
R O S D A T T T T T T T R T _ W D S A L A A L E A
O S B I U P N Y R R R O O O J Y J A I T N W K K E M T
B I S D I I R E P T T T P P P O P O G F A G R E E F P E
S D N X D D N L E M D Y M D Y B E B E F T E K I I T S 1
1 30001030 1 30001030101 30001 30 1 2 2 -1 -1 1993 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -8 -8
2 30001030 1 30001030201 30001 30 2 2 2 -1 -1 1993 -1 -1 -1 2 1 1 1 1 1 -1 -1 -1 -1 -1 -8 -1
3 30001030 1 30001030301 30001 30 3 2 2 -1 -1 1993 -1 -1 -1 2 1 1 2 -1 1 -1 -1 -1 -1 -1 -8 -1
4 30005015 1 30005015101 30005 15 1 2 2 -1 -1 1987 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 100 -1
5 30005015 1 30005015201 30005 15 2 2 2 -1 -1 1987 -1 -1 -1 2 1 1 1 3 1 -1 -1 -1 -1 -1 100 -1
6 30005015 1 30005015301 30005 15 3 2 2 -1 -1 1987 -1 -1 -1 2 1 1 2 -1 1 -1 -1 -1 -1 -1 100 -1
7 30005022 1 30005022101 30005 22 1 2 2 -1 -1 -1 -1 -1 1995 2 5 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
8 30005022 1 30005022201 30005 22 2 2 2 9 2 1997 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 28 -1
9 30005022 1 30005022301 30005 22 3 2 2 9 2 1997 -1 -1 -1 2 1 1 2 -1 1 -1 -1 -1 -1 -1 28 -1
10 30008018 1 30008018101 30008 18 1 2 1 -1 -1 1985 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
11 30008018 1 30008018201 30008 18 2 2 1 -1 -1 1985 -1 -1 -1 2 1 1 -1 -1 2 -1 -1 -1 2 -1 -1 -1
12 30008018 1 30008018301 30008 18 3 2 1 -1 -1 1985 -1 -1 -1 2 1 1 -1 -1 2 -1 -1 -1 2 -1 -1 -1
13 30008025 1 30008025101 30008 25 1 2 2 -1 -1 1974 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 40 -1
14 30008025 1 30008025201 30008 25 2 2 2 -1 -1 1974 -1 -1 -1 2 1 1 2 -1 1 -1 -1 -1 -1 -1 40 -1
15 30008025 1 30008025301 30008 25 3 2 2 -1 -1 1974 -1 -1 -1 2 1 1 1 3 1 -1 -1 -1 -1 -1 40 -1
P T A P P R O D P H N S M O
M R Y Y H H P S A A E W E F I I R H U T A H D H M P O V
O B O P N R R R X I Y Y T K M F F N O M M O L O A R A E M M R R
R U P E Y O E S S H C D V I L P R F U V E F T A W Y S K R O O E T
E S R E L B C P 3 R K R A R Y L D P N D M M L R P W P E U R R M I
O L I I M E U A R 5 D P V C P A I I L I I B E E I A A R A N E E I M
B O N E P F S L W W A A S T L M N N N O N E M M E I G D M I 1 1 N H
S C C T L T N L K K Y Y T N N T S S S N S R B P D D E Y T T 0 5 M R
1 1 -1 -1 2 -1 -1 -1 50 -1 -1 1 1 1 2 -1 1 -1 1 1 1 -1 -1 -1 1 -1 -1 -1 -1 -1 -1 -1 -1 -1
2 1 -1 -1 2 -1 -1 -1 50 -1 -1 -1 -1 -1 -1 -1 1 -1 -1 -1 1 -1 -1 -1 1 -1 -1 -1 -1 -1 -1 -1 -1 -1
3 1 -1 -1 2 -1 -1 -1 50 -1 -1 -1 -1 -1 -1 -1 1 -1 -1 -1 1 -1 -1 -1 1 -1 -1 -1 -1 -1 -1 -1 -1 -1
4 1 -1 -1 1 -1 -1 -1 50 -1 -1 1 2 1 2 -1 1 -1 1 2 -1 -1 -1 -1 2 -1 -1 -1 -1 -1 -1 -1 -1 -1
5 1 -1 -1 1 -1 -1 -1 50 -1 -1 -1 -1 -1 -1 -1 1 -1 -1 -1 -1 -1 -1 -1 2 -1 -1 -1 -1 -1 -8 -1 -1 -1
6 1 -1 -1 1 -1 -1 -1 50 -1 -1 -1 -1 -1 -1 -1 1 -1 -1 -1 -1 -1 -1 -1 2 -1 -1 -1 -1 -1 -8 -1 -1 -1
7 -1 -1 -1 1 8 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 1 2 2 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
8 2 -1 -1 1 -1 -1 -1 40 -1 -1 1 2 1 1 -1 1 -1 2 2 -1 -1 -1 -1 1 -1 -1 -1 -1 -1 -8 -1 -1 -1
9 2 -1 -1 1 -1 -1 -1 40 -1 -1 -1 -1 -1 -1 -1 1 -1 -1 -1 -1 -1 -1 -1 1 -1 -1 -1 -1 -1 -8 -1 -1 -1
10 -1 2 1 -1 -1 -1 -1 30 -1 -1 -1 -1 -1 -1 -1 2 2 -1 2 -1 2 -1 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
11 -1 -1 -1 -1 -1 -1 -1 30 -1 -1 -1 -1 -1 -1 -1 2 2 -1 -1 -1 -1 -1 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
12 -1 -1 -1 -1 -1 -1 -1 30 -1 -1 -1 -1 -1 -1 -1 2 2 -1 -1 -1 -1 -1 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
13 1 -1 -1 1 -1 -1 -1 40 -1 -1 1 2 1 1 -1 1 -1 2 2 -1 -1 -1 -1 1 -1 -1 -1 -1 -1 1 -7 -1 -1
14 1 -1 -1 1 -1 -1 -1 40 -1 -1 -1 -1 -1 -1 -1 1 -1 -1 -1 -1 -1 -1 -1 1 -1 -1 -1 -1 -1 1 -7 -1 -1
15 1 -1 -1 1 -1 -1 -1 40 -1 -1 -1 -1 -1 -1 -1 1 -1 -1 -1 -1 -1 -1 -1 1 -1 -1 -1 -1 -1 -1 -1 -1 -1
G G S O E E E O T B C H J J J S H I O
R R A T A A A T I T O B O C R J J B E S O S H R N C
O O L H R R R H P I N O M O L J J B E E N H B T F S D C
S S R R N N N R S P S N M M Y B E E N G D I H I T A T P
S S Y T T B C W U S U S U M W E N G D A A F A L C L C C
O P P W Y I O O A N A N A N A A G D M M M M T S L H B O O
B A E K P P N M G I M I M I M G H H I I P P W H A N A D D
S Y R S E S S M E T T T T T T E R R N N M M K I T G S X X
1 400 4 -1 -1 2 2 2 -1 -1 -1 -1 -1 -1 -1 -1.00 9 7 0 0 AM PM 2 -1 -1 -1 40 12 4
2 1800 2 -1 -1 2 2 2 -1 -1 -1 -1 -1 -1 -1 -1.00 -1 -1 -1 -1 -1 -1 -1 -1 1 2 40 -1 -1
3 1800 2 -1 -1 2 2 2 -1 -1 -1 -1 -1 -1 -1 -1.00 -1 -1 -1 -1 -1 -1 -1 -1 1 2 40 -1 -1
4 -1 -1 -1 3 2 2 2 -1 -1 -1 -1 -1 -1 -1 12.05 8 5 30 0 AM PM 2 -1 -1 -1 -1 5 1
5 -1 -1 -1 -1 2 1 2 -1 -1 -1 -1 -8 -1 -1 -8.00 -1 -1 -1 -1 -1 -1 -1 -1 1 2 -1 -1 -1
6 -1 -1 -1 -1 2 1 2 -1 -1 -1 -1 -8 -1 -1 -8.00 -1 -1 -1 -1 -1 -1 -1 -1 1 2 -1 -1 -1
7 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1.00 -1 -1 -1 -1 -1 -1 -1 2 -1 -1 -1 5 4
8 -8 -1 -1 -1 2 2 2 -1 -1 -1 -1 -1 -1 -1 -8.00 8 4 0 0 AM PM 2 -1 -1 -1 40 11 4
9 -8 -1 -1 -1 2 2 2 -1 -1 -1 -1 -1 -1 -1 -8.00 -1 -1 -1 -1 -1 -1 -1 -1 1 2 40 -1 -1
10 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1.00 4 7 0 0 PM PM 2 -1 -1 -1 -1 1 10
11 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1.00 -1 -1 -1 -1 -1 -1 -1 -1 1 2 -1 -1 -1
12 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1.00 -1 -1 -1 -1 -1 -1 -1 -1 1 2 -1 -1 -1
13 -7 -1 -1 -1 2 1 2 -1 -1 -1 -1 -7 -1 -1 -1.00 8 4 30 30 AM PM 2 -1 -1 -1 37 7 4
14 -7 -1 -1 -1 2 1 2 -1 -1 -1 -1 -7 -1 -1 -1.00 -1 -1 -1 -1 -1 -1 -1 -1 1 2 37 -1 -1
15 27000 1 52 -1 2 1 2 -1 -1 -1 6 1600 -1 -1 -1.00 -1 -1 -1 -1 -1 -1 -1 -1 1 2 40 -1 -1
EXAMPLE 1 13:31 Thursday, October 18, 2001 4
SAMPLE DUMP OF 1997 JOBS RECORDS AFTER DELETING
RECORDS THAT HAVE STILLAT=1, SUBTYPE NE 1
D R M D W W Y S O N W E
U J J E S A I H O _ T F O H N S
P O O J J J J J J T U I F Y R C I F W Y U T
E J B P B S S S S S S I B N F _ K H L T T _ M M
R O S D A T T T T T T T R T _ W D S A L A A L E A
O S B I U P N Y R R R O O O J Y J A I T N W K K E M T
B I S D I I R E P T T T P P P O P O G F A G R E E F P E
S D N X D D N L E M D Y M D Y B E B E F T E K I I T S 1
1 30001030 1 30001030101 30001 30 1 2 2 -1 -1 1993 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -8 -8
2 30005015 1 30005015101 30005 15 1 2 2 -1 -1 1987 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 100 -1
3 30005022 1 30005022201 30005 22 2 2 2 9 2 1997 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 28 -1
4 30008018 1 30008018101 30008 18 1 2 1 -1 -1 1985 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
5 30008025 1 30008025101 30008 25 1 2 2 -1 -1 1974 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 40 -1
6 30009020 1 30009020101 30009 20 1 2 1 -1 -1 1984 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
7 30011017 2 30011017202 30011 17 2 2 2 8 11 1997 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -8 5
8 30013018 1 30013018101 30013 18 1 2 1 4 12 1997 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
9 30013025 1 30013025101 30013 25 1 2 2 -1 -1 1993 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 12 -1
10 30014014 1 30014014101 30014 14 1 2 2 -1 -1 1977 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -8 5
11 30022012 1 30022012101 30022 12 1 2 2 -1 -1 1994 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 25 -1
12 30023015 1 30023015101 30023 15 1 2 2 4 -8 1997 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 10 -1
13 30023022 1 30023022101 30023 22 1 2 2 -1 -1 1995 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -8 -10
14 30025028 1 30025028201 30025 28 2 2 2 1 -1 1996 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -8 -8
P T A P P R O D P H N S M O
M R Y Y H H P S A A E W E F I I R H U T A H D H M P O V
O B O P N R R R X I Y Y T K M F F N O M M O L O A R A E M M R R
R U P E Y O E S S H C D V I L P R F U V E F T A W Y S K R O O E T
E S R E L B C P 3 R K R A R Y L D P N D M M L R P W P E U R R M I
O L I I M E U A R 5 D P V C P A I I L I I B E E I A A R A N E E I M
B O N E P F S L W W A A S T L M N N N O N E M M E I G D M I 1 1 N H
S C C T L T N L K K Y Y T N N T S S S N S R B P D D E Y T T 0 5 M R
1 1 -1 -1 2 -1 -1 -1 50 -1 -1 1 1 1 2 -1 1 -1 1 1 1 -1 -1 -1 1 -1 -1 -1 -1 -1 -1 -1 -1 -1
2 1 -1 -1 1 -1 -1 -1 50 -1 -1 1 2 1 2 -1 1 -1 1 2 -1 -1 -1 -1 2 -1 -1 -1 -1 -1 -1 -1 -1 -1
3 2 -1 -1 1 -1 -1 -1 40 -1 -1 1 2 1 1 -1 1 -1 2 2 -1 -1 -1 -1 1 -1 -1 -1 -1 -1 -8 -1 -1 -1
4 -1 2 1 -1 -1 -1 -1 30 -1 -1 -1 -1 -1 -1 -1 2 2 -1 2 -1 2 -1 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
5 1 -1 -1 1 -1 -1 -1 40 -1 -1 1 2 1 1 -1 1 -1 2 2 -1 -1 -1 -1 1 -1 -1 -1 -1 -1 1 -7 -1 -1
6 -1 1 -1 -1 -1 -1 -1 100 -1 -1 -1 -1 -1 -1 -1 1 -1 1 2 -1 2 -1 30 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
7 2 -1 -1 1 -1 -1 -1 44 -1 -1 -8 -1 1 2 -1 2 2 -1 2 -1 -1 -1 -1 2 -1 -1 -1 -1 -1 -1 -1 -1 -1
8 -1 1 -1 -1 -1 -1 -1 60 -1 -1 -1 -1 -1 -1 -1 2 2 -1 2 -1 2 -1 8 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
9 2 -1 -1 1 -1 -1 -1 38 -1 -1 1 1 1 2 -1 1 -1 2 2 -1 -1 -1 -1 2 -1 -1 -1 -1 -1 -1 -1 -1 -1
10 1 -1 -1 1 -1 -1 -1 40 -1 -1 1 2 1 1 -1 1 -1 1 1 1 -1 -1 -1 2 -1 -1 -1 -1 -1 -1 -1 -1 -1
11 1 -1 -1 1 -1 -1 -1 40 -1 -1 1 1 1 2 -1 1 -1 2 2 -1 -1 -1 -1 2 -1 -1 -1 -1 -1 -1 -1 -1 -1
12 2 -1 -1 1 -1 -1 -1 37 -1 7 2 -1 2 2 -1 2 2 -1 2 -1 -1 -1 -1 2 -1 -1 -1 -1 -1 -1 -1 -1 -1
13 1 -1 -1 1 -1 -1 -1 40 -1 -1 1 2 1 1 -1 1 -1 1 2 -1 -1 -1 -1 2 -1 -1 -1 -1 -1 -1 -1 -1 -1
14 -8 -1 -1 1 -1 -1 -1 20 -1 -1 2 -1 2 2 -1 2 2 -1 -8 -1 -1 -1 -1 2 -1 -1 -1 -1 -1 -1 -1 -1 -1
G G S O E E E O T B C H J J J S H I O
R R A T A A A T I T O B O C R J J B E S O S H R N C
O O L H R R R H P I N O M O L J J B E E N H B T F S D C
S S R R N N N R S P S N M M Y B E E N G D I H I T A T P
S S Y T T B C W U S U S U M W E N G D A A F A L C L C C
O P P W Y I O O A N A N A N A A G D M M M M T S L H B O O
B A E K P P N M G I M I M I M G H H I I P P W H A N A D D
S Y R S E S S M E T T T T T T E R R N N M M K I T G S X X
1 400 4 -1 -1 2 2 2 -1 -1 -1 -1 -1 -1 -1 -1.00 9 7 0 0 AM PM 2 -1 -1 -1 40 12 4
2 -1 -1 -1 3 2 2 2 -1 -1 -1 -1 -1 -1 -1 12.05 8 5 30 0 AM PM 2 -1 -1 -1 -1 5 1
3 -8 -1 -1 -1 2 2 2 -1 -1 -1 -1 -1 -1 -1 -8.00 8 4 0 0 AM PM 2 -1 -1 -1 40 11 4
4 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1.00 4 7 0 0 PM PM 2 -1 -1 -1 -1 1 10
5 -7 -1 -1 -1 2 1 2 -1 -1 -1 -1 -7 -1 -1 -1.00 8 4 30 30 AM PM 2 -1 -1 -1 37 7 4
6 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1.00 7 7 30 30 AM PM 2 -1 -1 -1 -1 8 2
7 -1 -1 -1 3 2 2 2 -1 -1 -1 -1 -1 -1 -1 8.00 7 3 0 0 AM PM 2 -1 -1 -1 -1 4 6
8 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1.00 4 2 0 0 AM PM 2 -1 -1 -1 -1 8 2
9 -1 -1 -1 1 2 2 2 -1 -1 -1 -1 -1 -1 -1 12.00 7 5 0 0 AM PM 2 -1 -1 -1 -1 11 8
10 -1 -1 -1 3 2 1 2 -1 -1 -1 -1 -8 -1 -1 15.00 7 4 0 0 AM PM 2 -1 -1 -1 -1 4 6
11 -1 -1 -1 1 2 1 2 -1 -1 -1 91 75 -1 -1 8.00 8 5 0 0 AM PM 2 -1 -1 -1 -1 11 4
12 -1 -1 -1 1 1 2 2 -1 2 25 -1 -1 -1 -1 3.25 11 5 0 0 AM PM 2 -1 -1 -1 -1 6 8
13 -1 -1 -1 3 2 1 2 -1 -1 -1 6 1200 -1 -1 12.82 7 7 0 0 AM PM 1 -1 -1 -1 -1 4 6
14 -1 -1 -1 1 2 2 2 -1 -1 -1 -1 -1 -1 -1 5.00 3 7 0 0 PM PM 2 -1 -1 -1 -1 6 3
EXAMPLE 1 13:31 Thursday, October 18, 2001 5
SAMPLE DUMP OF 1997 JOBS RECORDS AFTER DELETING
RECORDS THAT HAVE STILLAT=1, SUBTYPE NE 1
D R M D W W Y S O N W E
U J J E S A I H O _ T F O H N S
P O O J J J J J J T U I F Y R C I F W Y U T
E J B P B S S S S S S I B N F _ K H L T T _ M M
R O S D A T T T T T T T R T _ W D S A L A A L E A
O S B I U P N Y R R R O O O J Y J A I T N W K K E M T
B I S D I I R E P T T T P P P O P O G F A G R E E F P E
S D N X D D N L E M D Y M D Y B E B E F T E K I I T S 1
15 30025035 1 30025035201 30025 35 2 2 2 6 -8 1997 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -8 -8
16 30028013 1 30028013101 30028 13 1 2 2 -1 -1 1993 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 7 -1
17 30032029 1 30032029101 30032 29 1 2 2 -1 -1 1991 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 6 -1
18 30037014 1 30037014101 30037 14 1 2 2 -1 -1 1993 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 300 -1
19 30037021 1 30037021101 30037 21 1 2 2 6 -1 1996 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 6 -1
20 30038010 1 30038010101 30038 10 1 2 1 -1 -1 1966 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
21 30038027 1 30038027101 30038 27 1 2 2 -1 -1 1995 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 125 -1
22 30040015 1 30040015201 30040 15 2 2 2 8 28 1997 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -8 4
23 30041032 1 30041032101 30041 32 1 2 2 -1 -1 -8 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -8 -8
24 30041049 2 30041049202 30041 49 2 2 2 10 28 1997 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 6 -1
25 30043016 1 30043016101 30043 16 1 2 2 -1 -1 1994 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 100 -1
P T A P P R O D P H N S M O
M R Y Y H H P S A A E W E F I I R H U T A H D H M P O V
O B O P N R R R X I Y Y T K M F F N O M M O L O A R A E M M R R
R U P E Y O E S S H C D V I L P R F U V E F T A W Y S K R O O E T
E S R E L B C P 3 R K R A R Y L D P N D M M L R P W P E U R R M I
O L I I M E U A R 5 D P V C P A I I L I I B E E I A A R A N E E I M
B O N E P F S L W W A A S T L M N N N O N E M M E I G D M I 1 1 N H
S C C T L T N L K K Y Y T N N T S S S N S R B P D D E Y T T 0 5 M R
15 -8 -1 -1 1 -1 -1 -1 42 -1 -1 -8 -1 -8 -8 -1 -8 -1 -1 -8 -1 -1 -1 -1 -8 -1 -1 -1 -1 -1 -8 -1 -1 -1
16 1 -1 -1 -8 -1 -1 -1 40 -1 -1 1 1 1 1 -1 1 -1 2 2 -1 -1 -1 -1 2 -1 -1 -1 -1 -1 2 -1 1 -1
17 1 -1 -1 1 -1 -1 -1 41 -1 -1 2 -1 2 -8 -1 2 1 1 2 -1 -1 -1 -1 1 -1 -1 -1 -1 -1 -1 -1 -1 -1
18 1 -1 -1 1 -1 -1 -1 40 -1 -1 1 1 1 1 -1 1 -1 2 1 1 -1 -1 -1 2 -1 -1 -1 -1 -1 -1 -1 -1 -1
19 1 -1 -1 1 -1 -1 -1 20 -1 -1 2 -1 2 2 -1 2 2 -1 2 -1 -1 -1 -1 2 -1 -1 -1 -1 -1 -1 -1 -1 -1
20 -1 1 -1 -1 -1 -1 -1 60 -1 -1 -1 -1 -1 -1 -1 2 2 -1 2 -1 2 -1 4 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
21 -8 -1 -1 1 -1 -1 -1 15 -1 -1 2 -1 2 2 -1 2 2 -1 2 -1 -1 -1 -1 2 -1 -1 -1 -1 -1 -1 -1 -1 -1
22 1 -1 -1 1 -1 -1 -1 40 -1 -1 1 -8 1 1 -1 2 1 -8 2 -1 -1 -1 -1 2 -1 -1 -1 -1 -1 -1 -1 -1 -1
23 -8 -1 -1 1 -1 -1 -1 40 -1 -1 -8 -1 -8 -8 -1 -8 -1 -1 -8 -1 -1 -1 -1 -8 -1 -1 -1 -1 -1 -8 -1 -1 -1
24 1 -1 -1 1 -1 -1 -1 40 -1 -1 2 -1 2 2 -1 2 2 -1 2 -1 -1 -1 -1 2 -1 -1 -1 -1 -1 -1 -1 -1 -1
25 2 -1 -1 1 -1 -1 -1 44 -1 -1 2 -1 1 1 -1 2 1 2 2 -1 -1 -1 -1 3 3 -1 -1 -1 -1 -1 -1 -1 -1
G G S O E E E O T B C H J J J S H I O
R R A T A A A T I T O B O C R J J B E S O S H R N C
O O L H R R R H P I N O M O L J J B E E N H B T F S D C
S S R R N N N R S P S N M M Y B E E N G D I H I T A T P
S S Y T T B C W U S U S U M W E N G D A A F A L C L C C
O P P W Y I O O A N A N A N A A G D M M M M T S L H B O O
B A E K P P N M G I M I M I M G H H I I P P W H A N A D D
S Y R S E S S M E T T T T T T E R R N N M M K I T G S X X
15 -1 -1 -1 -1 -8 -8 -8 -1 -1 -1 -1 -1 -1 -1 -8.00 8 5 0 30 AM PM 2 -1 -1 -1 -1 5 7
16 -1 -1 -1 -1 2 2 2 -1 -1 -1 -1 -1 -1 -1 -8.00 10 6 30 30 AM PM 2 -1 -1 -1 -1 11 1
17 -8 -1 -1 -1 2 2 2 -1 -1 -1 -1 -1 -1 -1 8.00 95 -1 -1 -1 -1 -1 1 -1 -1 -1 41 11 1
18 -1 -1 -1 3 2 2 2 -1 -1 -1 -1 -1 -1 -1 9.75 8 4 0 30 AM PM 2 -1 -1 -1 -1 5 4
19 -1 -1 -1 1 2 1 2 -1 -1 -1 91 25 -1 -1 6.25 5 9 0 0 PM PM 1 -1 -1 -1 -1 6 3
20 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1.00 9 10 0 0 AM PM 2 -1 -1 -1 -1 7 3
21 -1 -1 -1 1 2 2 2 -1 -1 -1 -1 -1 -1 -1 20.00 95 -1 -1 -1 -1 -1 2 -1 -1 -1 -1 11 2
22 -1 -1 -1 1 2 2 2 -1 -1 -1 -1 -1 -1 -1 6.00 10 7 0 0 PM AM 2 -1 -1 -1 -1 6 4
23 -1 -1 -1 -1 -8 -8 -8 -1 -1 -1 -1 -1 -1 -1 -8.00 7 5 0 0 AM PM 2 -1 -1 -1 -1 5 7
24 -1 -1 -1 3 2 2 2 -1 -1 -1 -1 -1 -1 -1 5.00 12 9 0 0 PM PM 2 -1 -1 -1 -1 6 8
25 -1 -1 -1 -1 2 1 1 -1 -1 -1 3 50 91 200 -1.00 95 -1 -1 -1 -1 -1 2 -1 -1 -1 -1 6 3
EXAMPLE 1 13:31 Thursday, October 18, 2001 6
SELECTED 1997 JOBS TO MATCH TO 1998 JOBS
D R M D W W Y S O N W E
U J J E S A I H O _ T F O H N S
P O O J J J J J J T U I F Y R C I F W Y U T
E J B P B S S S S S S I B N F _ K H L T T _ M M
R O S D A T T T T T T T R T _ W D S A L A A L E A
O S B I U P N Y R R R O O O J Y J A I T N W K K E M T
B I S D I I R E P T T T P P P O P O G F A G R E E F P E
S D N X D D N L E M D Y M D Y B E B E F T E K I I T S 1
1 30001030 1 30001030101 30001 30 1 2 2 -1 -1 1993 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -8 -8
2 30005015 1 30005015101 30005 15 1 2 2 -1 -1 1987 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 100 -1
3 30005022 1 30005022201 30005 22 2 2 2 9 2 1997 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 28 -1
4 30008018 1 30008018101 30008 18 1 2 1 -1 -1 1985 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
5 30008025 1 30008025101 30008 25 1 2 2 -1 -1 1974 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 40 -1
6 30009020 1 30009020101 30009 20 1 2 1 -1 -1 1984 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
7 30011017 2 30011017202 30011 17 2 2 2 8 11 1997 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -8 5
8 30013018 1 30013018101 30013 18 1 2 1 4 12 1997 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
9 30013025 1 30013025101 30013 25 1 2 2 -1 -1 1993 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 12 -1
10 30014014 1 30014014101 30014 14 1 2 2 -1 -1 1977 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -8 5
11 30022012 1 30022012101 30022 12 1 2 2 -1 -1 1994 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 25 -1
12 30023015 1 30023015101 30023 15 1 2 2 4 -8 1997 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 10 -1
13 30023022 1 30023022101 30023 22 1 2 2 -1 -1 1995 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -8 -10
14 30025028 1 30025028201 30025 28 2 2 2 1 -1 1996 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -8 -8
15 30025035 1 30025035201 30025 35 2 2 2 6 -8 1997 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -8 -8
P T A P P R O D P H N S M O
M R Y Y H H P S A A E W E F I I R H U T A H D H M P O V
O B O P N R R R X I Y Y T K M F F N O M M O L O A R A E M M R R
R U P E Y O E S S H C D V I L P R F U V E F T A W Y S K R O O E T
E S R E L B C P 3 R K R A R Y L D P N D M M L R P W P E U R R M I
O L I I M E U A R 5 D P V C P A I I L I I B E E I A A R A N E E I M
B O N E P F S L W W A A S T L M N N N O N E M M E I G D M I 1 1 N H
S C C T L T N L K K Y Y T N N T S S S N S R B P D D E Y T T 0 5 M R
1 1 -1 -1 2 -1 -1 -1 50 -1 -1 1 1 1 2 -1 1 -1 1 1 1 -1 -1 -1 1 -1 -1 -1 -1 -1 -1 -1 -1 -1
2 1 -1 -1 1 -1 -1 -1 50 -1 -1 1 2 1 2 -1 1 -1 1 2 -1 -1 -1 -1 2 -1 -1 -1 -1 -1 -1 -1 -1 -1
3 2 -1 -1 1 -1 -1 -1 40 -1 -1 1 2 1 1 -1 1 -1 2 2 -1 -1 -1 -1 1 -1 -1 -1 -1 -1 -8 -1 -1 -1
4 -1 2 1 -1 -1 -1 -1 30 -1 -1 -1 -1 -1 -1 -1 2 2 -1 2 -1 2 -1 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
5 1 -1 -1 1 -1 -1 -1 40 -1 -1 1 2 1 1 -1 1 -1 2 2 -1 -1 -1 -1 1 -1 -1 -1 -1 -1 1 -7 -1 -1
6 -1 1 -1 -1 -1 -1 -1 100 -1 -1 -1 -1 -1 -1 -1 1 -1 1 2 -1 2 -1 30 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
7 2 -1 -1 1 -1 -1 -1 44 -1 -1 -8 -1 1 2 -1 2 2 -1 2 -1 -1 -1 -1 2 -1 -1 -1 -1 -1 -1 -1 -1 -1
8 -1 1 -1 -1 -1 -1 -1 60 -1 -1 -1 -1 -1 -1 -1 2 2 -1 2 -1 2 -1 8 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
9 2 -1 -1 1 -1 -1 -1 38 -1 -1 1 1 1 2 -1 1 -1 2 2 -1 -1 -1 -1 2 -1 -1 -1 -1 -1 -1 -1 -1 -1
10 1 -1 -1 1 -1 -1 -1 40 -1 -1 1 2 1 1 -1 1 -1 1 1 1 -1 -1 -1 2 -1 -1 -1 -1 -1 -1 -1 -1 -1
11 1 -1 -1 1 -1 -1 -1 40 -1 -1 1 1 1 2 -1 1 -1 2 2 -1 -1 -1 -1 2 -1 -1 -1 -1 -1 -1 -1 -1 -1
12 2 -1 -1 1 -1 -1 -1 37 -1 7 2 -1 2 2 -1 2 2 -1 2 -1 -1 -1 -1 2 -1 -1 -1 -1 -1 -1 -1 -1 -1
13 1 -1 -1 1 -1 -1 -1 40 -1 -1 1 2 1 1 -1 1 -1 1 2 -1 -1 -1 -1 2 -1 -1 -1 -1 -1 -1 -1 -1 -1
14 -8 -1 -1 1 -1 -1 -1 20 -1 -1 2 -1 2 2 -1 2 2 -1 -8 -1 -1 -1 -1 2 -1 -1 -1 -1 -1 -1 -1 -1 -1
15 -8 -1 -1 1 -1 -1 -1 42 -1 -1 -8 -1 -8 -8 -1 -8 -1 -1 -8 -1 -1 -1 -1 -8 -1 -1 -1 -1 -1 -8 -1 -1 -1
G G S O E E E O T B C H J J J S H I O
R R A T A A A T I T O B O C R J J B E S O S H R N C
O O L H R R R H P I N O M O L J J B E E N H B T F S D C
S S R R N N N R S P S N M M Y B E E N G D I H I T A T P
S S Y T T B C W U S U S U M W E N G D A A F A L C L C C
O P P W Y I O O A N A N A N A A G D M M M M T S L H B O O
B A E K P P N M G I M I M I M G H H I I P P W H A N A D D
S Y R S E S S M E T T T T T T E R R N N M M K I T G S X X
1 400 4 -1 -1 2 2 2 -1 -1 -1 -1 -1 -1 -1 -1.00 9 7 0 0 AM PM 2 -1 -1 -1 40 12 4
2 -1 -1 -1 3 2 2 2 -1 -1 -1 -1 -1 -1 -1 12.05 8 5 30 0 AM PM 2 -1 -1 -1 -1 5 1
3 -8 -1 -1 -1 2 2 2 -1 -1 -1 -1 -1 -1 -1 -8.00 8 4 0 0 AM PM 2 -1 -1 -1 40 11 4
4 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1.00 4 7 0 0 PM PM 2 -1 -1 -1 -1 1 10
5 -7 -1 -1 -1 2 1 2 -1 -1 -1 -1 -7 -1 -1 -1.00 8 4 30 30 AM PM 2 -1 -1 -1 37 7 4
6 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1.00 7 7 30 30 AM PM 2 -1 -1 -1 -1 8 2
7 -1 -1 -1 3 2 2 2 -1 -1 -1 -1 -1 -1 -1 8.00 7 3 0 0 AM PM 2 -1 -1 -1 -1 4 6
8 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1.00 4 2 0 0 AM PM 2 -1 -1 -1 -1 8 2
9 -1 -1 -1 1 2 2 2 -1 -1 -1 -1 -1 -1 -1 12.00 7 5 0 0 AM PM 2 -1 -1 -1 -1 11 8
10 -1 -1 -1 3 2 1 2 -1 -1 -1 -1 -8 -1 -1 15.00 7 4 0 0 AM PM 2 -1 -1 -1 -1 4 6
11 -1 -1 -1 1 2 1 2 -1 -1 -1 91 75 -1 -1 8.00 8 5 0 0 AM PM 2 -1 -1 -1 -1 11 4
12 -1 -1 -1 1 1 2 2 -1 2 25 -1 -1 -1 -1 3.25 11 5 0 0 AM PM 2 -1 -1 -1 -1 6 8
13 -1 -1 -1 3 2 1 2 -1 -1 -1 6 1200 -1 -1 12.82 7 7 0 0 AM PM 1 -1 -1 -1 -1 4 6
14 -1 -1 -1 1 2 2 2 -1 -1 -1 -1 -1 -1 -1 5.00 3 7 0 0 PM PM 2 -1 -1 -1 -1 6 3
15 -1 -1 -1 -1 -8 -8 -8 -1 -1 -1 -1 -1 -1 -1 -8.00 8 5 0 30 AM PM 2 -1 -1 -1 -1 5 7
EXAMPLE 1 13:31 Thursday, October 18, 2001 7
SELECTED 1997 JOBS TO MATCH TO 1998 JOBS
D R M D W W Y S O N W E
U J J E S A I H O _ T F O H N S
P O O J J J J J J T U I F Y R C I F W Y U T
E J B P B S S S S S S I B N F _ K H L T T _ M M
R O S D A T T T T T T T R T _ W D S A L A A L E A
O S B I U P N Y R R R O O O J Y J A I T N W K K E M T
B I S D I I R E P T T T P P P O P O G F A G R E E F P E
S D N X D D N L E M D Y M D Y B E B E F T E K I I T S 1
16 30028013 1 30028013101 30028 13 1 2 2 -1 -1 1993 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 7 -1
17 30032029 1 30032029101 30032 29 1 2 2 -1 -1 1991 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 6 -1
18 30037014 1 30037014101 30037 14 1 2 2 -1 -1 1993 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 300 -1
19 30037021 1 30037021101 30037 21 1 2 2 6 -1 1996 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 6 -1
20 30038010 1 30038010101 30038 10 1 2 1 -1 -1 1966 -1 -1 -1 2 1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
P T A P P R O D P H N S M O
M R Y Y H H P S A A E W E F I I R H U T A H D H M P O V
O B O P N R R R X I Y Y T K M F F N O M M O L O A R A E M M R R
R U P E Y O E S S H C D V I L P R F U V E F T A W Y S K R O O E T
E S R E L B C P 3 R K R A R Y L D P N D M M L R P W P E U R R M I
O L I I M E U A R 5 D P V C P A I I L I I B E E I A A R A N E E I M
B O N E P F S L W W A A S T L M N N N O N E M M E I G D M I 1 1 N H
S C C T L T N L K K Y Y T N N T S S S N S R B P D D E Y T T 0 5 M R
16 1 -1 -1 -8 -1 -1 -1 40 -1 -1 1 1 1 1 -1 1 -1 2 2 -1 -1 -1 -1 2 -1 -1 -1 -1 -1 2 -1 1 -1
17 1 -1 -1 1 -1 -1 -1 41 -1 -1 2 -1 2 -8 -1 2 1 1 2 -1 -1 -1 -1 1 -1 -1 -1 -1 -1 -1 -1 -1 -1
18 1 -1 -1 1 -1 -1 -1 40 -1 -1 1 1 1 1 -1 1 -1 2 1 1 -1 -1 -1 2 -1 -1 -1 -1 -1 -1 -1 -1 -1
19 1 -1 -1 1 -1 -1 -1 20 -1 -1 2 -1 2 2 -1 2 2 -1 2 -1 -1 -1 -1 2 -1 -1 -1 -1 -1 -1 -1 -1 -1
20 -1 1 -1 -1 -1 -1 -1 60 -1 -1 -1 -1 -1 -1 -1 2 2 -1 2 -1 2 -1 4 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
G G S O E E E O T B C H J J J S H I O
R R A T A A A T I T O B O C R J J B E S O S H R N C
O O L H R R R H P I N O M O L J J B E E N H B T F S D C
S S R R N N N R S P S N M M Y B E E N G D I H I T A T P
S S Y T T B C W U S U S U M W E N G D A A F A L C L C C
O P P W Y I O O A N A N A N A A G D M M M M T S L H B O O
B A E K P P N M G I M I M I M G H H I I P P W H A N A D D
S Y R S E S S M E T T T T T T E R R N N M M K I T G S X X
16 -1 -1 -1 -1 2 2 2 -1 -1 -1 -1 -1 -1 -1 -8.00 10 6 30 30 AM PM 2 -1 -1 -1 -1 11 1
17 -8 -1 -1 -1 2 2 2 -1 -1 -1 -1 -1 -1 -1 8.00 95 -1 -1 -1 -1 -1 1 -1 -1 -1 41 11 1
18 -1 -1 -1 3 2 2 2 -1 -1 -1 -1 -1 -1 -1 9.75 8 4 0 30 AM PM 2 -1 -1 -1 -1 5 4
19 -1 -1 -1 1 2 1 2 -1 -1 -1 91 25 -1 -1 6.25 5 9 0 0 PM PM 1 -1 -1 -1 -1 6 3
20 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1.00 9 10 0 0 AM PM 2 -1 -1 -1 -1 7 3
EXAMPLE 1 13:31 Thursday, October 18, 2001 8
1998 JOBS RECORDS, AFTER MERGING ON 1997 DATA
Cumulative Cumulative
SICKPAY SICKPAYX Frequency Percent Frequency Percent
--------------------------------------------------------------
-1 . 4 0.1 4 0.1
-1 -9 14 0.3 18 0.4
-1 -8 114 2.6 132 3.0
-1 -7 4 0.1 136 3.1
-1 -1 591 13.5 727 16.7
-1 1 2236 51.2 2963 67.9
-1 2 1402 32.1 4365 100.0
<< previous page
|
Back
Email Updates