topic Re: How to apply LIKE statement in SAS Customer Intelligence

How to apply LIKE statement

keiwo — Fri, 03 Feb 2017 18:24:40 GMT

Hi,

In my SELECT node, I chose a field called "PRICE PLAN DESCRIPTION" and i wanted to select plans descriptions that contained the words

home and phone

How would that be done in the VALUE field within the node.

Thanks,

Re: How to apply LIKE statement

Dmitry_Alergant — Fri, 03 Feb 2017 19:14:31 GMT

Hi,

There are two solutions for your request.

1) The Select node supports applying Like criteria on some data items, but this is not always available. According to the User Guide, the data item must not "contain metadata". In technical terms this means a custom attribute "Metadata=None" specified for this data item in the Information Map Studio.

In this case, however, you will lose an ability to select subscribers by clicking checkboxes in front of a prepopulated list of available price plan descriptions.

If you need both to be able to select descriptions by checkboxes from a list, and apply "LIKE" criteria - you may want to add this column to the information map twice, as two separate ddata items. One will have "metadata" enabled (and so show you checkboxes), and another won't have it and will support the LIKE criteria.

2) As a short-term gap solution to get by before you are able to introduce changes to the information map, you can create a calculated item with a formula like the following:

CASE WHEN

upcase(<<root.Price Plan Description>>) LIKE "%HOME%" or upcase(<<root.Price Plan Description>>) LIKE "%PHONE%"

THEN 1 ELSE 0 END

Best regards, Dmitriy.

Re: How to apply LIKE statement

Mrityunjay_Kuma — Wed, 08 Feb 2017 11:44:05 GMT

Hi,

Use condition

LIKE: %home
and LIKE: %phone

in Selection criteria, See the attachment for CUST_NAME LIKE: %S

Br,

Mrityunjay Kumar

Re: How to apply LIKE statement

keiwo — Wed, 08 Feb 2017 13:52:31 GMT

Hi Dmitry,

within the SELECT node, is this statement valid

Like: %Home%Phone%

Thanks,