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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.