Hello -
I am using SAS EG 7.1. I am trying to convert a date time field in my data set to date9. format and can't seem to crack it. My where clause has a condition like this:
AND t1.txn_reqst_dt BETWEEN &dateS and &dateE
The &dateS and &dateE variables have already been converted to date9. format when i declared my global variables, however, the txn_rqst_dt field is a date time stamp field that looks like this 04MAY2018:13:15:32.238000
This is the error i get:
76 AND datepart(t1.txn_reqst_dt) BETWEEN &dateS and &dateE NOTE: Line generated by the macro variable "DATES". 76 01Jan2018 _______ 22 76 ERROR 22-322: Syntax error, expecting one of the following: !!, *, **, +, -, /, AND, ||.
ERROR 76-322: Syntax error, statement will be ignored.
Any suggestions?
Thank you!!
... View more