Using Age at Diagnosis in Selection and Table Tabs

In a Limited-Duration Prevalence session, care should be taken if selecting or displaying cases by age at diagnosis, especially if percents are being calculated. In prevalence, age at diagnosis is not linked to the population data (age at prevalence is), and therefore, populations will not be affected by the use of this variable. When using this variable, the responsibility is left to you to understand the population at risk for any given statistic. By definition, some statistics may be zero while others may be incomplete.

For example, age at diagnosis could be used to calculate the prevalence of childhood cancers. Suppose that you want to calculate 24-year limited-duration prevalence of childhood cancer. For this example, we will define childhood cancer as any cancer diagnosed at an age less than 20 years old. In this case, all estimated prevalence statistics will be for people with a prevalence age less than 44 years. Someone diagnosed with cancer at an age less than 20 within the previous 24 years could not be over 43 years old at the prevalence date. The populations will not be automatically subsetted to account for this.

Consider the results calculated for this example for each age group. If calculating 24-year limited-duration prevalence for childhood cancer (age at diagnosis is less than 20), then the following statements are true:

Age at prevalence is 0-23:

Age at prevalence is 24-43:

Age at prevalence is 44 or older:

The concepts described above are particularly important when evaluating table cells for age groups that overlap. For example, the cells for age at prevalence equal to 40-44 and all ages combined include people who could not be counted by definition as well as people who could. These cells could be easily misinterpreted.