PROC COMPARE Question

[OS2Rules]

Hi All:

Quick question -

I have 2 SAS tables that have a lot of variables in them (200+) .  I expect that all variables except 1 are the

same (a datetime value).

Is there a way to run PROC COMPARE on all variables except 1 (like using a EXCLUDE=varname) ?

would rather not use a data step with a "DROP=" if it can be helped.  Also these tables a large so I need

to keep that in mind.

Thanks in advance.

[Tom]

No. You can use the data set option DROP so it will not require a DATA step.

proc compare data=one(drop=ignore_me)  compare=two;

run;

[OS2Rules]

Answered my own question...

use (DROP=variable) on each or the tables in the compare.

I didn't know the DROP= could be user there.....

[DrAbhijeetSafai]

It was such a simple solution (to drop the variable from both sides), but did not click me. Thanks for sharing it. It worked. 

- Dr. Abhijeet Safai

[jakarman]

It has a been a long time ago using that.
Does the datasetoptions (like where) not work and than coding the drop there?. SAS(R) 9.4 Data Set Options: Reference

(did have diner before finishing the message)