Proclib.Delay
data proclib.delay;
input flight $3. +5 date date7. +2 orig $3. +3 dest $3. +3
delaycat $15. +2 destype $15. +8 delay;
informat date date7.;
format date date7.;
datalines;
114 01MAR08 LGA LAX 1-10 Minutes Domestic 8
202 01MAR08 LGA ORD No Delay Domestic -5
219 01MAR08 LGA LON 11+ Minutes International 18
622 01MAR08 LGA FRA No Delay International -5
132 01MAR08 LGA YYZ 11+ Minutes International 14
271 01MAR08 LGA PAR 1-10 Minutes International 5
302 01MAR08 LGA WAS No Delay Domestic -2
114 02MAR08 LGA LAX No Delay Domestic 0
202 02MAR08 LGA ORD 1-10 Minutes Domestic 5
219 02MAR08 LGA LON 11+ Minutes International 18
622 02MAR08 LGA FRA No Delay International 0
132 02MAR08 LGA YYZ 1-10 Minutes International 5
271 02MAR08 LGA PAR 1-10 Minutes International 4
302 02MAR08 LGA WAS No Delay Domestic 0
114 03MAR08 LGA LAX No Delay Domestic -1
202 03MAR08 LGA ORD No Delay Domestic -1
219 03MAR08 LGA LON 1-10 Minutes International 4
622 03MAR08 LGA FRA No Delay International -2
132 03MAR08 LGA YYZ 1-10 Minutes International 6
271 03MAR08 LGA PAR 1-10 Minutes International 2
302 03MAR08 LGA WAS 1-10 Minutes Domestic 5
114 04MAR08 LGA LAX 11+ Minutes Domestic 15
202 04MAR08 LGA ORD No Delay Domestic -5
219 04MAR08 LGA LON 1-10 Minutes International 3
622 04MAR08 LGA FRA 11+ Minutes International 30
132 04MAR08 LGA YYZ No Delay International -5
271 04MAR08 LGA PAR 1-10 Minutes International 5
302 04MAR08 LGA WAS 1-10 Minutes Domestic 7
114 05MAR08 LGA LAX No Delay Domestic -2
202 05MAR08 LGA ORD 1-10 Minutes Domestic 2
219 05MAR08 LGA LON 1-10 Minutes International 3
622 05MAR08 LGA FRA No Delay International -6
132 05MAR08 LGA YYZ 1-10 Minutes International 3
271 05MAR08 LGA PAR 1-10 Minutes International 5
114 06MAR08 LGA LAX No Delay Domestic -1
202 06MAR08 LGA ORD No Delay Domestic -3
219 06MAR08 LGA LON 11+ Minutes International 27
132 06MAR08 LGA YYZ 1-10 Minutes International 7
302 06MAR08 LGA WAS 1-10 Minutes Domestic 1
114 07MAR08 LGA LAX No Delay Domestic -1
202 07MAR08 LGA ORD No Delay Domestic -2
219 07MAR08 LGA LON 11+ Minutes International 15
622 07MAR08 LGA FRA 11+ Minutes International 21
132 07MAR08 LGA YYZ No Delay International -2
440 Appendix 4 • Data Sets for Examples in SQL Procedure Reference