Find values that contain _

[sfmeier]

Hello friends,

I am using the following code to find values that contain _

------------------------------------------------------------

proc sql;

/* Ausgabe der KontoIDs, in denen noch Suffices vorhanden sind*/

create table lls_dat.p_Ktomitsuff&stichtag

as select KontoID, KontOhneSuffix

from lls_wrk.P_kos&stichtag

where kontohneSuffix like "^_" escape "^";  

quit;

------------------------------------------------------------

I am getting the following warning. How can I make it work?

Thx, Stefan

------------------------------------------------------------

WARNING: Server is unable to execute the WHERE clause.

[Ksharp]

Hi. Stefan

Are you finding a string which ends with underline '_' ?

It seems that you need another wildcard % to match any characters before '_' .

data a;
a='sdsad_';output;
a='sdsdfs';output;
run;

proc sql;
create table x as 
 select a
  from a
   where a like "%^_" escape "^";  
quit;

Ksharp

[Ksharp · Accepted solution]

If you are looking strings which contain a '_' at anywhere. using contains operation.

proc sql;

create table x as

select a

  from a

   where a contains "_" ; 

quit;

Ksharp