How to divide each instance of a variable by the total sum of the variable itself?

j4copo — Mon, 08 Jul 2013 18:45:39 GMT

Hello everybody,

here it is my first ever loggin into the sas community and my first question. I am a really newbie of SAS then thanks in advance for all the help you will be able to give me. My problem is the following:

In my dataset I have a variable measuring some kinf of exposure for each instance,

ID Exposure

1 0.45

2 0.56

3 1.46

... ....

100 0.34

Let's say the total exposure is 35.2, I need to add a new column to this dataset measuring the relative exposure for each instance, that is:

ID Exposure Relative_exposure

1 0.45 0.45/35.2

2 0.56 0.56/35.2

3 1.46 1.46/35.2

... .... ....

100 0.34 0.34/35.2

I am sure this is pretty simple, but I am facing problems using with the proc sql. thanks for your help!

Jacopo

Re: How to divide each instance of a variable by the total sum of the variable itself?

ChrisHemedinger — Mon, 08 Jul 2013 19:12:26 GMT

Something like this perhaps?

data have;

length ID $ 3 Exposure 8;

input ID Exposure;

datalines;

1 0.45

2 0.56

3 1.46

100 0.34

run;

proc sql ;

create table want as select

ID,

Exposure,

exposure/sum(exposure) as relative_exposure

from have;

quit;

Hint: next time post the question in one of the specific forums, such as .

Chris

topic Re: How to divide each instance of a variable by the total sum of the variable itself? in SAS Programming

How to divide each instance of a variable by the total sum of the variable itself?

Re: How to divide each instance of a variable by the total sum of the variable itself?