How to apply a command to all but a few variables?

[ginak]

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

[Ksharp · Accepted solution]

How about :

proc corr data=h.april17;

var _numeric_ ;

run;

Which includes all of your numeric variables.

Ksharp

[ginak]

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.