Alternatively, run the SQL in sas and use sas functions:
[pre]
PROC SQL;
CREATE TABLE XXX AS
SELECT intck('hour',Datetime1,Datetime2) as HoursDifference
FROM mySQLTable;
... View more
Sorry - I meant to convert your example in my answer....
SELECT NAME,DOB,Enrolled from
SQLServer.EnrollmentTable(sasdatefmt=(DOB='date9.' Enrolled='date9.'));
... View more
