I just looked at the output and it helps to complete the order by line: proc sql; create table want as select *,measure-sum_measure as calculated_value from( select *,sum(measure) as sum_measure from have group by id) order by id,measure;
... View more