Desktop productivity for business analysts and programmers

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

Reply
N/A
Posts: 0

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

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
SAS Employee
Posts: 159

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

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.
Ask a Question
Discussion stats
  • 1 reply
  • 176 views
  • 0 likes
  • 2 in conversation