If you add the option DEFER = YES to your Teradata pre-assigned libraries, a session should only be opened when the library is opened by the user. This would be considered a best practice option.   Also setting the maximum number of sessions allowed on your libraries may be helpful:   http://support.sas.com/documentation/cdl/en/acreldb/69580/HTML/default/viewer.htm#n0upc7wkfgdssjn103gpyeq90dau.htm   ... View more

Pretty sure it's a precision of storage issue. 31DEC9999:23:59:59 doesn't have an issue because it is integer. As soon as you add the decimals though it starts causing problems.   The **** appear because the storage ends up rounding up to when displayed and SAS hasn't yet provided formats to display year 10,000.   ... View more