topic Re: Inserting datatime values in sql server in New SAS User

Inserting datatime values in sql server

shubham1 — Wed, 23 Oct 2019 09:55:57 GMT

hello

z='2019-10-23 00:00:00.000000'

I am trying to insert this value character value 2019-10-23 00:00:00.000000 by putting in a macro variable x in to a sql server table

call symput ('x',z)

the column that i am ineserting is OP_DATO which is defined as datetime2(6) in sql server

when i am inserting through sas 9.4 i am getting this error

Value 1 on the SELECT clause does not match the data type of the corresponding column listed after the INSERT table name

Is this a problem with SAS 9.4 because it was working with SAS 9.2 .what is the solution for sas 9.4

Re: Inserting datatime values in sql server

Amir — Wed, 23 Oct 2019 11:41:51 GMT

If it used to work before then check the order of the variables in your data set when compared with the order of the values in the insert statement, as described in:

https://communities.sas.com/t5/SAS-Procedures/SQL-insert-error/td-p/77278

If that is not the solution then please post the code you are using with some example data that can be inserted into an example data set.

Amir.

Re: Inserting datatime values in sql server

Amir — Wed, 23 Oct 2019 11:45:49 GMT

When I did a web search for the error message you posted, the 2nd link I found looks like it might be of help - "Problem Note 62503: An error is returned when you try to add datetime values to an SQL Server table using a libref with SAS/ACCESS® Interface to OLE DB":

http://support.sas.com/kb/62/503.html

Amir.