Date: Tue, 30 Sep 2008 07:41:00 -0500
Reply-To: "./ ADD NAME=Data _null_," <iebupdte@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "./ ADD NAME=Data _null_," <iebupdte@GMAIL.COM>
Subject: Re: Has anyone got a file compare utility written in sas?
Content-Type: text/plain; charset=ISO-8859-1
For output written to LISTING destination you can do similar to the
suggestion from Nat. Read the files and use PROC COMPARE. I have
used this techniques "successfully" to compare this type of output.
I read each line of the (BASE and COMPARE) files COMPBLed them to
"normalize" them and run PROC COMPARE on the SAS data set.
Appropriate bells and whistles as desired or required. This requires
that the QC output look very much like the production output but that
is much easier to achieve than to check thousands of numbers by eye.
For RTF output you can use the compare documents feature in WORD and
using you favorite Office Automation tool roll it into a report that
suites your needs.
There are a number of SUG, PharmaSUG SGF papers that deal with this also.
On 9/30/08, RolandRB <firstname.lastname@example.org> wrote:
> Has anyone got a file compare utility written in sas? It's not often I
> ask for such a utlity (or macros) since I have collected so many
> macros but such a utility would be useful for validation work on my
> sas macros. This is for "files" and not datasets. Input lengths will
> need to go to maximum line size (256) but if it is not restricted to
> this then so much the better.