🎴 Flashcard Mode
ABAP and SAS Programming Quiz
Card1 / 20
Mastered0
Review0
QuestionClick to flip
select flightnumber, date, destination, boarded + transferred + nonrevenue as Total from marchflights where total < 100; What will happen when this query is submitted ?
AnswerClick to flip back
A
ERROR: The following columns were not found in the contributing tables: total.
💡 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.