This is why at first I was asking to use SAS macro/array because there are so many rows and columns, it is time  consuming if I type c, d, e, f, or replace it one by one ... View more

Here it is. For the first one, RR is set to be 1 as the reference. All other calculations are based on this one. please see a file attached ... View more

relative risk or risk ratio (RR) is the ratio of the probability of an event occurring (for example, developing a disease, being injured) in an exposed group to the probability of the event occurring in a comparison, non-exposed group. Relative risk includes two important features: (i) a comparison of risk between two "exposures" puts risks in context, and (ii) "exposure" is ensured by having proper denominators for each group representing the exposure [1][2] Risk Disease status Present Absent Smoker Non-smoker Consider an example where the probability of developing lung cancer among smokers was 20% and among non-smokers 1%. This situation is expressed in the 2 × 2 table to the right. Here, a = 20, b = 80, c = 1, and d = 99. Then the relative risk of cancer associated with smoking would be Smokers would be twenty times as likely as non-smok   please note the first group's RR=1 ... View more

I am requried to calulate relative risks. Certainly, I am interested the codes that can do both works, calculating RR and OR. Thanks. ... View more

count only once   the agegroup is classfied at the beginning of research, no more agegroup variable later     we only analyze the patient once;   Just as the first one who provided code for me---unfortunately, he provided a sample code for variables with two categories----that is same as what I have read and learned online. I need, in stead, a sample code for variables with more than two catogories, like age groups.       ... View more

my data is not already in counts. First, I used SQL to put those different datasets together (different communities). Then, I use proc freq to calculte counts. Then, I calculate RR. I have to use excel to calculate, one by one, which is very slow. So I am thinking whether I can speed up with macro code ... View more