Expected output is flightdate flight number destination delay raw datasets; flightdelays; informat Date date9.; input FlightNumber $ 1-3 @6 Date date9. Origin $ 17-19 Destination $ 22-24 DelayCategory $ 27-41 DestinationType $ 44-58 DayOfWeek 61 Delay @65; format date date9.; datalines; 182 01MAR2000 LGA YYZ No Delay International 4 0 114 01MAR2000 LGA LAX 1-10 Minutes Domestic 4 8 202 01MAR2000 LGA ORD No Delay Domestic 4 -5 219 01MAR2000 LGA LHR 11+ Minutes International 4 18 439 01MAR2000 LGA LAX No Delay Domestic 4 -4 387 01MAR2000 LGA CPH No Delay International 4 -2 data sasuser.marchflights; informat Date date9. DepartureTime time5.; input FlightNumber $ 1-3 @6 Date date9. @17 DepartureTime time5. Origin $ 19-21 Destination $ 29-31 Distance 34-37 Mail 40-42 Freight 45-47 Boarded 50-52 Transferred 55-56 NonRevenue 59 Deplaned 62-64 PassengerCapacity 67-69; format Date date9. DepartureTime time5.; datalines; 182 01MAR2000 8:21 LGA YYZ 366 458 390 104 16 3 123 178 114 01MAR2000 7:10 LGA LAX 2475 357 390 172 18 6 196 210 202 01MAR2000 10:43 LGA ORD 740 369 244 151 11 5 157 210 219 01MAR2000 9:31 LGA LHR 3442 412 334 198 17 7 222 250 439 01MAR2000 12:16 LGA LAX 2475 422 267 167 13 5 185 210 387 01MAR2000 11:40 LGA CPH 3856 423 398 152 8 3 163 250 290 01MAR2000 6:56 LGA WAS 229 327 253 96 16 7 117 180 523 01MAR2000 15:19 LGA ORD 740 476 456 177 20 3 185 210 982 01MAR2000 10:28 LGA DFW 1383 383 355 49 19 2 56 180 622 01MAR2000 12:19 LGA FRA 3857 255 243 207 15 5 227 250 821 01MAR2000 14:56 LGA LHR 3442 334 289 205 13 4 222 250
... View more
