proc sql outobs=10; select flightnumber, date, destination, boarded + transferred + nonrevenue as Total from sasuser.marchflights
proc sql outobs=10;
select flightnumber, date, destination,
boarded + transferred + nonrevenue
as Total
from sasuser.marchflights
where total < 100;
519 proc sql outobs=10;
520 select flightnumber, date, destination,
521 boarded + transferred + nonrevenue
522 as Total
523 from sasuser.marchflights
524 where total < 100;
ERROR: The following columns were not found in the contributing tables: total. |
proc sql outobs=10;
select flightnumber, date, destination,
boarded + transferred + nonrevenue
as Total
from sasuser.marchflights
where calculated total < 100;
where boarded + transferred + nonrevenue <100;
proc sql outobs=10;
select flightnumber, date, destination,
boarded + transferred + nonrevenue
as Total,
calculated total/2 as Half
from sasuser.marchflights;
3.139.105.159