Guys I have found out the problem and fixed it. If anyone face this problem again, please bear in mind that Oracle date and SAS date formats are not at all same. You have to explicitly give the date format in your select query written in proc sql. eg. The following statement select 'a' from dual where sysdate='21/JAN/2010' will work in sql prompt. But if you embed it in SAS there is a problem. You have to modify this statement into select 'a' from dual where sysdate= to_date('21/JAN/2010','dd/mon/yyyy') thanks everyone ... ... View more