05-06-2013 05:56 PM
I am using proc SQL to create datasets on the SQL server. I have in the SAS dataset the format mm/dd/yy, but when I create the dataset on the server I get 31DEC1959:00:00:00.000.
How can I get the SQL server to show a date with the format mm/dd/yy...I don't need all the time stamp info.
05-06-2013 08:11 PM
This link may be helpful:
I suspect your column is being created with a data type of SQL_TIMESTAMP. You can confirm this by browsing the table in MS SQL Server Management Studio.
Try setting the data type explicitly using the DBTYPE = option, as referred to in the above link.