proc sql;;
create table abc as
select distinct no as id,time
from aaa
where no in (select id from we);
quit;
上面效率太低了。我想把上面这段用用data 步来做,如下,但是如何好像没有可以直接从abc中去重的办法?
where no in (select id from we) 这段是否只能用modify的 _iorc_ 能做到相似的效果?
新手,麻烦给点儿思路。
data abc ;
set Org_data(keep=extid time);
run;
data abc;
modify abc aaa;
by no ;
if (^ _iorc_) then remove;