Hello Friends,
SAS 9.3
EG 5.1
SQL Server 2014
Windows 7
I am stuck with an issue when pulling the data from SQL through an ODBC connection. I am using the below code.
proc sql;
connect to odbc (&connectA);
create table test as
select * from
connection to odbc
(select * from [DB - Production].pri.test) ;
disconnect from odbc;
quit;
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.
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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.