proc sql;
   create table usesql as
      select revenue.FlightID, revenue.Date format=date9.,
             expenses.Expenses, revenue.Origin, 
             revenue.Dest, 
             revenue.Rev1st, 
             revenue.RevBusiness,  
             revenue.RevEcon,
             sum(revenue.Rev1st, 
                 revenue.RevBusiness,
                 revenue.RevEcon) 
                 - Expenses as Profit, 
             airports.City, 
             airports.Name
      from ia.expenses, ia.revenue, ia.airports
	  where 
           expenses.FlightID = revenue.FlightID
       and expenses.Date = revenue.Date
       and airports.Code = revenue.Dest
       order by revenue.FlightID, 
                revenue.Date,
                revenue.Dest;
   title 'Result of Joining Three Data Sets';
   select * from usesql;
quit;