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