Proc Corr - One variable with all others

Accepted Solution Solved
Reply
Contributor AD
Contributor
Posts: 31
Accepted Solution

Proc Corr - One variable with all others

I have a large dataset and I am interested in the pearson correlations between one variable (let's call it Var1) and all the other variables in the dataset (Var2, Var3,... , VarN).  I am not interested in all the correlations between all the "other" variables (e.g., Var2 with Var3, Var2 with Var4, Var2 with VarN, etc...).

I realize that if I include all the variables in the Var statement in Proc Corr that I can get all the information I am looking for.  And I can use ODS to output the results and data steps to get rid of the information I don't need.  The reason for this post is that I don't SAS to have to compute all those correlations if possible, as this is a really large dataset and will require a lot of processing time and power.


Accepted Solutions
Solution
‎01-07-2013 04:15 PM
Respected Advisor
Posts: 4,919

Re: Proc Corr - One variable with all others

Use the WITH statement :

proc corr data=myData;

var Var1;

with var2-var99;

run;

PG

PG

View solution in original post


All Replies
Solution
‎01-07-2013 04:15 PM
Respected Advisor
Posts: 4,919

Re: Proc Corr - One variable with all others

Use the WITH statement :

proc corr data=myData;

var Var1;

with var2-var99;

run;

PG

PG
Contributor AD
Contributor
Posts: 31

Re: Proc Corr - One variable with all others

Thanks!

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 2137 views
  • 1 like
  • 2 in conversation