I need advice about how to calculate a significance test (trend test) for comparing the incidence rates over the years. I need to comment on whether there is a significant increase or decreas (with p-value for a trend) for incidence rates over the years.
Please see the attached data. My denominator for incidence is 100,000 for all.
I would really appreciate if anyone can help me with the SAS code.
Thanks for the reply. The incidence rates are the trends for acute pancreatitis deaths nationally over the years. I wanted to know if there is an increase or decrease in trend over the years. The incidence rates are adjusted for 2010 population (national US population).
I have not done the trend test for comparing rates over the years to check for significance. However, I did Cochran- Armitage Trend test previously for categorical variable. So I am not sure how to do this. I looked up some online blogs about linear regression analysis but not entirely sure. I hope this helps.
Hi, I have a similar question like this. After doing this step, how could I interpret the 0.4463? What is the trend for the data? Since the prevalence or the incidence are not normally distributed, could I just use Simple Regression Model and get the coefficient for the trend? Or is there any other suggestion for this situation? I have a sample data like below. Thanks a lot.
Kendall Tau b Correlation Coefficients, N = 41
You will get a lot more attention if you submit your question as a new topic.
You can get a robust estimate of the slope called Sen's slope (or the Kendall slope estimator) as:
proc sql; create table slope as select median( (b.prevalence-a.prevalence) / (b.year-a.year) ) as senSlope from myData as a inner join myData as b on a.year < b.year; select * from slope; quit;
Did something happen around 2001?
If so you should test before and after separately:
libname xl Excel "&sasforum.\Datasets\Trendtest.xlsx" access=readonly; proc sql; create table trendtest as select *, year>=2001 as period from xl.'Sheet1$'n; quit; proc sgplot data=trendtest; scatter x=year y=amortality_pan; refline 2001 / axis=x; run; proc corr data=trendtest kendall; by period; var year; with amortality_pan; run;
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.