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

Is there a way by which I can force SAS to treat all variables as character instead of number. I basically want to override SAS's approcah of treating everything as NUMBER ... View more

Yes I have date feilds but I have converted it to character while selecting e.g to_char(ambs.D_CLSE,'yyyy-mm-dd') . The put statement is as below: disconnect from oracle; quit; filename out "$DDIR/trmd699b.dat" ; data _null_; set v_credit_card; file out noprint notitles dlm=',' DSD DROPOVER LRECL=32767; put N_ACCT N_CLG N_CUST_01 N_CUST_02 N_CUST_03 N_CUST_04 N_CUST_05 N_CBS_SCOR_RAW_01 N_CBS_SCOR_RAW_02 N_CBS_SCOR_RAW_03 N_CBS_SCOR_RAW_04 N_CBS_SCOR_RAW_05 N_CBS_SCOR_FINL_01 N_CBS_SCOR_FINL_02 N_CBS_SCOR_FINL_03 N_CBS_SCOR_FINL_04 N_CBS_SCOR_FINL_05 ------------------------------------------ ------------------------------------------ run; ... View more