When you set the criteria in a decision-campaign Filter node, it is possible to select a LIKE operator.

The LIKE operator selects records by comparing character strings with a pattern-matching specification.

The percent sign (%) is used as a wild card and matches any sequence of zero or more characters.

Therefore, you can create criteria such as the following:

If, for example, the campaign name has a value of 1A, 2A, or XA, then the record is selected.

However, a problem occurs in the pattern-matching specification when the character string contains two consecutive instances of the same character (A in the example above) that follows the percent sign.

So, in the example above, if the campaign Name has a value of AA, then the match fails and the record is not selected.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for SAS Decision Services 6.3 is available at:

A fix for this issue for SAS Decision Services 5.6 is available at: