Date: Fri, 20 Apr 2001 15:16:25 -0400
Reply-To: Andy Kowalczyk <akowalczyk@WCRINET.ORG>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Andy Kowalczyk <akowalczyk@WCRINET.ORG>
Subject: Re: Finding Differences in 2 Datasets
For a point and shoot approach you may want to try CatalogerV8 from Qualex
Consulting Services, Inc.
<http://www.qlx.com>
It's free! I downloaded it the other day and am playing with it now.
Also from the folks that brought you DBMS/COPY and DBMS/Engines (Conceptual
Software, Inc.) comes a new product: DBMS/Compare
<http://www.conceptual.com/dbmscompare.htm>
If you are a current customer they should have sent you an email with the
password for a 30-day demo (check with your administrator).
I am not connected with either venture.
I still prefer the batch appoach PROC COMPARE since my comparison needs
involve hundreds of pairs of files with hundreds of variables and millions
of rows.
The two interactive products are good at spotting structural differences -
but a little too cumbersome for value differences with this much data.
Andy Kowalczyk
On Fri, 20 Apr 2001 10:00:54 -0600, Darran Zenger <DZENGER@KLUNE.COM> wrote:
>Is there a way to locate the differences between 2 datasets? What I'd like
>to do is create a third dataset from 2, where a variable is NOT EQUAL, such
>as where the Purchase Order numbers are not the same and find out where
>those PO are from within respective datasets. I've tried to do it with SQL
>where PO numbers NE in each case to create a new table but I get the
>following note in my log.
>
>The execution of this query involves performing one or more Cartesian
>product joins that can not be optimized.
>
>Can anyone please explain what this is telling me? I haven't dealt with SQL
>for a couple of years so my mind is a bit rusty.
>
>Thanks.
>
>Darran Zenger
>The SAS System
>Programming
>Klune Industries, INC
>Spanish Fork Division
>dzenger@klune.com
