I m using a query
select count(*) into :mCount from AMDEXSTG.EX_AR1_ACCOUNT where CANDIDATE_FILE_EXTRACT_DATE = 02JAN2007:00:00:00;
but it is throwing the syntax error.Please for this query
When using SAS Dates you would write '02JAN2007'd and when using datetime try '02jan07:0:00:00'dt
Whether this will work also depends on what database "AMDEXSTG" is, and how you connect to it (ODBC or SAS/Connect) - it not always that a SAS datetime is translated properly when transformed to another database.