Date:         Mon, 22 Oct 2007 08:40:06 -0700
Reply-To:     "Terjeson, Mark" <Mterjeson@RUSSELL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Terjeson, Mark" <Mterjeson@RUSSELL.COM>
Subject:      Re: Proc COMPARE, output values that are different ?
Comments: To: "Richard A. DeVenezia" <rdevenezia@WILDBLUE.NET>
In-Reply-To:  A<ck3Ti.10$hk.109676@news.sisna.com>
Content-Type: text/plain; charset="us-ascii"

Hi Richard,

Add OUTALL.



Hope this is helpful.


Mark Terjeson
Senior Programmer Analyst, IM&R
Russell Investments


Russell Investments
Global Leaders in Multi-Manager Investing






-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Richard A. DeVenezia
Sent: Monday, October 22, 2007 8:23 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Proc COMPARE, output values that are different ?

Two different programs (OLD and NEW) read some data and perform a
complex
series of operations before arriving at a common structure.  A Proc
COMPARE
is used to check the results.

The following outputs one record per pair of records that contain some
difference.

proc COMPARE
 noprint
 method = percent
 criterion = 0.05
 out = comparisonResults
 outdif
 outnoequal
 base = myOld
 compare = myNew
;
 by category_one category_two;
run;

Combinations of category_one and category_two are unique (primary key)

Old and new are structurally identical (variables X,Y,Z,...) and for the
most part same-valued.  When there are differences, they are due to
certain
classes of reasons.  For instance if the variable X difference is 3 it
is
because X-old=5 and X-new=8.

Regardless of knowning about 5 and 8 situation apriori, situations can
change in the futurre.

Are there COMPARE options that cause the output table to contain the
original data as well as the differences ?

--
Richard A. DeVenezia