|Date: ||Mon, 4 Jan 2010 13:45:22 -0800|
|Reply-To: ||Dennis Fisher <dfisher@CSULB.EDU>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||Dennis Fisher <dfisher@CSULB.EDU>|
|Subject: ||Re: Data Validation/Cleansing Tool Query|
|Content-Type: ||text/plain; charset="US-ASCII"|
It would seem as though a reference to the following book might be in order
Cody, R. (1999). Cody's data cleaning techniques using SAS software. Cary,
NC: SAS Institute inc.
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
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Seth
Sent: Monday, January 04, 2010 1:41 PM
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
> 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?