PROC SQL part -3 Aggregate functions, Group by and other related details 

if you are creating new variable and want to use in where clause then you need to use calculated. This is because how SQL is executed behind the scenes is it starts from "from" clause then where clause and then it goes to select. So where clause does not know about new variables in select. So calculated keyword calculated helps here.

@@kiranvenna thankful