0

My data set is really simple, just one colum with a ratio and another colum with a categorical var, I need to calculate the standard deviation for each class as well as the confidence interval.

Is there a built in function in SAS (proc SQL) to calculate the conficende interval of the standar deviation??? something like the excel function confidence() does?

thanks!

Soly
  • 111
  • 2
  • 8
  • Why are you asking for PROC SQL specifically? There are lots of built in procedures in SAS happy to provide you both of those values more efficiently than coding it in PROC SQL. – Joe Apr 07 '14 at 15:31
  • for example? i just had it all done with proc SQL and wondered if it was possible with a function.. but im open to suggestions! – Soly Apr 08 '14 at 07:11

1 Answers1

0

Not Proc SQl but PROC Univariate will give you the confidence intervals of mean, standard deviations and variance. The details are available in SAS support documents:

https://support.sas.com/documentation/cdl/en/procstat/63104/HTML/default/viewer.htm#procstat_univariate_sect064.htm

The following statements produce confidence limits for the mean, standard deviation, and variance of the population of heights:

ods select BasicIntervals;
proc univariate data=Heights cibasic;
   var Height;
run;
Keneni
  • 705
  • 5
  • 12