## finding values that begin with specific letter---getting error

Solved
Regular Contributor
Posts: 180

# finding values that begin with specific letter---getting error

Hi!

I am trying to identify all values that do not begin with certain letters...and set them to missing.

if patrank ne: ('E','W','O','C','U') then do;
patrank='';
end;

THis gave me an error...

``````3616              if patrank ne: ('E','W','O','C','U') then do;
-                      --
388                    180
200
ERROR 388-185: Expecting an arithmetic operator.

ERROR 180-322: Statement is not valid or it is used out of proper order.

ERROR 200-322: The symbol is not recognized and will be ignored.

3617              patrank='';
3618          end;
---
161
ERROR 161-185: No matching DO/SELECT statement.
``````

Accepted Solutions
Solution
‎08-08-2017 05:57 PM
PROC Star
Posts: 1,337

## Re: finding values that begin with specific letter---getting error

Try in

``  if patrank in : ('E','W','O','C','U') then do;``

All Replies
Solution
‎08-08-2017 05:57 PM
PROC Star
Posts: 1,337

## Re: finding values that begin with specific letter---getting error

Try in

``  if patrank in : ('E','W','O','C','U') then do;``
Super User
Posts: 13,064

## Re: finding values that begin with specific letter---getting error

Or:

```data example;
input patrank \$;
if not ( patrank in : ('E','W','O','C','U') ) then call missing(patrank);
datalines;
This
Other
words
Can
use
Word
case
;
run;```

is the comparison supposed to be case sensitive? If you want to match "case" as well as "Can" then use upcase(patrank) in the comparison.

☑ This topic is solved.