proc sql;
  connect to oracle as conname  (&risk);  
  create table rank_1 as select * from connection to conname   
(
  (select seccode, sec_name, bizdate, nav, bizdate2, nav2, name, bench
  from zx_wind_rank_ind) a

  left join (select bench from zx_wind_bench) b
  
on a.seccode = b.seccode
where bizdate = 20140510 and name = '被动'
);
    disconnect from conname;
quit;

运行日志就显示SQL命令未正确结束，从select seccode开始。

附：zx_wind_rank_ind（第二张）和zx_wind_bench的表