add p values to output dataset of proc corr

[csetzkorn]

I am using this code:

proc sort data= SomeData;
	by SomeGroup;
run;

proc corr data=SomeData nosimple pearson spearman outp=Temp;
	var x y;
	by SomeGroup;
run;

Is there a way to get the p values into the output dataset Temp as well? I get correlations for values, which are definitely not correlated. So maybe a p value threshold could help ...

[Reeza]

Aren’t P-Values in the output?

If so, use the ODS table instead, 

ods output pearsonCorr=want;

[csetzkorn]

Thanks please adopt my original code as I do not understand. I also have the suspicion the my sas version does not produce p values.

[Reeza]

What version of SAS are you using?

You add that single line of code into your proc corr procedure, exactly as is. Then a data set is created called WANT, check your log.

If this doesn't work, please post your log and the exact code submitted.

[Rick_SAS · Accepted solution]

As Reeza says, use ODS OUTPUT to save any statistic.  See http://support.sas.com/kb/22/848.html

Since you have BY groups, use ODS EXCLUDE to suppress the output to the screen:

ods exclude all;
proc corr data=SomeData;
ods output PearsonCorr=P;
	var x y;
	by SomeGroup;
run;
ods exclude none;

proc print data=P; run;