办得到, 跟m的方法是一样的. 但也许分开写比较清楚.
proc sql;
create table xx as
select b.var1, a.var2, b.var3
from (select *, monotonic() as ord, (calculated ord-min(calculated ord)) as ord2 from a1 group by var1) as a right join (select *, monotonic() as ord, (calculated ord-min(calculated ord)) as ord2 from a2 group by var1) as b
on a.var1=b.var1 & a.ord2 =b.ord2;
---debug
proc sql;
create table zz as
select *, monotonic() as ord, (calculated ord-min(calculated ord)) as ord2 from a1 group by var1;
proc sql;
create table zz2 as
select *, monotonic() as ord, (calculated ord-min(calculated ord)) as ord2 from a2 group by var1;
|