function - Computing variance and co variance in a data statement -
i have 8 columns in dataset, , run data statement in sas such as:
(this pseudocode)
data mynewset; set myoldset; variance1 = variance(column1,column2,column3,column4); variance2 = variance(column5,column6,column7,column8); covariance = covariance(<column1,column2,column3,column4>,<column5,column6,column7,column8>); run;
how can setup var , covar functions in sas ? (btw i'm not interested in proc)
fyi - mathematical formulas here.
for row-wise variance (ie, variance of several values in row), there function, var
, compute you.
var_x = var(of x1-x4);
for example compute variance of x1,x2,x3,x4.
there not similar covariance function; need compute directly formula, ie,
cov(x,y) = sum((x-xmean)*(y-ymean) / n
you using array , do
loop.
Comments
Post a Comment