I think I find the answer. it is folowing logic proc sql;
create table allvars as
select var1 from dataset
union
select var2 from dataset
union
select var3 from dataset;
quit;
... View more
origin file group weight01 weight02 weight03 A 1 2 3 A 4 5 6 B 7 8 9 B 6 5 4 I woul like to group weight A 1 A 4 B 7 B 6 A 2 A 5 B 8 B 5 A 3 A 6 B 9 B 4
... View more
Thank you very much, Yes, My data is already in dataset. It is very helpful but it is not exactly what I need. What I need is (A1*B1+A2*B2+A3*B3) divided by A1+A2+A3 for every group (X1,X2,X3) thank you
... View more