Is there a function that says var not equal to partial character string?

[Hello_there]

data have;
infill datalines dsd dlm=",':
input name $ @@;
red, orange, yellow, blue, green, indigo, violet, purple, turquoise, pink
;
run;

data want;
set have;
if name="p " /* what is a function that deals with partial character strings*/
;
run;

Hi, I'm trying to find a function where I can condition a data step to return back only values that match the partial character string?

could I receive some assistance? thanks

[HB]

There are a lot of ways to do thins i would guess.

I would try

data want;
set have;
match_name = find (name, 'p','i');
if match_name > 0;
drop match_name;
run;

 Returns purple and pink. 

[Reeza]

FIND() 

INDEX()

Colon (=:), if looking for matches at the start of strings.

---

@Hello_there wrote:

data have;
infill datalines dsd dlm=",':
input name $ @@;
red, orange, yellow, blue, green, indigo, violet, purple, turquoise, pink
;
run;

data want;
set have;
if name="p " /* what is a function that deals with partial character strings*/
;
run;

Hi, I'm trying to find a function where I can condition a data step to return back only values that match the partial character string?

could I receive some assistance? thanks

---

[ballardw]

What exactly do you mean by ="p "? That it contains a p anywhere in the string? That the exact string p followed by a space is in the string (which means no matches in your example)? Starts with a p?

You really need to show exactly what you expect for the output as there may be several ways and may not match your need.

[Hello_there]

Hi, sorry for the confusion.

I'm looking for a function that select the colors that start with "p"

[Patrick · Accepted solution]

Like this?

data sample;
  infile datalines dsd dlm=",";
  input name $ @@;
  if upcase(substr(name,1,1))='P';
  datalines;
red, orange, yellow, blue, green, indigo, violet, purple, turquoise, pink
;
run;

 ...or this:

data sample;
  infile datalines dsd dlm=",";
  input name $ @@;
  if upcase(name)=:'P';
  datalines;
red, orange, yellow, blue, green, indigo, violet, purple, turquoise, pink
;
run;

[ChrisNZ]

or

 if upcase(first(NAME))='P';