Hi All, I need to get the below SAS SQL query working. Query: ===== SELECT * FROM STUDENT_FEE WHERE INPUT(Calendar_Month, MONYY8.) IN (INPUT('Oct 2011', MONYY8.),INPUT('Dec 2011', MONYY8.)); Issue: Query execution itself fails. ===== It seems in SAS, IN operator in the where clause doesn't accept any functions like INPUT, CAT etc. Again, this looks like a limitation in SAS. Any other better way to rewrite the above query? Note: ==== Below query works fine. We can use SAS functions with any other operators like =, >, <, BETWEEN AND, etc Query: =========== SELECT * FROM STUDENT_FEE WHERE INPUT(Calendar_Month, MONYY8.) = INPUT('Dec 2011', MONYY8.); Please help?
... View more