Date:         Mon, 4 Jan 2010 16:40:38 -0500
Reply-To:     Seth StJames <sethstjames@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Seth StJames <sethstjames@GMAIL.COM>
Subject:      Re: Data Validation/Cleansing Tool Query
Comments: To: Jonathan Goldberg <jgoldberg@biomedsys.com>
In-Reply-To:  <201001042043.o04BkhHs010400@malibu.cc.uga.edu>
Content-Type: text/plain; charset=ISO-8859-1

Have to agree will the others here, but if you ever move to SDD, then SAS
does an excellent job of doing this for programmers and non-programmers.



On Mon, Jan 4, 2010 at 3:43 PM, Jonathan Goldberg
<jgoldberg@biomedsys.com>wrote:

> We are currently using SAS to do validation.  We write programs to check
> things like ranges, all fields present, etc., etc..
> Since this is a clinical trials environment it is also necessary to check
> across records for visit squence, missing visits, etc..
>
> While we have a lot of this packaged into macros, it seems to me that
> there should be tools available that allow non-programmers to do a lot
> (preferably, all) of this.  It seems a waste to need programmers to do
> something so low-level.
>
> Anyone have suggestions for products that might fill the bill?
>
> TIA.
>
> Jonathan
>