DATA Step, Macro, Functions and more

Calculating Confidence intervals for observed/expected ratios

Reply
Occasional Contributor
Posts: 14

Calculating Confidence intervals for observed/expected ratios

I have a simplified dataset: runner name, run trial (there are 10 trials), observed time for each trial, expected time for each trial.

I sum up my observed and expected times using proc means and output a dataset.I then use the data statement to calculated a ratio for observed / expected for each runner. how do i calculate a confidence interval to see if there is a difference in o/e between my runners? 

PROC Star
Posts: 551

Re: Calculating Confidence intervals for observed/expected ratios

I'm not sure if this is what you are efter, but you can request confidence limits for the mean by specifying the CLM option in the PROC MEANS statement.

 

An example is in the PROC MEANS documentation here

 

http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a002473542.htm

Occasional Contributor
Posts: 14

Re: Calculating Confidence intervals for observed/expected ratios

Hi, Thanks for responding. It's not the mean value I want per runner. I was the ratio for each runner.

SAS Super FREQ
Posts: 3,478

Re: Calculating Confidence intervals for observed/expected ratios

You should post some sample data, which will make it easier for people to help you.

 

You might consider the difference in the runner's time, rather than the ratio. If you have several runners and you want to compare their mean times and determine if the mean times are significantly different, you can use PROC GLM to run an ANOVA and a multiple comparison of means. There are several examples in the PROC GLM doc, including one that treats repeated observations.

 

Ask a Question
Discussion stats
  • 3 replies
  • 77 views
  • 0 likes
  • 3 in conversation