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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.