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'

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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