Sas how to use like in an if statement

I have a query where i am using the if statement and i need to find the string matching the variable given.

if lead_status in ( '%APPROVED' ,

And this not reading or working.

This is in a data step!.

Appreciate your help and genuine support

1 ACCEPTED SOLUTION
Accepted Solutions Super User

Mark as New
Bookmark
Subscribe
Mute
RSS Feed
Permalink
Print
Report Inappropriate Content

Re: How to use the like operator in sas data step? Posted 08-30-2019 12:37 PM (31508 views) | In reply to codyV

Either modify your program logic so that you can use a WHERE statement instead of an IF statement.

where (x like '%xxx') or (x like '%yyy') ;

Or use some other method to test the values in your IF statement.

Perhaps you can use PRXMATCH() function instead?

As Reeza noted, the like function is not available for IF conditions, but rather for WHERE statements. Also including Ksharp's example of PRXMATCH() syntax:

if prxmatch('/APPROVED$|APPROVAL PENDING$|SEND TO SALES$/i',strip(lead_status));