You are using SQL passthru so your SQL must conform to Oracle's requirements. '01-01-2015 00:00:00'dt is not a valid Oracle datetime string. Try removing the DT on the end - this is SAS-specific syntax. Just using a date like '01-JAN-2015' may also work.
... View more
