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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: