topic Re: Set non-significant correlation to zero when output to dataset? in Statistical Procedures

Set non-significant correlation to zero when output to dataset?

waana — Sun, 23 Jan 2011 20:22:17 GMT

Hi guys,

Use proc corr we can produce correlation matrix, but some pairwise correlations are not significant. Is there any way to set non-significant correlations to 0 in the matrix?

Thanks,

Re: Set non-significant correlation to zero when output to dataset?

Ksharp — Mon, 24 Jan 2011 04:46:46 GMT

Hi.
Maybe you need 'ods output' to write the result into a dataset.then use data step to set zero.

[pre]
ods trace on;
ods output pearsoncorr=corr;
proc corr data=sashelp.class;
var weight height;
run;
ods output close;
ods trace off;
[/pre]

Ksharp

Re: Set non-significant correlation to zero when output to dataset?

plf515 — Fri, 28 Jan 2011 13:10:25 GMT

> Hi guys,
>
> Use proc corr we can produce correlation matrix, but
> some pairwise correlations are not significant. Is
> there any way to set non-significant correlations to
> 0 in the matrix?
>
> Thanks,

Why would you wish to do this? Perhaps there is a good reason, but I cannot think of one. If a correlation is not significant, it does NOT mean it is 0. Creating a matrix where nonsignificant correlations are reported as 0 is .... well, it's distorting your data. It seems to be to be equivalent to any other method of changing results. Not good.

Peter