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 (June 2004, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Sat, 5 Jun 2004 08:38:33 -0400
Reply-To:   "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
Subject:   Re: where notin...

Adriano Rodrigues wrote: > IN this code: > > proc print; > var p1a p1b; > where p1a notin (2,3,4); > run; > > if i want notin range 2 to 10, i need write 2,3,4,5,6,7,8,9,10??

not in (2,3,4,5,6,7,8,9,10) only works if p1a is guaranteed to be a number with zero fractional part. i.e. If p1a=2.5, it would sneak through.

not between 2 and 10 is more likely what you want to use (since you mention range) between includes the endpoints, so not between excludes the endpoints

-- Richard A. DeVenezia http://www.devenezia.com/downloads/sas/samples


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