topic Re: How to extract that data contains specific letters in team variable in SAS Programming

How to extract that data contains specific letters in team variable

BrahmanandaRao — Fri, 03 Nov 2023 11:21:20 GMT

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;

Re: How to extract that data contains specific letters in team variable

PaigeMiller — Fri, 03 Nov 2023 11:04:31 GMT

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

Re: How to extract that data contains specific letters in team variable

BrahmanandaRao — Fri, 03 Nov 2023 11:06:47 GMT

I didn't get required output

Required output

South Africa

England

Albany

Re: How to extract that data contains specific letters in team variable

PaigeMiller — Fri, 03 Nov 2023 11:33:00 GMT

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?

Re: How to extract that data contains specific letters in team variable

BrahmanandaRao — Fri, 03 Nov 2023 12:02:41 GMT

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;

Re: How to extract that data contains specific letters in team variable

donricardo — Tue, 07 Nov 2023 20:21:17 GMT

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';