I have a five age categories and want to create a plot for age-standardized rate for a disease over six years. Below is my program but it is giving me an error . Is it because of having six years of data, if so is there any way to overcome this error? Thank you ERROR: At most two study populations can be used for METHOD=DIRECT. data USASTDRATE;
format AgeGroup 2. AgeGroupDesc $5. USA2000 comma12.;
informat USA2000 comma12.;
input AgeGroup AgeGroupDesc $ USA2000;
cards;
1 0-17 70,781,454
2 18-44 108,151,050
3 45-64 60,991,658
4 65-74 18,135,514
5 75+ 16,573,966
;
data CAT1;
format year AgeGroup 8. events population comma12.;
input Year AgeGroup events population;
cards;
2006 1 6 6511656
2006 2 130 9332590
-----
----
2011 5 789 1567143
; run;
Proc sort data=cat1;
by year; run;
ods table STDRATE=Age_ADJ.cat1;
proc stdrate data=cat1
refdata=USASTDRATE irect
stat=rate (mult=100000)
CL=Normal METHOD=DIRECT
;
population group=year event=events total=population ;
reference total=USA2000;
strata agegroup;
run;
... View more
