topic Re: Not Contains in SAS Programming

Not Contains

SASACC — Thu, 25 Mar 2010 11:50:17 GMT

if (trim(put(Name,test30.)) not contains ('RICHARD NU')) ;

test30. is a format from format dataset.

When I am trying as above I am getting error as
Syntax error, expecting one of the following: <, <=, =, >, >=, EQ, GE, GT, LE,
LT, NE, NG, NL, ^=, ~=.
but I dont want to use NE . I should use 'not contains' . Is it possible with 'not contains'? Thanks .

Re: Not Contains

Florent — Thu, 25 Mar 2010 11:55:34 GMT

Hi,

The (not) Contains condtion is to be used within a Proc SQL statement and cannot be used within a datastep.

Hope it helps.

Kind regards,
Florent

Example:
--------------
Proc sql;
create table as
select *
from
where (trim(put(Name,test30.)) not contains ('RICHARD NU')) ;
quit;

Re: Not Contains

deleted_user — Fri, 26 Mar 2010 12:44:38 GMT

Excuse me, what it's the difference between NE and not contains ?

Re: Not Contains

sbb — Fri, 26 Mar 2010 13:27:31 GMT

The "NE" operator is either an exact-match or by adding ":" tests a prefix value. The "NOT CONTAINS" tests/scans the specified SAS variable for the argument string, as coded in your example.

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search argument, this topic/post:

+"not contains" site:sas.com

Re: Not Contains

deleted_user — Thu, 31 Aug 2017 18:45:04 GMT

Editor's Note: The CONTAINS operator is valid in a WHERE clause, not an IF statement. As shown by @deleted_user, using the INDEX or the FIND functions provide the closest equivalent. There is also a SAS Note, Sample 43303, that discusses this.

Assuming this is data step code, either one of the find() or index() functions should produce the desired result:

if index((trim(put(Name,test30.)) , 'RICHARD NU');

See the documentation for more details.

Jonathan

> if (trim(put(Name,test30.)) not contains ('RICHARD
> NU')) ;
>
> est30. is a format from format dataset.
>
> When I am trying as above I am getting error as
> Syntax error, expecting one of the following: <, <=,
> =, >, >=, EQ, GE, GT, LE,
> LT, NE, NG, NL, ^=, ~=.
> t to use NE . I should use 'not contains' . Is it
> possible with 'not contains'? Thanks .

Re: Not Contains

C_Ishihara — Thu, 02 Apr 2015 14:47:54 GMT

I use NOT CONTAINS within SAS Miner. I often have to consider the data structure. If the data set is unstructured, like a paragraph of text, NOT CONTAINS often provides you a little more freedom compared to NE to parse the text.