Hi,
I am trying to obtain age-standardised rates and have got Groupvar, Agevar, CASES and POP, which i use in the standardisation.
It calculates properly. However, when I try to enter a by_variable (i.e. location) i get an error message:
"ERROR: The stratum in the REFDATA= data set, Age_5yr_65= 5, does not have a matched stratum in the DATA= data set."
I've got Age_5yr_65= 5 in STANDARD_POP data, in CASES data and POP data. I can calculate adj.rates separately for each location. I've also checked that I do not have zeros or missing values or even small values. Everything looks good, but the command does not work. Am I missing something or using it in a wrong way? Any advice is greately appreciated.
My syntax:
proc stdrate data=CASES_POP
refdata=STAND_POP
method=direct
stat=rate(mult=1000)
cl=Normal
effect;
POPULATION group=INDIG event=CASES total=POP;
REFERENCE total=POP;
STRATA Age_5yr_65/effect;
BY LHN;
run;