topic Proc Compare in SAS Enterprise Guide

Proc Compare

deleted_user — Thu, 08 Jan 2009 14:03:19 GMT

i am comparing two sas data set A and B. like

proc compare base = lib.A compare = lib.B out=lib.c;
quit;

On running this proc step in C data set i get all columns name.

i don't want this.

i want to store the name of those columns whose value is not equal, in data set C.

Re: Proc Compare

sbb — Fri, 09 Jan 2009 22:04:38 GMT

You will want to review the SAS PROC COMPARE options. The SAS support website http://support.sas.com/ has a wealth of technical papers and SAS-hosted documentation on this topic.

Scott Barry
SBBWorks, Inc.

SAS PROC COMPARE documentation:

http://support.sas.com/onlinedoc/913/getDoc/en/proc.hlp/a000057814.htm