Date: Fri, 9 Nov 2007 21:08:10 -0700
Reply-To: Alan Churchill <savian001@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Alan Churchill <savian001@GMAIL.COM>
Subject: Re: file compare utility
Content-Type: text/plain; charset="iso-8859-1"
Consider pumping it into a text format and using UltraCompare (UltraEdit
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Steve
Sent: Friday, November 09, 2007 8:51 PM
Subject: file compare utility
I am looking for a more robust file compare routine than proc compare. What
I would like is a sas technique that works like the unix DIFF command.
I have two SAS ds, where each row may match or it may have extra rows on
either ds. There is no common key or sort order.
What i would like would be something like.
Proc compare doesnt seem to handle extra rows in either of the two files
unless there is a key (id). There is some written about the diff algorithm,
but they are mostly written in c or such, and Im a SAS guy.
Does anyone have an algorithm that can do this and be adapted to SAS?