topic How to print the CI of pearson/spearman correlation coefficient in a SAS dataset? in SAS Enterprise Guide

How to print the CI of pearson/spearman correlation coefficient in a SAS dataset?

HS2 — Tue, 13 Nov 2018 09:12:10 GMT

Hello,

I am working on proc corr and I need to save the output in SAS dataset under WORK library, however the only printed variables are:

MEAN

STD

CORR

Can you please advise?

Re: How to print the CI of pearson/spearman correlation coefficient in a SAS dataset?

RW9 — Tue, 13 Nov 2018 09:16:34 GMT

Apparently the FISHER option produces CI's:

http://support.sas.com/documentation/cdl/en/procstat/63104/HTML/default/viewer.htm#procstat_corr_sect031.htm

Re: How to print the CI of pearson/spearman correlation coefficient in a SAS dataset?

HS2 — Tue, 13 Nov 2018 09:25:29 GMT

Hello,

Thank you 🙂

But actually I want to save this CI under SAS library dataset, below the attached screenshot of the ONLY variables/outputs printed in a dataset under WORK library.

Re: How to print the CI of pearson/spearman correlation coefficient in a SAS dataset?

RW9 — Tue, 13 Nov 2018 09:43:42 GMT

Before the code run:

ods trace on;

This will show in the listing all the objects which are created. You can then re-run the code and save the various output models with:

ods output <object>=<dataset>;

Per:

https://blogs.sas.com/content/iml/2017/01/09/ods-output-any-statistic.html

Re: How to print the CI of pearson/spearman correlation coefficient in a SAS dataset?

HS2 — Tue, 13 Nov 2018 10:12:11 GMT

Thank you!!

It worked 🙂