topic Re: get names letter with letters in SAS Programming

get names letter with letters

BrahmanandaRao — Wed, 21 Jun 2023 10:40:00 GMT

Hi Guys,

suppose i have employees table in the table which names starts with 'K' and middle letter with 'L' and end with 'K' in employees name column

Re: get names letter with letters

PaigeMiller — Wed, 21 Jun 2023 11:22:19 GMT

@BrahmanandaRao wrote:

suppose i have employees table in the table which names starts with 'K' and middle letter with 'L' and end with 'K' in employees name column

Okay, I am now in my mind supposing that you have this table. What would you like me to do next? Do you have an actual question?

Re: get names letter with letters

Kurt_Bremser — Wed, 21 Jun 2023 11:24:11 GMT

@BrahmanandaRao wrote:

Hi Guys,

suppose i have employees table in the table which names starts with 'K' and middle letter with 'L' and end with 'K' in employees name column

And what is your question?

Re: get names letter with letters

BrahmanandaRao — Wed, 21 Jun 2023 11:40:52 GMT

Those names starts with k and middle letter L and end with k whose names retrive

Re: get names letter with letters

Kurt_Bremser — Wed, 21 Jun 2023 11:44:48 GMT

@BrahmanandaRao wrote:

Those names starts with k and middle letter L and end with k whose names retrive

Yes. And?

Please turn on that thing between your ears and post a question.

Re: get names letter with letters

PaigeMiller — Wed, 21 Jun 2023 11:52:15 GMT

@BrahmanandaRao wrote:

Those names starts with k and middle letter L and end with k whose names retrive

"Names starts with K" — I think I understand that part.

"Middle letter L" — I don't know what "middle letter" means in this context

"End with K" — its not really clear to me what this means in this context either

"Retrive" — this is not a word, and even if it is a simple spelling error, it makes no sense to me in this context either

Please provide sample data (as working SAS data step code) and desired output. Please provide a complete and clear explanation, and not the one-sentence explanation that you usually provide, trying to type as few words as possible. Please be generous with information and generous with your explanation.

Re: get names letter with letters

BrahmanandaRao — Wed, 21 Jun 2023 12:36:51 GMT

/*scenario -1*/

data employees;
  input employee_name $;
  datalines;
John Kilkenny
Kate lark
Kristen Lockhart
Kevin lukasik
Alex King
;
run;

/*senaria-2*/

data employee;
  input name $;
  datalines;
KALAK
KILIK
KULAKzzz
;
run;

first senario- required output

Kate lark

Kevin lukasik

second senario-required output

KALAK KILIK

Note:ignore case

Re: get names letter with letters

Kurt_Bremser — Wed, 21 Jun 2023 12:41:07 GMT

In your first scenario, your INPUT statement reads only one variable, but your DATALINES contain two items each, so the second item won't appear in the dataset and can therefore not be retrieved in a later step anyway.

Re: get names letter with letters

PaigeMiller — Wed, 21 Jun 2023 12:45:10 GMT

I'm afraid I can't understand what you did or why you did it. You have not EXPLAINED. You say you want middle letter 'L' but this is not explained. What do you mean by "middle letter"???

In addition, you have been in this community for years now, and we still have to ask you to show us some example data. This is unacceptable. Please provide example data EVERY SINGLE TIME. Do not make us ask.

Re: get names letter with letters

BrahmanandaRao — Wed, 21 Jun 2023 12:53:02 GMT

data employee;
  input name $;
  datalines;
KALAK
KIpplIK
KULAK
;
run;



proc sql;
  select name
  from employee
  where name like 'K%L%K';
quit;

Re: get names letter with letters

PaigeMiller — Wed, 21 Jun 2023 12:55:02 GMT

I specifically asked for an explanation, not code.

Re: get names letter with letters

BrahmanandaRao — Wed, 21 Jun 2023 13:14:52 GMT

data EmployeeData;
  input EmployeeName $50.;
  datalines;
kith Walkerk
Karen Clark
Mark Black
Emily Parkerk
Steve Brooks
Kelly link
;
run;

Required output with out use regex how to solve

kith Walkerk Karen Clark

Kelly link

Re: get names letter with letters

ballardw — Wed, 21 Jun 2023 15:06:47 GMT

One way to create a data set with the actual values and then select those

data employees;
  infile datalines truncover;
  input employee_name $20.;
  datalines;
John Kilkenny
Kate lark
Kristen Lockhart
Kevin lukasik
Alex King
KALAK
KILIK
KULAKzzz
;
run;

data want;
   set employees;
   
   if upcase(employee_name) =:'K' 
     /*^ upper case compare  ^ "begins with"*/
    and upcase(substr(employee_name,length(employee_name),1))='K'
               /* substr function at length for 1 gets last character*/
      and find(employee_name,'L','i')>0;
          /* find letter L somewhere the 'i' is case insensitive*/
run;

"Middle" can have multiple meanings. I am taking it to mean "somewhere between first and last character" for an L.

The other bits just look at the first and last character for the K's. NOT the only way.

You really need to make sure that your data steps run and produce the desired result for providing example data.

@BrahmanandaRao wrote:
/*scenario -1*/

data employees;
  input employee_name $;
  datalines;
John Kilkenny
Kate lark
Kristen Lockhart
Kevin lukasik
Alex King
;
run;

/*senaria-2*/

data employee;
  input name $;
  datalines;
KALAK
KILIK
KULAKzzz
;
run;
first senario- required output

Kate lark

Kevin lukasik

second senario-required output

KALAK KILIK

Note:ignore case

Re: get names letter with letters

Tom — Wed, 21 Jun 2023 17:40:56 GMT

Testing if the first or last character is a K is easy enough.

For example you could use FINDC().

  startK=1=findc(name,'k','i');
  lastK=length(name)=findc(name,'k',-length(name),'i');

Or just =: operator.

  startK=upcase(name)=:'K';
  lastK=upcase(reverse(strip(name)))=:'K';

Testing if there is an L anywhere the middle can be done with FINDC().

  middleL=1<findc(name,'L','i')<length(name);

Then just require that all three are true.

  want = startK and lastK and middleL ;

Of course if the first and last have to be K then you don't really care where the L is since it will NOT be the first or the last so it will be in the middle.

  want=upcase(name)=:'K'
     and upcase(reverse(strip(name)))=:'K'
     and findc(name,'L','i')
  ;