The SELECT clause specifies the columns to select. IdNum is prefixed with a table alias because it appears in two tables. 
   proc sql;
title 'All Flights for Each Supervisor';
   select s.IdNum, Lname, City 'Hometown', Jobcat,
          Flight, Date