Hello, I am trying to use the “if” and “like” statement to create a new column called “new_column” based on the character values of “column1”. But I get an error (see below). I am trying to use the “Like” statement but does not seem to work with “if” statement. Please advice on an alternative approach. Thanks!
Column1 is a character column and I am trying to create another character column called “column1” based on column1 values values.
---current code--- data want; set have; if upcase(column1) like "SPEC%" then new_column = "Specialty"; run;
I get the following error:
Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, ;, <, <=, <>, =, >, ><, >=, AND, EQ, GE, GT, 2 The SAS System 11:46 Friday, April 3, 2020
IN, LE, LT, MAX, MIN, NE, NG, NL, NOT, NOTIN, OR, THEN, ^, ^=, |, ||, ~, ~=.
ERROR 76-322: Syntax error, statement will be ignored.
... View more