It would seem as though a reference to the following book might be in order here

Cody, R. (1999). Cody's data cleaning techniques using SAS software. Cary, NC: SAS Institute inc.

HTH Dennis Fisher

Dennis G. Fisher, Ph.D. Professor and Director Center for Behavioral Research and Services California State University, Long Beach 1090 Atlantic Avenue Long Beach, CA 90813 tel: 562-495-2330 x121 fax: 562-983-1421 http://www.csulb.edu/centers/cbrs

-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Seth StJames Sent: Monday, January 04, 2010 1:41 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: Data Validation/Cleansing Tool Query

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 >