Hi it may or may not sound easy and not even sure u can understand what I am trying to do.   My question is that "without using proc" and if my data table is shown like this   Var1 Var2 A        3 A        20 B        1 C        4 C        5   is it possible to sum column values with same var1 value, which means 3+20 because they got Same Var1 value A and 4+5 for C, that makes new variable Var3 on the table.   if I just used Var3 = Var3+Var2; retain Var3 0; it would just give the whole sum of numbers no matter what value they've got on Var1.   ... View more