02-19-2016 04:23 AM
SQL Server 2014
I am stuck with an issue when pulling the data from SQL through an ODBC connection. I am using the below code.
connect to odbc (&connectA);
create table test as
select * from
connection to odbc
(select * from [DB - Production].pri.test) ;
disconnect from odbc;
When I run the code it gives me the above error. When I investigated it there is a column in SQL that SAS doesn't like which is 'ABCDE' in (time(0), null) format. The rest of the columns are coming along fine.
What I should I do to pull this column along with others without erroring?
Thanks in advance for your help.
02-19-2016 06:27 AM
I see nothing in your query that calls for an explicit pass-thru.
Use a libname connection instead. If you still got problems, IMHO is that it's easier to trouble shoot.
02-19-2016 07:25 AM
02-19-2016 07:53 AM