Date:         Mon, 26 Jul 2004 15:12:40 +0200
Reply-To:     "Groeneveld, Jim" <jim.groeneveld@VITATRON.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Groeneveld, Jim" <jim.groeneveld@VITATRON.COM>
Subject:      Re: correcting datasets, proc print
Comments: To: Adriano Rodrigues - Instituto GPP <adriano@GPP.COM.BR>
Content-Type: text/plain; charset="iso-8859-1"

Hi Adriano,

You might use formats, where the (unconditionally) illegal values are clearly indicated (e.g. [., 99 - high = 'illegal']. Based on that kind of output you could search for the individual, illegal values.

Regards - Jim.
--
.  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .

Jim Groeneveld, MSc.
Biostatistician
Science Team
Vitatron B.V.
Meander 1051
6825 MJ  Arnhem
Tel: +31/0 26 376 7365
Fax: +31/0 26 376 7305
Jim.Groeneveld@Vitatron.com
www.vitatron.com

My computer says 'beep'. What's wrong with that? It's talking too much!

[common disclaimer]


-----Original Message-----
From: Adriano Rodrigues - Instituto GPP [mailto:adriano@GPP.COM.BR]
Sent: Saturday, July 24, 2004 13:57
To: SAS-L@LISTSERV.UGA.EDU
Subject: correcting datasets, proc print


Hi all,

I received a lot of datasets with a lot of inconsisnteces. I need to look for all errors with simple steps like:

proc print data=brad;

var p171a p18a1 p19a1 p20a1 p21a p25 p27b p28a p29 p30a p31a;

where p171a=0 or p18a1=. or p19a1=. or p20a1=. or p21a=. or p25=. or p27b=30

or p28a=20 or p29=. or p30a=. or p30a=52 or p31a=50 or p31a=.;

run;

I dont have a big problem, but i want to highlight the errors, because when one record is printed, i need to look where is the error (in wich variable).

Of course i can use where only to one variable each time, but have a simple way to highlight what i am looking for?

Thx in advance,
Adriano