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.
Try in
if patrank in : ('E','W','O','C','U') then do;
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.