Thanks, Patrick! I should have searched the SAS Usage Notes first, before posting here. Yes, I am using the "SAS/ACCESS Interface to OLE DB" driver to access SQL Server data from SAS code. After reading the link you provided, it sounds like that should fix my problem. I'll try it out next week, when everyone is back in the office after Thanksgiving break. UPDATE: It worked! Based on a similar Usage Note for SAS/ACCESS Interface to OLE DB - http://support.sas.com/kb/39/188.html -- we just changed our PROVIDER= parameter to Provider=SQLNCLI10.1 in our LIBNAME xxx OLEDB ...; statement, and the date fields are now downloading correctly from SQL Server 2008 into SAS numeric date variables.
... View more