Hello,
I'm trying to run proc corr on all but a few variables. Most of my variables are numeric (well, they weren't before, but I just converted from character to numeric), so I wanted to run:
proc corr data=h.april17;
var _all_ ;
run;
But when I run this, My log gives me this:
ERROR: Variable EX_COM in list does not match type prescribed for this list.
ERROR: Variable EX_OTR in list does not match type prescribed for this list.
ERROR: Variable organization in list does not match type prescribed for this list.
ERROR: Variable site_name in list does not match type prescribed for this list.
ERROR: Variable othocc in list does not match type prescribed for this list.
ERROR: Variable Q12 in list does not match type prescribed for this list.
ERROR: Variable Q13 in list does not match type prescribed for this list.
ERROR: Variable Q69g in list does not match type prescribed for this list.
How can I run this proc corr on all my variables except for the above 8 variables?
Thanks,
Gina
How about :
proc corr data=h.april17;
var _numeric_ ;
run;
Which includes all of your numeric variables.
Ksharp
How about :
proc corr data=h.april17;
var _numeric_ ;
run;
Which includes all of your numeric variables.
Ksharp
thank you!!!!!!! that's what i was looking for Unfortunately I have a lot of numeric variables so it's not easy to read haha.
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 the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.