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
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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.