Home Page for the TeradataForum

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.



  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020