Archives of the TeradataForum

Message Posted: Tue, 19 Dec 2006 @ 17:58:47 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: Standard deviation for multiple columns

From:		Victor Sokovin

I think stddev_samp and stddev_pop takes only one column as argument.

Is there a function in Teradata Sql to calculate standard deviation for multile columns like a SAS std(x,y)?

          > X       Y
          > -----   ---
          > 1       2
          > 2       3
          > 4       5
          > 6       7

stddev_samp and stddev_pop operate on scalars only. In SAS, what does this std(x,y) really mean? Any chance it could be the covariance between x and y? If so, then TD has covar_samp and covar_pop. Otherwise, if you really need vectors and not scalars then there is no equivalent.

Regards,

Victor