I have a data set that looks like this:
yoc agegroup ipd denominator
1995 <6mo 18 3036.63
1995 6mo-<1 18 3036.63
1995 1-<2 27 6073.25
1995 2-<5 17 18219.8
1995 5-<18 12 68150.8
1995 18-<40 21 78148.2
1995 40-<65 27 44356
1995 65+ 19 13803
1996 <6mo 3 2846.88
1996 6mo-<1 8 2846.88
1996 1-<2 23 5693.75
1996 2-<5 17 17081.3
1996 5-<18 5 69015
1996 18-<40 27 78065
1996 40-<65 36 45527
1996 65+ 31 14166
1997 <6mo 7 2687.25
1997 6mo-<1 12 2687.25
1997 1-<2 23 5374.5
etc. I would like to calculate a rate of disease for each age group (agegroup) and year (yoc) using the IPD (case count) and the denominator (denominator). Can this be done with an ir command to also generate p values and confidence intervals? I've tried using IR but it gives me one overall rate, I need it broken down by both age group and year.
yoc agegroup ipd denominator
1995 <6mo 18 3036.63
1995 6mo-<1 18 3036.63
1995 1-<2 27 6073.25
1995 2-<5 17 18219.8
1995 5-<18 12 68150.8
1995 18-<40 21 78148.2
1995 40-<65 27 44356
1995 65+ 19 13803
1996 <6mo 3 2846.88
1996 6mo-<1 8 2846.88
1996 1-<2 23 5693.75
1996 2-<5 17 17081.3
1996 5-<18 5 69015
1996 18-<40 27 78065
1996 40-<65 36 45527
1996 65+ 31 14166
1997 <6mo 7 2687.25
1997 6mo-<1 12 2687.25
1997 1-<2 23 5374.5
etc. I would like to calculate a rate of disease for each age group (agegroup) and year (yoc) using the IPD (case count) and the denominator (denominator). Can this be done with an ir command to also generate p values and confidence intervals? I've tried using IR but it gives me one overall rate, I need it broken down by both age group and year.
Comment