I have connected to a sql database using sql pass-through in base SAS 9.4. I pulled the table schema and can clearly see that 'filedate' variable is date type.
However, when i pull a subset of the table in via SAS it converts 'filedate' to the text variable - why is this happening?
This is not duplicate question to SAS Date Formats Incompatible with SQL Server Date as the data originates in an sql server and it is SAS that is interrogating that SQL server via an ODBC connection. Although i admit the solution may involve somehow upgrading/changing the ODBC driver.
thanks.