DATA Step, Macro, Functions and more

Find values that contain _

Accepted Solution Solved
Reply
Contributor
Posts: 52
Accepted Solution

Find values that contain _

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.


Accepted Solutions
Solution
‎05-29-2012 06:20 AM
Super User
Posts: 9,671

Re: Find values that contain _

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

View solution in original post


All Replies
Super User
Posts: 9,671

Re: Find values that contain _

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

Solution
‎05-29-2012 06:20 AM
Super User
Posts: 9,671

Re: Find values that contain _

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

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 183 views
  • 3 likes
  • 2 in conversation