Using either SAS/ACCESS Interface to ODBC or SAS/ACCESS
Interface to OLE DB,  with the libname engine statement
to access a SQL Server database from SAS, and then using
a datastep or Proc SQL to create a table in the SQL Server
database from SAS can return the following error:

   libname mylib odbc dsn=SQLServ user=xxxx pwd=yyyyy schema=dbo;

   proc sql;
   create table mylib.NewTable as
     select *
     from SASData;
   quit;

   ERROR: During insert:  Data was not set for one or more columns.
   Data value overflow for column COLUMN_NAME.

This error will be returned when the data set contains a date that
is not within the range of valid dates for SQL Server.

Date and time data is stored by SQL Server using the datetime and
smalldatetime data types.

Use datetime to store dates in the range from January 1, 1753
through December 31, 9999.

Use smalldatetime to store dates in the range from January 1, 1900
through June 6, 2079.

Operating System and Release Information