Wonder if there's any chance of reviving this as I have a question - I tried using DBSASTYPE in the following context: data SQLlib.TasksNotRun (DBSASTYPE=(LastRunSuccess='DATE')); set TaskList; where LastRunSuccess lt LastExpectedRun; run; This uses an ODBC connection for the 'SQLlib' libname and I'm using SQL Server 2014 for my databases. The input data column, from the table 'TaskList', is in YYMMDD10. format. However the table it creates in SQL has a datetime format for this column. Not a disaster for what I'm using it for, but I wanted my output to look nicer...
... View more