CODEWITHSUNDEEP
sql-serverdatesasproc-sql
John Chrysostom
John Chrysostom

Reputation: 3963

Insert Date Field to MS SQL from Proc SQL

I'd like to insert a date field into a SQL server table form Proc SQL in SAS. Here is my code for Proc SQL:

proc sql;
    insert into CFS_SQL.Data_DSB_Raw(sasdatefmt=(TheDate='mmddyy10.'))
    select TheDateIncoming
    from Work.Upload;
quit;

According to the SAS help documentation (http://support.sas.com/kb/6/450.html), this should work as long as TheDateIncoming also has format mmddyy10.. I've verified that the format on TheDateIncoming is correct, so I think this should work.

Unfortunately, however, I'm getting a "Value 1 on the SELECT clause does not match the data type of the corresponding column" error.

Any thoughts?

Upvotes: 0

Views: 573

Answers (1)

John Chrysostom
John Chrysostom

Reputation: 3963

Annnnnd... solved. It actually had nothing to do with the code. It was a driver problem. Switching to the SQL Server Native Client 11.0 ODBC driver fixed the issue.

Upvotes: 0

Related Questions