topic Re: Correlation Transformation in Statistical Procedures

Correlation Transformation

jjadall1 — Mon, 20 Oct 2014 14:24:05 GMT

Hello,

I have data that I need to do a correlation transformation for. What is the general code to complete a correlation transformation? After I receive this, I will try it with my data.

Thanks very much!

Jadallah

Re: Correlation Transformation

PaigeMiller — Mon, 20 Oct 2014 14:46:18 GMT

That's a very vague phrase "correlation transformation". Could you provide some more information about what it is you want to do?

Re: Correlation Transformation

jjadall1 — Mon, 20 Oct 2014 15:03:12 GMT

Hi Paige,

I have a regression with 5 variables in it. I need to do a correlation transformation to standardize the variables. Should I use proc transreg or possibly something like the following?

Data step2;

set "put your data file here";

/* now redefine new variables */

x2n = (x2 - x2bar) / x2sd * 1/sqrt(n-1);

Thanks!

Jadallah

Re: Correlation Transformation

PaigeMiller — Mon, 20 Oct 2014 15:05:18 GMT

You could use PROC STANDARD to standardize the variables ...

Re: Correlation Transformation

Rick_SAS — Mon, 20 Oct 2014 15:21:05 GMT

PROC STDIZE has many variable transformations. See the complete list at SAS/STAT(R) 13.1 User's Guide

Are you sure that you want 1/sqrt(n-1) as part of the transformation? The usual standardization is (x-xbar)/std, which is METHOD=STD.

Re: Correlation Transformation

jjadall1 — Mon, 20 Oct 2014 15:43:18 GMT

Hi Rick,

Do you have a phone number where I can call you to discuss around 1 PM EST?

Thanks!

Jadallah

Re: Correlation Transformation

Rick_SAS — Mon, 20 Oct 2014 16:44:12 GMT

No. I do not give personal advice, but I am happy to answer questions on the online forums.