How to compare datetime value (02JAN2007:00:00:00)

[deleted_user]

I m using a query
proc sql;
select count(*) into :mCount from AMDEXSTG.EX_AR1_ACCOUNT where CANDIDATE_FILE_EXTRACT_DATE = 02JAN2007:00:00:00;
quit;
but it is throwing the syntax error.Please for this query

[GertNissen]

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.