It is in

SAS Base Software SAS Language Reference: Concepts SAS System concept Expressions Where expressions Syntax of Where Expression

Ya Huang

> -----Original Message----- > From: Metz, Seymour [mailto:smetz@NSF.GOV] > Sent: Friday, June 29, 2001 9:01 AM > To: SAS-L@LISTSERV.UGA.EDU > Subject: Re: Excluding list of values efficiently? > > > I've been looking at the online CD, specifically "SAS > Language Reference: > Dictionary" and didn't see that text. Exactly where did you find it > > > Shmuel (Seymour J.) Metz > > > -----Original Message----- > > From: Huang, Ya [SMTP:ya.huang@Agouron.COM] > > Sent: Friday, June 29, 2001 11:49 AM > > > > Since the discussion for this seems to getting hot, > > I feel it interesting to search SAS Doc and see if on earth > > there is any say regarding the use of NOT IN, and here is what > > I've found in SAS OnlineDoc (CD) > > > > --------------------------- > > IN Operator > > > > The IN operator, which is a comparison operator, searches > > for character and numeric values that are equal to one from a > > list of values. The list of values must be in parentheses, with > > each character value in quotation marks and separated by > > either a comma or blank. > > > > For example, suppose you want all sites that are in North > > Carolina or Texas. You could specify: > > > > where state = 'NC' or state = 'TX'; > > However, the easier way would be to use the IN operator, > > which says you want any state in the list: > > > > where state in ('NC','TX'); > > > > **** In addition, you can use the NOT logical > > **** operator to exclude a list. For example, > > **** where state not in ('CA', 'TN', 'MA'); > > > > So SAS did document this operator, at least in V8 Online Doc. >