How to extract that data contains specific letters in team variable

[BrahmanandaRao]

Hi experts,

Here I want to extract S ,E ,y letters contains team 

for example output

South Africa

Egland

Albany

data dsn;
input team $ 20.;
datalines;
India
India
Australia
South Africa
England
Albany
;
run;

data want;
set dsn;
where team like 'S%' and 'E%' or '_y';
run;

[PaigeMiller]

What is wrong with the code you show? Please explain.

[BrahmanandaRao]

I  didn't get required output

Required output

South Africa

England

Albany

[PaigeMiller]

Please think about this for a minute.

Can a team's name be like 'S%' and also be like 'E%'?

Yes or no? If no, then what is the proper logic, in words, to get the desired result?

[BrahmanandaRao]

Its works
data want;
set dsn;
where team like 'S%' or  team like 'E%' or team like  '%y%';
proc print noobs;
run;




proc sql;
select team from dsn
where team like 'S%' or  team like 'E%' or team like  '%y%';
run;

[donricardo]

Change your code to this and it'll do the trick for you.   Remember, you must fully specify both the variable (team) and the wildcard expression for each value.

data want;
set dsn;
where team like 'S%' or team like 'E%' or team like '%y';