topic Re: where() clause with Contains() in Data Filter in SAS Programming

where() clause with Contains() in Data Filter

vitali_pom — Thu, 10 Jul 2014 14:58:18 GMT

Hi,

When I try to do the following, I get an exception:

dt1 << Data Filter(
  add Filter(
  columns(:MyCol),
  Where( contains(:MyCol, "A12") > 0)
  ),
  mode(show(1))
) << invert row selection;

And I get the following exception:

The WHERE clause has not been correctly specified. in access or evaluation of 'Greater'

How to accomplish what the code tries to do properly?

RW9 — Thu, 10 Jul 2014 15:08:47 GMT

Hi,

vitali_pom — Thu, 10 Jul 2014 15:16:30 GMT