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.
Use the WITH statement :
proc corr data=myData;
var Var1;
with var2-var99;
run;
PG
Use the WITH statement :
proc corr data=myData;
var Var1;
with var2-var99;
run;
PG
Thanks!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.