peterpan_aus 发表于 2012-7-26 14:35 
不好意思我是对你楼上的问得,刚才没看见你的,太感谢了!不过好像你也有一样的问题,因为每次不一定是 ...
data _null_;
set ex1;
if ORIGIN_COUNTRY="OTHER" then call symput('other',ORIGIN_LOAD);
run;
proc sql;
create table c as
select b.*,(case when a.ORIGIN_LOAD is null then &other else a.ORIGIN_LOAD end ) as ORIGIN_LOAD
from ex2 b left join ex1 a on a.ORIGIN_COUNTRY=b.Country;
quit;