If you show some example of your current data we might have some clues. Basically you need to calculate that count (or rate) from your data and without knowing what your data looks like we can't provide anything targeted to your situation. ... View more

the cochran armitage trend test is a neat one you could likely use: https://support.sas.com/documentation/cdl/en/statug/63347/HTML/default/viewer.htm#statug_freq_sect032.htm ... View more

@EMB wrote: As part of the descriptive analysis I would like to look at trends over time in age of the diagnosed individuals. I am totally not understanding this part.   Trends of what? Your sentence (and code) implies you want to find the trend over time of AGE. That cannot be right. Your age increases 1 year for every 1 year  of change in time. No statistics or regression or p-values needed. ... View more