/*  C03S2D01.sas  */

/* 1. SET statement in the DATA step */

data schedule;
  set ia.Schedule ia.SESchedule;
run;
/* 2.  OUTER UNION CORRESPONDING operator in PROC SQL */

proc sql;
   create table schedule as
       select *
          from ia.Schedule
       outer union corr
       select *
          from ia.SESchedule;
quit;

/* 3.  PROC APPEND */
/*  DO NOT SUBMIT  */

proc append base=ia.Schedule data=ia.SESchedule;
run;

/* 4. INSERT INTO statement in PROC SQL */
/*  DO NOT SUBMIT  */

proc sql;
   insert into ia.Schedule
      select ' ' as AircraftID,
                FlightNumber,
                RouteNumber,
                RouteStart,
                RouteDestination,
                RouteDistance,
                . as StartTimeAdjust,
                . as DestinationTimeAdjust,
                ScheduledDepartureTime,
                ScheduledArrivalTime,
                FirstClassCapacity,
                . as BusinessCapacity,
                EconomyCapacity,
                TotalPassengerCapacity,
                CargoCapacity,
                ScheduledDate
         from ia.SESchedule;
quit;