Obsidian | Level 7

## Use sum of column in calucation for new variable

Hi guys,

struggling with a formula for a new variable. Essentially I want a new variable to be Variable C =Variable A/((Variable B/sum(Variable B))*sum(Variable A).

Seems simple but cant get it to work. If I can get a simple element which gives the column total to use in the formula that would be great.

 Sector Variable A Variable B Variable C 1 3 600 2 200 3,000 3 7 200 4 50 800 5 70 1,000
1 ACCEPTED SOLUTION

Accepted Solutions
Amethyst | Level 16

## Re: Use sum of column in calucation for new variable

Hope this what you are expecting

``````data have;
input Sector VariableA VariableB;
cards;
1 3 600
2 200 3000
3 7 200
4 50 800
5 70 1000
;

proc sql;
create table want as select sector, VariableA, VariableB, (select sum(variableB) from have ) as sumB, (select sum(variableA) from have ) as sumA,
VariableA/((VariableB/(select sum(variableB) from have ))*(select sum(variableA) from have)) as variableC
from have;
quit;``````
Thanks,
Jag
Amethyst | Level 16

## Re: Use sum of column in calucation for new variable

Hope this what you are expecting

``````data have;
input Sector VariableA VariableB;
cards;
1 3 600
2 200 3000
3 7 200
4 50 800
5 70 1000
;

proc sql;
create table want as select sector, VariableA, VariableB, (select sum(variableB) from have ) as sumB, (select sum(variableA) from have ) as sumA,
VariableA/((VariableB/(select sum(variableB) from have ))*(select sum(variableA) from have)) as variableC
from have;
quit;``````
Thanks,
Jag
Discussion stats