BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
ginak
Quartz | Level 8

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

1 ACCEPTED SOLUTION

Accepted Solutions
Ksharp
Super User

How about :

proc corr data=h.april17;

var _numeric_ ;

run;

Which includes all of your numeric variables.

Ksharp

View solution in original post

2 REPLIES 2
Ksharp
Super User

How about :

proc corr data=h.april17;

var _numeric_ ;

run;

Which includes all of your numeric variables.

Ksharp

ginak
Quartz | Level 8

thank you!!!!!!! that's what i was looking for Smiley Happy Unfortunately I have a lot of numeric variables so it's not easy to read haha.

sas-innovate-2024.png

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.

 

Register now!

What is Bayesian Analysis?

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 818 views
  • 0 likes
  • 2 in conversation