Comparing two tables and ignoring specific columns

LittleTurtle — Fri, 14 Dec 2018 20:02:49 GMT

Hi,

So I am comparing two tables to get the difference, but I would like to know how can you compare the two tables but ignore specific columns? For example I want to get compare columns A, B, C and D in both tables except column E and F. In the output table I want all columns, but the differences between A,B,C and D.

Here is the column I have used to compare ALL columns:

Proc SQL;

	create table table_Differences as
	
	/* new file*/
	select * from work.New_File
	
	except

	/* old File*/
	
	select * from work.Old_File;

quit;

Re: Comparing two tables and ignoring specific columns

VDD — Fri, 14 Dec 2018 20:12:26 GMT

proc compare

http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a000146741.htm

topic Re: Comparing two tables and ignoring specific columns in New SAS User

Comparing two tables and ignoring specific columns

Re: Comparing two tables and ignoring specific columns