11-24-2015 12:36 PM
I have a code . I ran the code but i am getting an error . Can anyone pls help
ERROR: Describe error: IColumnsInfo::GetColumnInfo failed. : Deferred prepare could not be completed.: Statement(s) could not be
prepared.: Incorrect syntax near 'dt'.
proc sql OUTOBS=10;
connect to oledb as cnt
="Provider=SQLOLEDB.1;Integrated Security=yy;Persist Security Info=True;Initial Catalog=price;Data Source=yy" schema=dbo);
create table gg as
select * from connection to cnt (select
FROM yu cct
left outer JOIN Check cc on cc.x = cct.y
where date >= '30MAR2015:00:00:00'dt and cct.VDATE is null;
disconnect from oledb;
11-24-2015 01:41 PM
You are using PASSTHRU to SQL Server so your SQL must conform to what SQL Server accepts, not SAS and using DT on a datetime string is a SAS-specific syntax. Try:
where date >= '2015-03-30'