Thanks. It worked for this case. If becomes more co
proc sql;
select t1.P,
t1.L,
t1.Exp,
t1.cd,
t2.TotalExp,
t1.TotalExpCd
t1.TotalExpL
from
(((select P, L, Exp, sum(Exp) as TotalExpL from t group by P, L) t1
(select P, L, Exp, sum(Exp) as TotalExpCd from t group by P, CD)) t1)
inner join (select P, sum(Exp) as TotalExp from t group by P) t2
on t1.P=t2.P ;
quit;
mplicated with one more variable for sorting (see below), how can we proceed?
... View more
