proc sql;
create table cc.test1 as
select distinct a.loan_id,a.date,max(b.date) as tran_date,a.amount,avg(b.balance) as avg_balance
from cc.loans as a,cc.trans as b
where a.account_id=b.account_id
order by a.loan_id;
quit;


需要联立cc.loans  和cc.trans,然后需要找出最晚的b.date.我就是不知道该怎么找。
上面的代码是我写的，但是输出后对于所有的loan_id，tran_date和avg_balance都是一样的。
求大神教导正确的应该怎么做！！谢谢！！非常感谢!!
想不出来的感觉真的好难受啊!!!