topic delete rows when a variable contain a string in SAS Procedures

delete rows when a variable contain a string

sasphd — Fri, 08 Mar 2019 19:11:37 GMT

I want to delete rows when a variable name contain a string (INFRA)

have

id name

1 don infra

2 waw

3 sik infra

4 dfh

want

id name

2 waw

4 dfh

Astounding — Fri, 08 Mar 2019 19:17:18 GMT

Does "infra" vs. "INFRA" make a difference? One possibility:

data want;

set have;

if index(upcase(name), "INFRA") = 0;

run;

sasphd — Fri, 08 Mar 2019 19:28:57 GMT

No it does not matter.

however the program does not work. what I want is to delete rows containing the string "infra"

Astounding — Fri, 08 Mar 2019 19:30:46 GMT

So why do you say it does not work?

novinosrin — Fri, 08 Mar 2019 19:33:32 GMT

data have;
input id name & $20.;
cards;
1 don infra
2 waw 
3 sik infra
4 dfh
;

data want;
set have;
if not ^^find(name,'infra','i');
run;

novinosrin — Fri, 08 Mar 2019 19:41:11 GMT

Or with FINDW

data have;
input id name & $20.;
cards;
1 don infra
2 waw 
3 sik infra
4 dfh
;

data want;
set have;
if not ^^findw(name,'infra',' ','i');
run;