topic Re: LIKE '%' does not work in SAS Programming

LIKE '%' does not work

bncoxuk — Wed, 14 Mar 2012 17:06:01 GMT

Hi,

I intend to select those cases which satisfy:

IF regno LIKE ('M%15', 'M%25', 'M%30', 'DISC') THEN OUTPUT;

However, this code is wrong.

How can I accomplish this? Thanks a lot.

LIKE '%' does not work

Reeza — Wed, 14 Mar 2012 17:18:53 GMT

You can only use LIKE in a WHERE clause not an if.

LIKE '%' does not work

FriedEgg — Wed, 14 Mar 2012 17:28:08 GMT

The like operator is not available to the if statement only where clauses also I am quite sure it cannot be combined with the in operator to have a list of values.

LIKE '%' does not work

Ksharp — Thu, 15 Mar 2012 06:42:11 GMT

An alternative way is to use perl regular expression.

IF prxmatch('/M.*15|M.*25|M.*30|DISC/',regno) THEN OUTPUT;

Ksharp

Re: LIKE '%' does not work

rosietav — Tue, 27 Jan 2015 16:58:56 GMT

For what it's worth, I found that using CASE within a PROC SQL SELECT statement worked for me. Sharing the example code in case it is useful.

PROC SQL;
CREATE TABLE SET_A AS

SELECT *, (CASE

WHEN FIELD LIKE 'APPL%' THEN 'A'

WHEN FIELD LIKE 'SYS%' THEN 'B'

ELSE ''

END

)

AS NEW_FIELDNAME

FROM SOURCE_TABLE

WHERE OTHER_CRITERIA = 'XXX';

RUN;