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

Reply
Occasional Contributor
Posts: 8

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

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

Community Manager
Posts: 2,953

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

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

Ask a Question
Discussion stats
  • 1 reply
  • 170 views
  • 0 likes
  • 2 in conversation