IT seems contains statement can only follow where operator,
But I want to do more operation if the row meet the requirement.
How to fulfill my needs?

On Nov 17, 7:10=A0am, "litonc...@gmail.com" <litonc...@gmail.com> wrote:
> IT seems contains statement can only follow where operator,
> But I want to do more operation if the row meet the requirement.
> How to fulfill my needs?

I believe you are correct that CONTAINS can only be place in a WHERE
statement. You can place a WHERE statement in a dataset, similar to an
IF statement.

data abc;
    set whatever;
    where not (col_A contains "N" and col_B contains "M");
    ... more statements ...
run;

--
Paige Miller
paige\dot\miller \at\ kodak\dot\com

On Nov 17, 6:01=A0am, Paige Miller <paige.mil...@kodak.com> wrote:
> On Nov 17, 7:10=A0am, "litonc...@gmail.com" <litonc...@gmail.com> wrote:
>
> > IT seems contains statement can only follow where operator,
> > But I want to do more operation if the row meet the requirement.
> > How to fulfill my needs?
>
> I believe you are correct that CONTAINS can only be place in a WHERE
> statement. You can place a WHERE statement in a dataset, similar to an
> IF statement.
>
> data abc;
> =A0 =A0 set whatever;
> =A0 =A0 where not (col_A contains "N" and col_B contains "M");
> =A0 =A0 ... more statements ...
> run;
>
> --
> Paige Miller
> paige\dot\miller \at\ kodak\dot\com

or change to index instead:

if index(col_a,'N') and index(col_b,'M') then delete;