The alias THREE refers to the entire query. The names in parentheses become the names for the columns in the output. The label Job Category appears in the output instead of the name Jobtype because PROC SQL prints a column's label if the column has a label.
                as three (Surname, Emp_ID, Hometown, 
                           Jobtype, FlightNumber, FlightDate);