Sticky-note

The CREATE TABLE statement creates the table FLIGHTS from the output of the query. The SELECT clause selects the unique values of Dest. DISTINCT specifies that only one row for each value of city be returned by the query and stored in the table FLIGHTS. The FROM clause specifies PROCLIB.MARCH as the table to select from.

proc sql;
   create table flights as
      select distinct dest
         from proclib.march;

   title 'Cities Serviced by the Airline';