BookmarkSubscribeRSS Feed
chennupriya
Quartz | Level 8

Hi ,

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
(init_string
="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
                                cc.x,
                                cct.y,
                                 cc.z,
                                 cc.n,
                                 cct.l,
                                 cct.k
 
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;
quit;
      

3 REPLIES 3
kannand
Lapis Lazuli | Level 10

Try changing to 

where date >= datepart ('30MAR2015:00:00:00'dt) 

Good Luck...!!! 

Kannan Deivasigamani
chennupriya
Quartz | Level 8

its the same error 😞

SASKiwi
PROC Star

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'

sas-innovate-2024.png

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.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 1708 views
  • 0 likes
  • 3 in conversation