LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (July 2004, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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


Back to: Top of message | Previous page | Main SAS-L page