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
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.