topic Re: Find values that contain _ in SAS Programming

Find values that contain _

sfmeier — Tue, 29 May 2012 10:03:12 GMT

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 — Tue, 29 May 2012 10:17:03 GMT

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 — Tue, 29 May 2012 10:20:03 GMT

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