Why are breaking it into so many steps and not writing 1 sql code ??? Proc sql; Create table temp as Select a.zone, a.class, a.target, b.fixed, B.fixed * a.target / c.sum_target as OPT From result a Inner join zones b On a.zone = b.zone Inner join ( select zone, sum(target) as sum_target from result group by zone) as c On a.zone = c.zone; Quit; You could change inner joins to left joins depending on your data
... View more
