topic Re: add p values to output dataset of proc corr in SAS Procedures

add p values to output dataset of proc corr

csetzkorn — Tue, 23 Jan 2018 17:02:14 GMT

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 ...

Re: add p values to output dataset of proc corr

Reeza — Tue, 23 Jan 2018 17:11:43 GMT

Aren’t P-Values in the output?

If so, use the ODS table instead,

ods output pearsonCorr=want;

Re: add p values to output dataset of proc corr

Rick_SAS — Tue, 23 Jan 2018 19:43:44 GMT

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;

Re: add p values to output dataset of proc corr

csetzkorn — Tue, 23 Jan 2018 19:41:35 GMT

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.

Re: add p values to output dataset of proc corr

Reeza — Tue, 23 Jan 2018 19:43:29 GMT

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.