O'Reilly logo

SAS 9.4 SQL Procedure User's Guide, Fourth Edition, 4th Edition by SAS Institute

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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
442 Appendix 4 Data Sets for Examples in SQL Procedure Reference

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required