Multiple choice technology programming languages

select flightnumber, date, destination, boarded + transferred + nonrevenue as Total from marchflights where total < 100; What will happen when this query is submitted ?

  1. Error: as mathematical computation is not allowed while using proc sql.

  2. ERROR: The following columns were not found in the contributing tables: total.

  3. Warning : the type of the variable total is not declared(character or numeric).But due to automatic conversion, some unexpected value is being populated in variable total.

  4. Error: variable total nor recognized(because there are two spelling - Total and total)
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

SAS PROC SQL evaluates the WHERE clause before the SELECT clause. Therefore, referencing a column alias like total in the WHERE clause without the CALCULATED keyword fails with a column-not-found error.

Keep practicing — related questions