topic Re: PROC COMPARE Question in SAS Procedures

PROC COMPARE Question

OS2Rules — Tue, 03 Sep 2013 15:06:25 GMT

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.

Re: PROC COMPARE Question

Tom — Tue, 03 Sep 2013 15:31:07 GMT

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;

Re: PROC COMPARE Question

OS2Rules — Tue, 03 Sep 2013 15:33:42 GMT

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.....

Re: PROC COMPARE Question

jakarman — Tue, 03 Sep 2013 16:09:38 GMT

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)

Re: PROC COMPARE Question

DrAbhijeetSafai — Mon, 01 Apr 2024 10:46:41 GMT

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