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

ginak — Wed, 18 Apr 2012 05:14:29 GMT

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

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

Ksharp — Wed, 18 Apr 2012 06:54:20 GMT

How about :

proc corr data=h.april17;

var _numeric_ ;

run;

Which includes all of your numeric variables.

Ksharp

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

ginak — Wed, 18 Apr 2012 07:56:20 GMT

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.

topic Re: How to apply a command to all but a few variables? in SAS Procedures

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

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

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