topic Re: Is there a function that says var not equal to partial character string? in SAS Programming

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

Hello_there — Tue, 01 Mar 2022 18:42:45 GMT

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

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

HB — Tue, 01 Mar 2022 19:11:00 GMT

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.

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

Reeza — Tue, 01 Mar 2022 19:10:35 GMT

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

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

ballardw — Tue, 01 Mar 2022 21:46:40 GMT

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.

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

Hello_there — Wed, 02 Mar 2022 00:35:59 GMT

Hi, sorry for the confusion.

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

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

Patrick — Wed, 02 Mar 2022 00:43:16 GMT

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;

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

ChrisNZ — Wed, 02 Mar 2022 02:02:26 GMT

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